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.

'Companies don't care about you' is a parse error

https://blog.oliverbalfour.com/2026/11/20/companies-dont-care-about-you.html
1•OliverBalfour•2m ago•0 comments

Top White House Cybersecurity Official Steps Down

https://www.nytimes.com/2026/11/19/us/politics/white-house-cyber-director-departs.html
1•shevis•6m ago•1 comments

Serial: The Port That Won't Die

https://hackaday.com/2026/11/18/serial-the-port-that-wont-die/
1•lucaslazarus•7m ago•0 comments

WebTape – Record browser demos to GIF/MP4 from a plain-text script

https://github.com/zhushen12580/webtape
1•zane12580•10m ago•0 comments

Show HN: Tyche, An intelligent interface that clicks, books, and shops on iPhone

https://apps.apple.com/us/app/tyche-intelligent-interface/id6835683787
1•iop030290•12m ago•0 comments

Hyperscale. Play as a Frontier AI Lab and try cash out before society collapses

https://hyperscale.serinstudios.com/
1•ownbaggy•13m ago•0 comments

OpenSSL heap buffer overflow in EVP_EncodeBlock() output sizing

https://cve.now/CVE-2026-121481
2•choult•18m ago•0 comments

Grand Theft Auto Used to Satirize American Life. Now We've Caught Up with It

https://www.nytimes.com/2026/11/19/magazine/grand-theft-auto-six.html
1•elffjs•20m ago•0 comments

Fiction Machines – Léon Bottou [video]

https://www.youtube.com/watch?v=B64cnPA36Dc
1•matt_d•21m ago•0 comments

'Anthropic was supposed to save the AI trade. What went wrong?' – CNBC

https://www.cnbc.com/2026/11/19/anthropic-ipo-ai-stocks-selloff.html
1•MilnerRoute•23m ago•0 comments

Ex MS researcher publishes claimed Windows lock-screen bypass through Narrator

https://runtimewire.com/article/former-microsoft-researcher-publishes-claimed-windows-lock-screen...
2•thunderbong•25m ago•0 comments

Looking like nothing: surviving deep packet inspection with VLESS and REALITY

https://undef.dev/writing/learn/vless-reality/
1•zenincognito•27m ago•0 comments

Vint Cerf on why TCP/IP was never patented

https://seremot.com/p/vint-cerf-on-why-tcpip-was-never
1•emot•28m ago•2 comments

Ihash : the fastest high-quality non-cryptographic hash

https://crates.io/crates/ihash
1•i18n•29m ago•0 comments

The fastest double-to-string algorithm you've never heard of

https://vitaut.net/posts/2026/yy-dtoa/
1•fagnerbrack•33m ago•0 comments

Writing Python like it's Rust (2023)

https://kobzol.github.io/rust/python/2023/05/20/writing-python-like-its-rust.html
1•kaycebasques•33m ago•0 comments

FreeBSD Is What Unix Was Supposed to Be

https://milkcrunch.com/freebsd-unix-philosophy/
2•zenincognito•41m ago•2 comments

Show HN: Zeus – Claude Code for AI voice agents

https://thunderphone.com/blog/introducing-zeus
1•kolchinski•42m ago•0 comments

Palo Alto Networks CEO on the network outages through major companies

https://finance.yahoo.com/technology/article/palo-alto-networks-ceo-just-dropped-a-truth-bomb-on-...
2•thunderbong•44m ago•0 comments

Top BOF Repositories for Red Teamers

https://medium.com/@nukeratframework/top-3-bof-repositories-for-red-teamers-ba67b3c5e2d7
2•JohnTheTitor•45m ago•0 comments

UK government forced to disclose secret Apple backdoor order

https://techcrunch.com/2026/11/19/u-k-government-forced-to-disclose-secret-apple-backdoor-order/
3•Coeur•52m ago•1 comments

Perfecting Terminal Character Width Using Correction Tables

https://www.jeffquast.com/post/perfecting-terminal-character-width-using-correction-tables/
2•birdculture•56m ago•0 comments

Postgres 19 is out, and it's available on Neon and Databricks Lakebase

https://www.databricks.com/blog/postgresql-19-available-lakebase
2•sp_from_db•57m ago•3 comments

Perceptle

https://perceptle.com/
3•soheilpro•1h ago•0 comments

The Game – Help people with math

https://game.poshenloh.com/
2•qainsights•1h ago•0 comments

ChatGPT for SNES

https://www.bxfoundry.com/chatgpt_snes/
3•evan_•1h ago•0 comments

New tools are helping chemists reveal a hidden world of contamination

https://www.science.org/content/article/chemists-are-uncovering-hidden-world-pollution
3•EA-3167•1h ago•0 comments

The Part About Machines (On AI Literary Scandals)

https://thepointmag.com/examined-life/the-part-about-the-machines/
3•anarbadalov•1h ago•0 comments

Using a Natural Language for Programming

https://thingspool.net/shards-of-sanity/page-6.html
3•architsch•1h ago•1 comments

US National Cyber Director to step down

https://www.axios.com/2026/11/19/trump-national-cyber-director-sean-cairncross-leaving
4•qphe95•1h ago•1 comments