frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

What Happens When You Drop a Column in Postgres

https://www.thenile.dev/blog/drop-column
6•gwen-shapira•1y ago

Comments

gwen-shapira•1y ago
When you run ALTER TABLE test DROP COLUMN c Postgres doesn't actually go and remove the column from every row in the table. This can lead to counter intuitive behaviors like running into the 1600 column limit with a table that appears to have only 2 columns.

I explored a bit what dropping columns actually does (mark the column as dropped in the catalog), what VACUUM FULL cleans up, and why we are still (probably) compliant with the GDPR.

Netanyahu rival condemns 'Jewish terrorism' after settler attacks

https://www.theguardian.com/world/2026/nov/22/netanyahu-rival-condemns-settler-arson-attacks-pale...
1•Betelbuddy•22s ago•0 comments

Impact of artificial gravity on spaceflight skeletal deterioration in mice

https://www.nature.com/articles/s41526-026-00670-5
1•archermarks•58s ago•0 comments

MacBook Trackpad Talking Using Its Haptic Motor

https://twitter.com/codycollier/status/2124505859883716918
1•sgt•1m ago•0 comments

A pay-once alternative to subscription AI photo trend apps

https://flowood.app
1•dogcaname•1m ago•0 comments

26 AI agents rewrote a backend from Django to Rust with no human merges

https://airepublic.com/blog/pi-dash-self-evolution-experiment/
1•vihoang•2m ago•0 comments

Harvard CS 2881R AI Safety

https://boazbk.github.io/mltheoryseminar/
2•enjoyyourlife•9m ago•0 comments

License to Gill (James Pond 2 Recomp)

https://joelio.github.io/robocod-recomp/
2•_joel•11m ago•1 comments

Attackers can trigger your trailer brakes on the road

https://garrettstimpson.ca/posts/2026/11/22/elecbrakes-trailer-brake-controller-bluetooth-flaw/
3•gary23w•11m ago•0 comments

Solving a legendary math problem with AI be a candidate for a Fields Medal?

3•DivingForGold•12m ago•1 comments

GTA 6 Hates America. So Why Does America Love It? [video]

https://www.youtube.com/watch?v=ikUM_mnUVgc
2•abdelhousni•12m ago•0 comments

Show HN: I built a command center to assess your personal security posture

https://installplango.com
4•rstureborg•13m ago•2 comments

Run tool calls from code with Code Mode

https://code.claude.com/docs/en/code-mode
1•franze•14m ago•0 comments

Domesticity and Danger: Harvard Law's "Canine Framework" for AI Liability

https://news.harvard.edu/gazette/story/2026/07/is-that-bot-a-pomeranian-or-a-wolf-and-who-to-sue-...
1•datascientist•16m ago•0 comments

Show HN: Loomstation – Read-only analytics terminal, MCP for Polymarket/Kalshi

https://loomstation.com/
1•offbeatlj•17m ago•0 comments

Falsehoods Programmers Believe About ATProto

https://reiver.link/atproto/falsehoods-programmers-believe/
1•todsacerdoti•19m ago•0 comments

Climate change talks fall apart in final hours over fossil fuels

https://www.npr.org/2026/11/22/nx-s1-6046195/cop31-climate-talks-close-disappointment
2•blinding-streak•19m ago•0 comments

TSMC acquires 0.03% stake in Anthropic for US$500M

https://www.taipeitimes.com/News/biz/archives/2026/11/20/2003868042
2•giuliomagnifico•20m ago•0 comments

AI Is Testing What Economists Know About Bubbles

https://www.bloomberg.com/news/articles/2026-11-20/is-ai-a-bubble-what-economists-know-about-mark...
2•helsinkiandrew•20m ago•2 comments

Uncorrelated Perspectives

https://sive.rs/portfolio
2•Curiositry•24m ago•0 comments

Teaching a Web Page to Read a Chess Board

https://dennisforbes.ca/blog/2026/11/reading_a_chess_board_from_a_picture/
1•llm_nerd•26m ago•0 comments

WSJ, Streetwise: Has the AI Bubble Already Burst?

https://www.wsj.com/finance/stocks/has-the-ai-bubble-already-burst-2f1dcca8
1•levzettelin•27m ago•0 comments

Actually, You Could Possibly

https://justismills.substack.com/p/actually-you-could-possibly
1•paulpauper•30m ago•0 comments

Videogames are NOT a waste of time?

https://benedictide.com/posts/toolong2/
1•paulpauper•31m ago•1 comments

Show HN: Gitfold – every Git branch as a folder, ready in a second

https://github.com/pkukielka/gitfold
1•pkuki•32m ago•0 comments

Ask HN: State of the Captcha

3•basilikum•32m ago•0 comments

Show HN: Mapped wild edible plants and fungi near you

https://edibilia.org/map
1•sriacha•33m ago•0 comments

Verifying formal models of Raft implementations

https://antithesis.com/blog/2026/verifying-formal-models/
1•birdculture•33m ago•0 comments

Coding Adventure: Chess [video]

https://www.youtube.com/watch?v=U4ogK0MIzqk
1•ansipunk•36m ago•0 comments

Show HN: World Map Chess – Turn-based strategy on a 235-country map

https://treegame.net/quick-play/world-map-chess
1•rashidiub786•37m ago•0 comments

Was software just always too complex for humans?

https://anil.recoil.org/notes/software-too-complex-for-humans
4•nathcd•38m ago•2 comments