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.

Best Productivity Newsletters

https://github.com/dariubs/awesome-productivity-newsletters
1•dariushabbasi•52s ago•0 comments

Nvidia approaches Arm boss Rene Haas in search for new CEO

https://www.theguardian.com/technology/2026/nov/19/nvidia-new-ceo-search-jensen-huang-arm-rene-haas
1•fork-bomber•1m ago•0 comments

Today's Anthropic IPO compared with the dot-com IPOs

https://www.kadoa.com/companies/insights/tech-ipo-revenue-multiples
2•hubraumhugo•3m ago•0 comments

Single technology is killing oil demand

https://climatemoney.substack.com/p/this-single-technology-is-killing
3•gniv•4m ago•0 comments

Introducing: Double Jump

https://www.quarter--mile.com/Double-Jump
1•surprisetalk•6m ago•0 comments

Did Polymarket's most skilled traders call the 2026 midterms?

https://predictpnl.com/articles/midterms-2026-did-top-traders-get-it-right
1•lorande•9m ago•0 comments

Before she created CBT Marsha Linehan spent 2 years in a psychiatric ward

https://indianexpress.com/article/books-and-literature/marsha-linehan-dies-dbt-memoir-building-a-...
1•PaulHoule•9m ago•0 comments

Unit-testing in the Ü programming language

https://panzerschrek.github.io/U-00DC-Sprache-site/2026/11/18/unit-testing.html
1•Panzerschrek•11m ago•0 comments

Slop and Verification Debt

https://diatone.net/verification
3•diatone•13m ago•0 comments

RN1 Doesn't Need to Know Who Wins

https://blockjuice.asof.sh/articles/rn1-strategy-teardown/
1•iankguimaraes•15m ago•0 comments

The SDLC Is Out of Balance: Beyond the AI Code Review Bottleneck

https://vitaliioborskyi.ai/articles/the-sdlc-is-out-of-balance.html
1•oddish-tv•17m ago•0 comments

Autonomous AI Security Auditing of Webmin: 507 Newly Discovered Vulnerabilities

https://supuk.ch/papers/webmin-ai-security-audit-507-vulnerabilities
1•bordercontrol•18m ago•1 comments

Anthropic Is the Reluctant Winner of the AI Race

https://www.theatlantic.com/technology/2026/11/anthropic-winner-ai-race/689479/
2•FinnLobsien•21m ago•0 comments

The cultural evolution of female body representations in European portraiture

https://royalsocietypublishing.org/rspb/article/293/2083/20262007/484209/The-cultural-evolution-o...
2•rbanffy•21m ago•0 comments

Unblockable communication with gravity – Science Advances

https://www.science.org/doi/10.1126/sciadv.aee0802
5•rbanffy•24m ago•0 comments

Show HN: VPNDetection, a VPN and proxy detection API with no key

https://vpndetection.io
2•mslm•25m ago•0 comments

Draft Emoji List for 2027/2028 Unveiled

https://blog.emojipedia.org/draft-emoji-list-for-2027-2028-unveiled/
1•surprisetalk•26m ago•0 comments

Powered by Netlify badge on new Free plan projects

https://docs.netlify.com/manage/projects/powered-by-netlify-badge/
1•ivanjermakov•29m ago•0 comments

The AI Superintelligence Debate Has Serious Flaws

https://spectrum.ieee.org/ai-superintelligence-debate
8•rbanffy•29m ago•0 comments

Worlds largest beaver dam in Northern Alberta

https://substack.com/@canadianreturnee/note/c-319574497
1•bookofjoe•31m ago•0 comments

An Outer Sandbox for Coding Agents

https://mo.town/blog/posts/lilbox.html
2•zeroxfe•32m ago•0 comments

The AI tipping point happened

https://research.kumpf.cc/2026-AITippingPoint/
1•adamkumpf•36m ago•0 comments

South Korea Offers $75,000 Bounties to Catch AI Exam Cheats

https://www.bloomberg.com/news/articles/2026-11-18/south-korea-proposes-75-000-bounties-to-catch-...
2•helsinkiandrew•37m ago•2 comments

A Megakernel per Model

https://dangxingyu.github.io/megakernel/
1•nnx•38m ago•0 comments

Ask HN: Have you tested dots from OpenAI yet?

1•nvmdbljstm•38m ago•2 comments

TermCove Mac SSH client that lets Claude Code use your servers without your keys

https://termcove.com/
1•hamzehtabbaa•41m ago•0 comments

GTA 6 Cheats, Mods and Companion Tool

https://grandtheftautocheats.com/
2•gtaguy•41m ago•0 comments

Datacentres to create 70% more carbon emissions by 2030, IEA report warns

https://www.theguardian.com/world/2026/nov/19/datacentres-to-create-70-more-carbon-emissions-by-2...
5•robtherobber•43m ago•0 comments

Mike Lynch's superyacht had unidentified vulnerability to high winds

https://www.theguardian.com/world/2026/nov/19/mike-lynch-superyacht-bayesian-vulnerability-to-hig...
2•n1b0m•45m ago•2 comments

Free and open source ultra light live wallpaper software

1•sozip•46m ago•0 comments