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.

Show HN: Starquix – Open-source local visual Astro website builder

https://github.com/Mayhopar/Starquix
1•mayhopar•2m ago•0 comments

Waymo pulls driverless taxis from all US freeways

https://www.bbc.com/news/articles/cmy86pp336qlo
2•onemoresoop•3m ago•0 comments

Palo Alto Networks to Buy Applied Compute for $4.5B

https://www.wsj.com/tech/ai/palo-alto-networks-to-buy-ai-startup-applied-compute-for-4-5-billion-...
1•seagull•5m ago•0 comments

Mark Zuckerberg Video Deposition – New Mexico vs. Facebook Trial – 9/10/2026

https://www.youtube.com/watch?v=C7UC2ie0XIE
1•Bluestein•5m ago•0 comments

Islam Will Soon Be the World's Largest Religion

https://www.pewresearch.org/short-reads/2026/11/18/islam-will-soon-be-the-worlds-largest-religion...
1•bushwart•7m ago•1 comments

Bull Shows Intel Xeon Diamond Rapids Package at SC26 – ServeTheHome

https://www.servethehome.com/bull-shows-intel-xeon-diamond-rapids-package-at-sc26/
1•rbanffy•8m ago•0 comments

Auditory stimulation during sleep enhances cerebrospinal fluid flow in humans

https://www.science.org/doi/10.1126/scitranslmed.aea5469
2•toomuchtodo•9m ago•1 comments

Updated Clairic and Clairic-flash are now open-weight

https://blog.cloudflare.com/open-clairic/
2•sixhobbits•10m ago•0 comments

Language Models Are Erasing Our Weirdness

https://academy.socos.org/language-models-are-erasing-our-weirdness/
2•greyface-•11m ago•0 comments

Waymo has stopped its robotaxis from driving on the freeway

https://arstechnica.com/cars/2026/11/waymo-suspends-freeway-driving-after-california-construction...
3•celsoazevedo•11m ago•1 comments

Meet Your Neighbors – A new type of political compass

https://meetyourneighbors.ai/
1•eltokh7•11m ago•0 comments

Blocking MeshCore Spam

https://mcfl.neocities.org/blog/01-block-spam/
2•celsoazevedo•12m ago•0 comments

MeshCore One

https://github.com/Avi0n/MeshCoreOne
2•celsoazevedo•13m ago•0 comments

Ask HN: Are we all tired of all these skybreaking CVEs/RCEs?

3•szopin•14m ago•0 comments

I'm a GM Master Technician Building a Team of AI Agents That Talk to Each Other

https://oddityforge.net
4•hckyplr•15m ago•0 comments

Canvas Dx, an AI app that diagnoses autism [video]

https://vimeo.com/791026418
1•illidan1000•16m ago•1 comments

Americans misled on Social Security for decades as clock counts down on benefits

https://www.foxnews.com/politics/americans-misled-social-security-decades-clock-counts-benefits-e...
1•dataflow•16m ago•1 comments

In France and Germany, the state backs one startup round in three

https://justraised.io/blog/state-backs-one-startup-round-in-three
1•jrbayguade•19m ago•0 comments

Jj-musubi: live sync for Jujutsu

https://www.serpentine.com/posts/2026/announcing-jj-musubi/
1•bos•20m ago•0 comments

The Quad9 Alternatives

https://eualternative.eu/guides/quad9-alternatives/
1•sparkling•20m ago•0 comments

Show HN: Toggles, a game based on analyzing data

https://toggles.codewalkers.net
1•mattw2121•21m ago•0 comments

Growing as an Engineer in a World of AI

https://nlopes.dev/writing/growing-as-an-engineer-in-a-world-of-ai
1•fagnerbrack•23m ago•0 comments

Apple Was Late to the Video Podcast Boom. Now It's Trying to Catch Up

https://www.nytimes.com/2026/11/16/business/media/apple-tv-podcasts-youtube.html
3•bookofjoe•24m ago•1 comments

To rank the biggest supercomputers, we're gonna need a bigger bench

https://www.theregister.com/hpc/2026/11/18/to-rank-the-worlds-biggest-supercomputers-were-gonna-n...
1•rbanffy•25m ago•0 comments

Q.Ant NPU Gen2 Photonic Processor

https://thequantuminsider.com/2026/11/17/q-ant-demonstrates-hybrid-photonic-gpu-system-for-langua...
1•treebeard901•26m ago•1 comments

Show HN: Phrack-TUI – A terminal reader for the Phrack archive

https://github.com/krmbzds/phrack-tui/tree/master
1•krmbzds•27m ago•0 comments

Scientists Thought This Amphibious Mouse Was Extinct. It's Reappeared

https://www.nationalgeographic.com/animals/article/ethiopia-water-mouse-extinct-rediscovery
1•spankibalt•28m ago•0 comments

GTA VI is a cynical and sometimes shallow joyride through the American psyche

https://www.cbc.ca/news/entertainment/grand-theft-auto-vi-review-9.7425005
2•uladzislau•30m ago•1 comments

CodeRabbit Verify: Agentic application testing and QA

https://www.coderabbit.ai/blog/introducing-coderabbit-verify
1•smb06•35m ago•1 comments

Amazon vows to fight the company's first NA union contract at a CAN warehouse

https://apnews.com/article/amazon-unifor-union-workers-1e0626c31c857ad54aa9b20d8c83b54d
4•Teever•35m ago•0 comments