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.

Clojure will affect the way you think about programming (2017)

https://eli.thegreenplace.net/2017/clojure-the-perfect-language-to-expand-your-brain/
1•sammatilda•2m ago•0 comments

The FBI was hacked again

https://www.cnn.com/2026/11/20/politics/fbi-hacked-again-target-crime-database
1•negura•3m ago•0 comments

Omacom Foundation to Sponsor Aurora Silicon

https://omarchy.org/news/2026/11/omacom-foundation-to-sponsor-aurora-silicon/
1•porjo•3m ago•0 comments

Putin was the real winner at the trilateral summit

https://www.ft.com/content/8f24b313-1b9a-401d-88e6-089aedc72519
1•petethomas•6m ago•0 comments

Clawdcursor Beats computer-use at every benchmark

https://clawdcursor.com
1•AmDab•7m ago•0 comments

Discord Rewrites Desktop and Mobile Clients in Rust

https://www.infoq.com/news/2026/11/discord-rust-rewrite-gpui-zed/
1•fork-bomber•16m ago•0 comments

Phoebe Bridgers banned phones at gigs; fans use art to remember them

https://www.bbc.co.uk/news/articles/cq7821d0pv49o
1•dofm•17m ago•1 comments

Verifying formal models of Raft implementations

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

Anthropic mathematician claims to prove Riemann hypothesis

https://www.scientificamerican.com/article/anthropic-mathematician-claims-to-prove-riemann-hypoth...
1•kwar13•19m ago•0 comments

OpenAI: Generating scripts to copy outgoing email to an unauthorized address

https://openai.com/safety-alignment/misalignment-reports/generating-scripts-to-copy-outgoing-emai...
1•mjlawson•23m ago•1 comments

Experts warn: Everyone in AI is susceptible to a honey-trap scheme

https://techcrunch.com/2026/11/20/experts-warn-nearly-everyone-in-ai-is-susceptible-to-a-honey-tr...
1•inthebay•23m ago•0 comments

American State Capitalism Helped Produce the Nvidia Scandal

https://www.wsj.com/economy/american-state-capitalism-helped-produce-the-nvidia-scandal-56ce6dee
2•JumpCrisscross•24m ago•1 comments

Show HN: Lightweight FUSE-based encrypted, compressed filesystem for Linux

https://github.com/tgaloppo/obfusecate
1•tgaloppo•25m ago•0 comments

Midpoint Generative Models

https://arxiv.org/abs/2605.29920
2•E-Reverance•26m ago•0 comments

Paper Sound Simulator

https://av.github.io/paper/
1•everlier•27m ago•0 comments

Planned Lead Azide Detonation Fact Sheet – November 23, 2026

https://hhs.iowa.gov/media/19822/download?inline
1•eth0up•29m ago•0 comments

Army is about to blow up a cache of dangerous lead azide in Iowa

https://www.scientificamerican.com/article/the-u-s-army-is-about-to-blow-up-a-cache-of-dangerous-...
3•eth0up•31m ago•3 comments

What is the generalized Riemann hypothesis? The claim behind two rival proofs

https://www.nacionale.com/en/articles/what-is-generalized-riemann-hypothesis-grh-explained-alpoge...
1•doener•42m ago•0 comments

Show HN: Paper Trail – Local work records

https://chromewebstore.google.com/detail/paper-trail-—-local-work/glpahjppiibjanjkknphegmlmindi...
1•cflsdf•45m ago•0 comments

Show HN: Food Sound · White Noise ShiYin

https://nonloop.github.io/crunchy/
1•cflsdf•46m ago•0 comments

Portkey Security Incident

3•redrix•50m ago•0 comments

Why Does Windows Use Backslash as Path Separator? (2019)

http://www.os2museum.com/wp/why-does-windows-really-use-backslash-as-path-separator/
3•sammatilda•56m ago•0 comments

Show HN: AbcTab – Native Swift 6 macOS ⌘-Tab Switcher Without Screen Recording

https://solocraft.app/abctab
1•addozhang•56m ago•0 comments

Show HN: Name the World – An Atlas Quiz

https://nametheworld.starshadowx2.workers.dev/
1•starshadowx2•57m ago•0 comments

Pint – Windows NT 4.0 Ported to Raspberry Pi

https://github.com/tenox7/pint
2•majorchord•58m ago•0 comments

Show HN: Find and serve fast LLM config for your GPU

https://github.com/Aagam-Bothara/rigtune
2•Rogansempai•1h ago•0 comments

Show HN: yavcpdf - A keyboard-driven, vibecoded PDF viewer

https://github.com/araaha/yavcpdf
1•Ithinkthatsnice•1h ago•0 comments

Anthropic's IPO bank closed position meant to stabilize stock, removing support

https://www.reuters.com/markets/us/anthropics-ipo-bank-closed-position-meant-stabilize-stock-remo...
3•greatgib•1h ago•1 comments

Show HN: Voxstead – Live captions and bilingual call assistance for macOS

https://github.com/TriHerm/voxstead
2•abishai33•1h ago•0 comments

Show HN: Pstview – read-only PST/OST viewer

https://github.com/publicarray/pstview
3•publicarray•1h ago•0 comments