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: TheGeoPot – AI scanner for minerals, coins, plants and crops

https://thegeopot.com/
1•sagyn•12s ago•0 comments

Anthropic employee claims general proof of the Riemann Hypothesis [pdf]

https://alpo.ge/remark.pdf
1•iamronaldo•2m ago•0 comments

Trackpad gestures could return to normal by Christmas

https://eclecticlight.co/2026/11/20/trackpad-gestures-could-return-to-normal-by-christmas/
1•Brajeshwar•2m ago•0 comments

Feature Parity

https://www.martinfowler.com/articles/patterns-legacy-displacement/feature-parity.html
1•FinnKuhn•2m ago•0 comments

Cursor tells lawmakers it's considering phasing out Chinese AI models

https://www.cnbc.com/2026/11/20/cursor-chinese-ai-models-geopolitical-risk.html
1•Betelbuddy•2m ago•0 comments

Cursor considering phasing out Chinese AI models

https://www.cnbc.com/2026/11/20/cursor-
1•arend321•3m ago•0 comments

US Commerce approved sales of more than 879,000 AI chips to Chinese companies

https://www.cnbc.com/2026/11/19/nvidia-amd-china-chip-sales-congress.html
1•skadamat•4m ago•0 comments

Small TTS Bench: open-weight text-to-speech models on CPU

https://erogol.com/small_tts_bench/
1•jrm-veris•4m ago•0 comments

Combining Tests and Proofs with Contracts for Better Software Verification

https://www.research-collection.ethz.ch/server/api/core/bitstreams/361d027f-14c1-42d0-85a1-bbe809...
1•mpweiher•4m ago•0 comments

California Attorney General subpoenas Nvidia over chips

https://www.bostonherald.com/2026/11/20/california-attorney-general-nvidia-subpoena/
2•Betelbuddy•4m ago•0 comments

Five Layers. An architecture for systems built with agents

https://kairollmann.de/2026/11/20/five-layers-an-architecture-for-systems-built-with-agents/
1•kadrian12•5m ago•0 comments

Flawless UI-UX Skill 3.0.0

https://github.com/smokeeaasd/flawless-ui-ux
1•99lcccss•8m ago•0 comments

SureQ – a Node.js job queue that runs on your existing database

https://github.com/sureq-js/sureq
1•avalluru•8m ago•0 comments

Show HN: Heterogeneous Distributed Computing

https://murmurcomputing.ai/
1•IRPhysicist•8m ago•0 comments

AI Gateway: Manage your company's AI from one place

https://layerx.xyz/ai-gateway
2•carlosmendes•9m ago•0 comments

Show HN: Declutta – Free, on-device iOS photo cleaner and video compressor

https://apps.apple.com/us/app/free-up-space-declutta/id6799243408
1•codivolabs•9m ago•0 comments

Show HN: Arc Chain Analyzer

https://dmarcguard.io/tools/arc-chain-analyzer/
1•meysamazad•9m ago•0 comments

Pihole in Ha Mode

https://www.codedge.de/posts/pihole-in-ha-mode
1•meysamazad•9m ago•0 comments

First Step Epoch: a real-world stardate

https://starbase430.com/log/first-step-epoch/
1•meysamazad•9m ago•0 comments

In historic first, UN top court rules a country [Myanmar] committed genocide

https://www.cnn.com/2026/11/19/asia/icj-myanmar-genocide-rohingya-ruling-intl-hnk
1•bhouston•10m ago•0 comments

HimitsuShell: Run shell scripts invisible even to kernel tracing

https://github.com/HimitsuShell/HimitsuShell
1•mushstory•10m ago•0 comments

Myanmar committed genocide against Rohingya minority, top court rules

https://www.theguardian.com/world/2026/nov/19/genocide-rohingya-international-court-of-justice-ru...
3•bhouston•10m ago•0 comments

Show HN: StripeWorld – a synthetic Stripe API for RL and testing

https://github.com/Kiln-AI/stripe_world
1•scosman•12m ago•0 comments

Nasdaq futures drop as Anthropic shares tumble

https://www.cnbc.com/2026/11/19/stock-market-today-live-updates.html
4•Betelbuddy•12m ago•0 comments

RWKV-P, a neural network, beat both Anki algorithms for 9,999 of 9,999 users

https://learnfromx.com/research/rwkv-anki-fsrs
2•charlie42•14m ago•0 comments

GNOME developer criticized Discord's use of layer-shell as API abuse

https://gitlab.gnome.org/GNOME/gnome-shell/-/work_items/1141#note_2938236
2•oabragh•15m ago•0 comments

Docker Rebrand

https://www.docker.com/blog/meet-the-new-docker-built-to-run-on-trust/
3•pentagrama•16m ago•0 comments

Rarescraper – a daily game where each answer must be rarer than the last

https://rarescraper.com
2•hobsolo•16m ago•0 comments

Sex, Lies, and Export Controls

https://www.publicnotice.co/p/trump-huang-export-controls-nvidia
2•cdrnsf•17m ago•0 comments

Llms.txt and MCP didn't move the needle

https://backpackforlaravel.com/articles/opinions/llms-txt-and-mcp-didn-t-move-the-needle-for-us-h...
2•moebrowne•18m ago•0 comments