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.

International UN talks on controlling use of autonomous weapons collapse

https://www.theguardian.com/technology/2026/nov/21/international-talks-control-ai-autonomous-weap...
1•nephihaha•1m ago•0 comments

Hearthen, an app for building and keeping strong relationships

https://hearthenapp.com
1•mamorales•4m ago•1 comments

Older people with religious or spiritual beliefs enjoy better quality of life

https://www.cnn.com/2026/11/20/health/religious-spiritual-older-adults-intl-scli-wellness
2•teleforce•5m ago•0 comments

MHUB – install and update 28 open source Mac utilities from the menu bar

https://github.com/starbudweiser/mHUB
1•Starbudweiser•6m ago•0 comments

Grok Bot Symbiosis

https://timeline.place/guides/grok-bot-symbiosis
1•marcelmarais•8m ago•0 comments

Studio Wetware

https://studiowetware.com/
1•Beachkilla•11m ago•0 comments

Say which AI wrote it: AI transparency for Open Source projects

https://www.saywhichai.org
1•cedricbonhomme•12m ago•0 comments

Code was my second mother tongue. Now everyone speaks it. What could go wrong?

https://blog.ngxson.com/going-deaf-in-my-own-language
1•ngxson•14m ago•0 comments

Plv8: V8 Engine JavaScript Procedural Language Add-On for PostgreSQL

https://github.com/plv8/plv8
1•thunderbong•18m ago•1 comments

Show HN: Git blame for AI code, down to the agent session

https://keepplain.com/blame
1•keepplain•20m ago•0 comments

Cappz – AI agents sell work to each other, paid per stage on XRPL

https://github.com/CAPPZ-ai/cappz-sdk
1•fastflair•22m ago•0 comments

Trump vows to work with Democrats to cap credit card interest rates at 10%

https://apnews.com/article/trump-credit-cards-interest-rates-warren-banks-098a69b520e520e535eebe5...
1•petethomas•27m ago•1 comments

Macaron – Turn customer messages into fixes ready for review

https://macaron.sh
1•garagemanda•28m ago•0 comments

Americas Mexico detains top cartel boss 'El Chapo Isidro,' setting off violence

https://www.npr.org/2026/11/21/nx-s1-6049672/cartel-boss-el-chapo-isidro-detained
1•blinding-streak•29m ago•0 comments

Bayer reaches Roundup settlement that could cost the company billions

https://www.npr.org/2026/11/21/nx-s1-6049684/roundup-bayer-hodgkins-settlement
1•blinding-streak•31m ago•0 comments

Measuring nanometers by looking at your reflection [video]

https://www.youtube.com/watch?v=k4AEZ35VklM
1•ivanjermakov•31m ago•0 comments

Field Guide: Running Qwen3.8 Locally

https://igorstechnoclub.com/field-guide-running-qwen38-locally/
1•Igor_Wiwi•32m ago•0 comments

Kvdiff – Local proxy showing the byte breaking your LLM prompt cache

https://github.com/flipcyde101/kvdiff
1•flipcyde101•33m ago•0 comments

Show HN: AGI: Robots Awake – a browser maze shooter

https://marcvscouto.itch.io/agi-robots-awake
2•mvbrasil•39m ago•1 comments

Zlin City: Diorama – Closed Playtest Announcement [video]

https://www.youtube.com/watch?v=5T6dq8adEvo
1•phil-pickering•40m ago•1 comments

Internet Archive employees seek to form a union

https://www.heise.de/en/news/Internet-Archive-employees-seek-to-form-a-union-11533621.html
2•Tomte•43m ago•0 comments

Making models predictable makes their errors more random

https://www.youtube.com/watch?v=-MiM5xfAe2c
1•gitowiec•43m ago•0 comments

Anthropic Opened Its Books. What Is It Worth? [video]

https://www.youtube.com/watch?v=Ic1Jf7VlXRM
1•Bluestein•43m ago•1 comments

Fleet – manage multiple harnesses with a central agent in a TUI

https://github.com/sturlabragason/fleet
2•sturla-bragason•46m ago•1 comments

SVG loading (rendering, conversion) in Castle Game Engine thanks to FPC 3.3.1

https://castle-engine.io/wp/2026/11/21/svg-support/
1•mariuz•48m ago•0 comments

Show HN: Lightweight Digital Piggybank

https://app.supademo.com/video/cmwqynzsi0efcqm24gcrc2tl7
1•hito20•51m ago•0 comments

Alice Huang's links to the chip underworld

https://www.ft.com/content/f3ad8a81-3890-4a8a-8853-ff0a94b08ba9
1•Betelbuddy•55m ago•0 comments

A Better Vocabulary for Testing

https://alperenkeles.com/posts/vocab-for-testing/
1•alpaylan•56m ago•0 comments

Noirvpn – a 10x faster openvpn in Odin

https://github.com/cosiniumdev/noirvpn
2•ldkjhg•57m ago•1 comments

Cursor may stop using Chinese open-weights AI models

https://casrai.org/news/house-committees-cursor-chinese-open-weight-ai-models-report-2026
3•ComputedCamp995•57m ago•1 comments