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.

Three breaches, endless leaks: Your AI supply chain needs canaries

https://www.dragos.com/blog/ai-supply-chain-security-canary-tokens
1•qznc•5m ago•0 comments

Show HN: Factory worker maps AI safety arguments and open questions

https://huggingface.co/datasets/AegisSolis/aegis-solis-crosswalk-rc9-public-research
1•aegissolis•6m ago•0 comments

Microtonal BitcoinCash Transaction Sonifier and Visualizer

https://spiritsofbitcoin.cash/
1•jlmoriart•6m ago•1 comments

Show HN: Jane Street's Socratic Tutor Demo

https://try-now.pages.dev/socratic-tutor/
1•david_2107•8m ago•0 comments

Show HN: PocketTransfer – iPhone to PC/Mac file transfer in the browser

https://pockettransfer.app/
1•wentalau•9m ago•0 comments

Super-hot rock geothermal could end data center energy woes

https://techcrunch.com/2026/11/20/super-hot-rock-geothermal-could-end-data-center-energy-woes/
1•Brajeshwar•9m ago•0 comments

Tracing the Emergence of Extreme Ultraviolet Lithography (CSET, 2024) [pdf]

https://cset.georgetown.edu/wp-content/uploads/CSET-Tracing-the-Emergence-of-Extreme-Ultraviolet-...
1•0sake_rs•9m ago•1 comments

Anthropic's IPO raises questions about AI safety and shareholder pressure

https://apnews.com/article/anthropic-history-openai-dario-amodei-ipo-53fb21bd250b936d93c5c8885af8...
3•ComputedCamp995•15m ago•1 comments

Fokus, a local macOS site blocker and screen time tracker with an MCP server

https://github.com/Jnooo-cloud/fokus
1•Janooo•16m ago•0 comments

Spacecraft reaches Mercury on second-ever mission to enter its orbit

https://www.theguardian.com/science/2026/nov/20/spacecraft-mercury-second-ever-mission-orbit-bepi...
1•geden•17m ago•0 comments

SleepyTube – make YouTube sound and look sleepier (Chrome extension)

https://github.com/kandekar007/sleepytube
1•adi-kandekar•17m ago•1 comments

Removing binder.c

https://lwn.net/Articles/1102982/
1•signa11•21m ago•0 comments

More Suicides at Spy, Cyber Agencies Scrutinized by Congress

https://www.bloomberg.com/news/articles/2026-11-10/more-suicides-at-spy-cyber-agencies-scrutinize...
2•_tk_•29m ago•0 comments

Show HN: Learnmap, learn programming in a playful way

https://learnmap.sh
1•erikpau•33m ago•0 comments

GameShark, cheat devices, and PlayStation runtime function patching

https://generalreasoning.com/blog/2026/11/19/gameshark-patching.html
1•skimdesk•33m ago•0 comments

Dragons and Serpents in Sussex

http://www.sussexarch.org.uk/saaf/dragon.html
1•zeristor•36m ago•0 comments

Maestri – Infinite canvas for orchestrating agents

https://www.themaestri.app/en
2•surrTurr•36m ago•1 comments

Trump vows to prevent US companies from building data centres abroad

https://www.cnbc.com/2026/11/20/trump-data-centers-ai-companies-tax.html
1•niemandhier•37m ago•0 comments

Notion – A New Shape for Work

https://www.notion.com/a-new-shape-for-work
1•simianwords•39m ago•0 comments

Proof of the Riemann Hypothesis [01/01/2026]

https://robertedwardgrant.com/proof-of-the-riemann-hypothesis-a-geometric-constraint-on-prime-flu...
1•fred_the_chair•41m ago•0 comments

Gemini training on chats opt-out is finally here

https://support.google.com/gemini/answer/13594961?hl=en
2•adinafxv•42m ago•1 comments

What's the difference between an integer and a pointer?

https://blog.regehr.org/archives/1621
1•germanrabbit•42m ago•0 comments

Why Are Universal Sockets Dangerous?

https://oeelectrics.co.uk/universal-sockets-a-dangerous-convenience/
1•nomilk•45m ago•0 comments

Google rolls out new search homepage with AI chat history and no search button

https://arstechnica.com/ai/2026/11/googles-latest-search-page-redesign-drops-the-search-button-ad...
2•Brajeshwar•52m ago•0 comments

Jensen Huang in 2009: The Charlie Rose Interview [video]

https://www.youtube.com/watch?v=g28jKBvhN9k
2•jonbaer•52m ago•1 comments

RCE in Gnupg

https://lists.gnupg.org/pipermail/gnupg-announce/2026q4/000517.html
3•gdgghhhhh•59m ago•0 comments

Exascale fusion simulation team named finalist for 2026 Gordon Bell Prize

https://www.alcf.anl.gov/news/exascale-fusion-simulation-team-named-finalist-2026-gordon-bell-prize
2•rbanffy•59m ago•0 comments

Álvaro Herrera: Squeezing tables with Postgres 19

https://www.enterprisedb.com/blog/squeezing-tables-postgres-19
4•bashhq_r•1h ago•0 comments

Show HN: RMRFBench – How often AI agents wreck a server when asked to rm a file

https://www.rmrfbench.com/
1•eadz•1h ago•1 comments

Moving from VMware Fusion on macOS 27

https://scaleninja.com/blog/vmware-fusion-macos-27/
2•onzr•1h ago•0 comments