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.

Majority of Anthropic's over 5k employees expected to become millionaires

https://www.wsj.com/tech/ai/thousands-of-anthropic-employees-and-investors-are-set-to-reap-fortun...
1•bookofjoe•26s ago•1 comments

Angry America and its housing market

https://www.ft.com/content/9450175e-3da3-4df3-bd93-050683bbb98a
1•eli_gottlieb•37s ago•0 comments

Internet traffic and attacks during the 2026 U.S. midterm elections

https://blog.cloudflare.com/internet-traffic-2026-us-election/
1•dverlaeckt80•1m ago•0 comments

Postel Awardee Dave Täht Made Every Millisecond Count

https://www.internetsociety.org/blog/2026/11/postel-awardee-dave-taht-made-every-millisecond-count/
1•dverlaeckt80•2m ago•0 comments

Jonestforth – FORTH compiler and tutorial for Linux

https://github.com/nornagon/jonesforth/blob/master/jonesforth.S
1•gregsadetsky•2m ago•0 comments

Show HN: LZ0 -An asymmetric LZ compressor with ultra minimal, 0-alloc decoder

https://github.com/seb3773/lz0
1•seb3773•4m ago•0 comments

What Would the Ideal LLM Inference Chip Look Like? [video]

https://www.youtube.com/watch?v=1LGwx7jzOK4
1•bob1029•6m ago•0 comments

The Rocky Road from Aggregate to per Share Value: Anthropic's IPO Update

https://aswathdamodaran.blogspot.com/2026/11/the-rocky-road-from-aggregate-to-per.html
1•u1hcw9nx•6m ago•1 comments

Building iOS apps on Windows: what it takes

https://ssilvestri15.github.io/openfruit-site/engineering.html
1•thunderbong•7m ago•0 comments

Survivor Library – Archive Mirror (1.8 TB, 11,855 PDFs)

https://archive.org/details/SurvivorLibrary-com-Collection-2026
1•o_-_o•7m ago•0 comments

With AI Gateway, coding agents perform bulk tasks 8x faster and 20x cheaper

https://ploy.ai/blog/ploy-ai-gateway
2•Lorenzo45•8m ago•0 comments

Unhinged Pong

https://tennis.sixfingerpunch.com/
1•memalign•8m ago•0 comments

UChicago North Korean Stamp Collection

https://www.lib.uchicago.edu/turnstile/challenge/?next=/collex/collections/north-korean-stamp-col...
1•redhed•9m ago•0 comments

Designing UI to move out of the way

https://frigade.com/blog/assistant-that-gets-out-of-your-way
1•pancomplex•10m ago•0 comments

Sherlock Holmes' Abductive Reasoning

https://www.philmckinney.com/how-to-improve-your-abductive-reasoning-skills-the-sherlock-holmes-m...
1•fagnerbrack•10m ago•0 comments

Fixing DELL monitor firmware with Shelley

https://blog.exe.dev/fix-my-monitor
2•rdslw•11m ago•0 comments

Making BAML 34x faster by compiling to Rust

https://boundaryml.com/blog/compiling-baml-to-rust
3•aaronvg•12m ago•0 comments

Show HN: Plazzle – daily pathfinding puzzle game

https://plazzle.netlify.app
1•argentumsurfer•12m ago•1 comments

Git Blame, but for Conversations

https://www.staycaffeinated.com/2026/11/09/git-blame-for-conversations
1•frenchie4111•13m ago•0 comments

Found and Fixed: A Decade of AlaSQL

https://github.com/AlaSQL/alasql/releases/tag/v4.23.2
1•mathiasrw•15m ago•0 comments

Cyber War Leaks

https://cyberwar.nl/d/
1•o_-_o•15m ago•0 comments

What advice would you give to your younger self about building a distribution

1•grvchopra•15m ago•1 comments

Scientists Discover a Possible Marker in the Blood of CTE Patients

https://www.nytimes.com/2026/11/19/science/cte-blood-test-diagnosis.html
1•jbegley•15m ago•0 comments

Show HN: Jobs by Stock Ticker

https://searchforjobs.app/tickers
2•enjoyyourlife•15m ago•0 comments

Xi Jinping calls for complete ban and destruction of nuclear weapons

https://www.zaobao.com.sg/en/news/china/xi-jinping-calls-complete-ban-and-destruction-nuclear-wea...
2•neom•15m ago•1 comments

I built a tool that finds the fastest way to serve an LLM on your GPU

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

University students are biggest spreaders of Covid

https://www.nature.com/articles/d41586-026-03746-0
2•digital55•16m ago•0 comments

Show HN: Relic – An AI that only answers from what you've saved

https://relic-app.com
2•Cenga387•17m ago•0 comments

PHP sent cleartext data when using uppercase S in HTTPS:// protocol handler

https://twitter.com/mattiasgeniar/status/2123436542995964123
1•pricepinner•18m ago•1 comments

Lix

https://lix.systems/
2•Tomte•19m ago•1 comments