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.

The Temperamental Nature of Alligator Gender-Reveal Parties

https://nautil.us/the-temperamental-nature-of-alligator-gender-reveal-parties-1286547
1•rbanffy•21s ago•0 comments

SwiftNIO: Why ByteBuffer Has Two Cursors

https://ivantokar.com/posts/swiftnio-why-bytebuffer-has-two-cursors/
1•frizlab•2m ago•0 comments

Show HN: Armin – Modern Anki alternative with prerrequisite graphs

https://armincards.app/
1•ansanabria•2m ago•0 comments

Amazon's Ring debuts security robots, including a drone

https://www.nbcnews.com/tech/tech-news/amazons-ring-debuts-security-robots-drone-rcna608538
1•gmays•3m ago•0 comments

Nera – Erlang that ships like Go

https://www.process-one.net/blog/nera-erlang-that-ships-like-go/
1•mremond•4m ago•0 comments

Who Is Colette Kress? Meet Nvidia's New Interim CEO

https://www.wsj.com/tech/colette-kress-nvidia-interim-ceo-ff26ef3a
1•pretext•4m ago•0 comments

Show HN: Lumin – Logs, metrics and uptime checks for one-person SaaS

https://getlumin.dev/
1•frederikmartin•5m ago•0 comments

Remote Full Stack Developer Jobs

https://nokku.payanai.com/jobs/remote-full-stack-developer-jobs
1•payanai•5m ago•1 comments

Biomimetic engineering of a fortified ice composite with enhanced properties

https://www.sciencedirect.com/science/article/pii/S0927776526006259?via%3Dihub#sec0005
1•wslh•6m ago•0 comments

Show HN: AppPage – Embeddable community, roadmaps, and support hubs for apps

https://apppage.dev
2•edmundgentle•8m ago•0 comments

HubSpot Announces Leadership Transition: Brian Halligan Returns as CEO

https://ir.hubspot.com/news-releases/news-release-details/hubspot-announces-leadership-transition...
1•jbredeche•9m ago•0 comments

Jensen Huang's China Spy Controversy

https://oplexa.com/blogs/jensen-huang-china-spy-nvidia-investigation-2026/
1•oplexa•9m ago•0 comments

Students at Architecture schools are using AI for everything – what's the fix?

https://www.reddit.com/r/Architects/comments/1xp9yfs/students_at_architecture_schools_are_using_a...
2•jbl0ndie•9m ago•0 comments

Schema.org: a collaborative activity to create structured data on the Internet

https://schema.org/
1•thunderbong•10m ago•0 comments

The Gratitude of Albert Camus

https://www.themarginalian.org/2014/11/19/albert-camus-letter-teacher/
1•rookienumbers30•12m ago•0 comments

Strategy to Be Dropped from MSCI Indexes After New Eligibility Rules

https://www.wsj.com/finance/investing/strategy-the-worlds-biggest-corporate-bitcoin-holder-to-be-...
1•tosh•12m ago•0 comments

Prostate Cancer Screening Now Broadly Recommended, Reversing Past Guidance

https://www.nytimes.com/2026/11/12/well/prostate-cancer-screening-guideline.html
1•julienchastang•12m ago•0 comments

Did Jensen F*** Again?

https://didjensenfuckagain.tech/
1•fside•13m ago•0 comments

Grid: An open database of income inequality and dynamics across 26 countries

https://www.grid-database.org/
1•latentframe•16m ago•0 comments

Open benchmark of AI decision APIs vs. XGBoost for fraud triage

https://github.com/SmartMobileHouse/fraud-decision-lab
1•jpietrus1•16m ago•0 comments

Talk for Stanford's EE 292J (Designing for Authenticity)

https://blog.dshr.org/2026/05/talk-jonathan-dotans-class.html
1•wslh•18m ago•0 comments

Show HN: Flight Itinerary – plan multi-stop flight trips on a map

https://flightitinerary.app/
3•WebSpyder•18m ago•0 comments

What happens if you write a TCP stack in Python? (2014)

https://jvns.ca/blog/2014/08/12/what-happens-if-you-write-a-tcp-stack-in-python/
1•zenincognito•18m ago•0 comments

My running data, on my own Mac

https://bytefabrika.io/blog/my-running-data/
5•fka•19m ago•0 comments

A book of condolences for Jensen Huang's resignation

https://horny.ceo/farewell
2•notelon•19m ago•0 comments

Relate by Neo4j – embedded, agent-native graph database

https://github.com/relatedb/relate
3•jexp•21m ago•1 comments

Learning shaders when AI can write them for you

https://shader-learn.vercel.app/en
1•huozhi•21m ago•0 comments

Show HN: Cinnamon AI – an agent for your family

https://getcinnamon.ai/
1•mv4•22m ago•1 comments

Google Glasses: Intelligent Eyewear

https://glasses.google/
1•pretext•23m ago•0 comments

Nvidia Pair Can't Cluster

https://www.lttlabs.com/articles/2026/11/12/nvidia-pair
1•nwnht•23m ago•0 comments