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.

Amazon EC2 T9g instances based on Graviton5

https://aws.amazon.com/about-aws/whats-new/2026/11/ec2-t9g-instances-ga/
1•gslin•46s ago•0 comments

Hackable $20 Modem Combines LTE and Pi Zero W2 Power

https://hackaday.com/2022/08/03/hackable-20-modem-combines-lte-and-pi-zero-w2-power/
1•toomuchtodo•2m ago•0 comments

Do you have a selkie or a seal in the family? Essays

https://aeon.co/essays/do-you-have-a-selkie-or-a-seal-in-the-family
1•rbanffy•4m ago•0 comments

Mind the Gap

https://www.geoffreychallen.com/essays/2026-11-16-mind-the-gap
1•speckx•5m ago•0 comments

Nvidia accounting under SEC investigation, sources say

https://finance.yahoo.com/markets/article/nvidia-stock-extends-25-trillion-rout-as-sec-probe-repo...
3•ftchd•5m ago•1 comments

How Micro1 promotes its business-data acquisitions: "Call Bruce: 1-800-800-DATA"

https://twitter.com/micro1_ai/status/2123849880426926402
1•MilnerRoute•5m ago•0 comments

Show HN: OpenComputer – an open source alternative to Devin

https://github.com/diggerhq/opencomputer
1•iacguy•7m ago•0 comments

Trump threatens ban on US firms building AI data centres overseas

https://www.bbc.co.uk/news/articles/cmde1lw9y54ko
2•4ndrewl•8m ago•0 comments

Walls Beneath Jerusalem May Solve 150-Year Mystery

https://www.discovermagazine.com/two-walls-beneath-jerusalem-may-solve-a-150-year-mystery-about-r...
3•hackthemack•9m ago•0 comments

Why San Francisco's water system couldn't handle a record-breaking storm

https://www.sfgate.com/bayarea/article/sf-flooding-sewers-22540612.php
1•mikhael•9m ago•0 comments

Supporting Private and Efficient Consumer Requests to Data Brokers

https://dl.acm.org/doi/10.1145/3847192.3847365
1•wyes•10m ago•0 comments

Changes Coming to Google Assistant and Nest App

https://support.google.com/googlehome/thread/478236207/a-modern-foundation-for-your-smart-home-ch...
2•ChrisArchitect•13m ago•0 comments

Predictions of the End of Wikipedia

https://en.wikipedia.org/wiki/Predictions_of_the_end_of_Wikipedia
6•Sir_Twist•14m ago•0 comments

Inkling 2 Mini

https://thinkingmachines.ai/news/inkling-2-mini/
24•jasondavies•15m ago•1 comments

Combatting Adversarial Distillation

https://openai.com/index/combatting-adversarial-distillation/
3•pretext•16m ago•0 comments

And Yet, It Moves

https://signoregalilei.com/2026/11/20/and-yet-it-moves/
1•notfried•19m ago•0 comments

Monkeys, Libraries, and AI

https://abitwired.substack.com/p/monkeys-libraries-and-ai
1•abitwired•20m ago•0 comments

Reverse Engineering my cat's litter box

https://master--ytulsiani.netlify.app/blog/furrytails/
1•allidoisvim•20m ago•0 comments

DreamCoder: Coding harness and IDE from the author of Mastering Emacs

https://www.masteringemacs.org/article/announcing-dreamcoder
1•facundo_olano•23m ago•0 comments

Intel Preps Linux 7.5 Change to Better Handle Multiple GPUs with Lots of VRAM

https://www.phoronix.com/news/Linux-7.5-DRM-8TB-mmap
1•Bender•24m ago•0 comments

The stochastic parrots have apparently proved the Riemann Hypothesis

https://scottaaronson.blog/?p=10344
2•stratos123•24m ago•0 comments

Anthropic's Alpoge claims Claude found Riemann proof

https://thecondia.com/anthropic-alpoge-claude-riemann-proof/
2•Andassyn•25m ago•1 comments

Army delays detonating "catastrophically hazardous" lead azide amid fear, anger

https://arstechnica.com/science/2026/11/outrage-questions-swirl-as-army-delays-blowing-up-stockpi...
2•Bender•25m ago•1 comments

Hyper-realistic World War 2 FPS made by Claude

https://hng-production-47bb.up.railway.app/
1•josiahturnq•26m ago•2 comments

Prisons get OK to jam contraband phones. CTIA says nearby phones will be jammed

https://arstechnica.com/tech-policy/2026/11/prisons-get-ok-to-jam-contraband-phones-ctia-says-nea...
2•Bender•26m ago•0 comments

Intel 18A yields hit 70% as company signs Microsoft as EMIB customer

https://www.tomshardware.com/tech-industry/semiconductors/intel-18a-yields-hit-70-percent-as-comp...
2•rbanffy•26m ago•0 comments

Show HN: A browser game about trying to join a meeting

https://a.drien.com/games/ceci-nest-pas-du-travail/
1•macNchz•27m ago•0 comments

Show HN: Prefixwise 0.12 – a paper and a spec for why prompt caches miss

https://github.com/tejachavali/prefixwise
1•tchavali•28m ago•0 comments

Show HN: ArkViz – AI generated software architecture diagrams

https://arkviz.io
1•bofia•29m ago•0 comments

Slow inefficient (non-derogatory) guestbook

https://kwon.nyc/notes/slow-inefficient-non-derogatory-guestbook/
1•NaOH•29m ago•0 comments