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.

Compile Time Improvements for derive(Debug)

https://yoyo-code.com/derive-debug-compile-time-improvements/
1•panstromek•57s ago•0 comments

Riemann Proof Atlas

https://nasqret.github.io/riemann-proof-atlas/
1•jarek83•1m ago•0 comments

SimCity – SNES OST [video]

https://www.youtube.com/watch?v=5Ns3pieZS_k
1•doener•6m ago•0 comments

Show HN: Jam – A music making game where you play gigs to earn studio gear

https://jam.resonantdsp.com
1•garrinm•7m ago•0 comments

Show HN: Direct weight edits turn a 0.5B model into an expert species classifier

https://andrewxhill.com/frontier-model-weight-edits/
1•andrewxhill•7m ago•0 comments

Hellschreiber Facsimile-Based Teleprinter

https://en.wikipedia.org/wiki/Hellschreiber
1•rickcarlino•9m ago•0 comments

Show HN: Gemini-Based Agent for Households

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

Getting Linux 7.2 onto a $40 handheld that hid its kernel as a Windows DLL

https://github.com/nzeuslab/nzeus-deck/blob/main/docs/WRITEUP.md
2•nzeuslab•14m ago•0 comments

Notion Mail Alternative

1•alexfthom•15m ago•0 comments

Large AI companies 'desperate for compute' are crowding out Canadian startups

https://www.cbc.ca/news/business/compute-canada-sovereignty-ai-9.7428523
1•ClearwayLaw•22m ago•1 comments

'People couldn't deal with watching an animal die'

https://www.theguardian.com/environment/2026/nov/21/strange-saga-timmy-the-whale-germany
2•jruohonen•28m ago•1 comments

Ludic's Guide to Getting Software Engineering Jobs

https://ludic.mataroa.blog/blog/ludics-guide-to-getting-software-engineering-jobs/
1•pjot•30m ago•0 comments

Slopstrap: Make your site look hastily vibecoded

https://slopstrap.mikelacher.com/l
1•coryalthoff•32m ago•0 comments

MarkdownWeb

https://demo.bonbonweb.org/
1•birdculture•33m ago•0 comments

Show HN: PLazzle – todays level is quite the challenge

https://plazzlegame.com/
1•argentumsurfer•34m ago•2 comments

The Roman Dictatorship: How Did It Work? Did It Work?

https://acoup.blog/2022/03/18/collections-the-roman-dictatorship-how-did-it-work-did-it-work/
2•JumpCrisscross•36m ago•0 comments

Google Sold Its Engineers on Management

https://hbr.org/2013/12/how-google-sold-its-engineers-on-management
2•fagnerbrack•37m ago•0 comments

EvalSift – 100 hand-labeled LLM agent traces

https://github.com/Eddie-Town/evalsift-lite
1•Eddie-Town•38m ago•0 comments

Lean Machine

https://github.com/dharmatech/lean-machine
2•__rito__•39m ago•0 comments

When a Warm Cache Changes the Answer in Reduced-Depth Inference

https://bennylabs.org/ai-in-its-infancy/
1•pennyowl•40m ago•0 comments

One Model, Two Accelerators: M6 Neural Engine and GPU for Prefill and Decode

https://huggingface.co/blog/anemll/hybrid-ane-gpu-m6
1•wertyk•41m ago•0 comments

Signal Can Encrypt Your Messages. It Can't Always Stop AI from Reading Them

https://inclinq.medium.com/signal-can-encrypt-your-messages-it-cant-always-stop-ai-from-reading-t...
1•inclinq•41m ago•0 comments

The Most Important Charts in AI Are Wrong

https://www.rameznaam.com/p/the-most-important-charts-in-ai-are
1•yogthos•44m ago•0 comments

Verification files for the Lean proof of the Riemann Hypothesis

https://math.mit.edu/~drew/grh/
1•Bluestein•44m ago•0 comments

Grafeo: A high-performance Rust graph database

https://github.com/GrafeoDB/grafeo
1•jerlendds•45m ago•0 comments

Yahoo Mail's MX Change: Which Domains Moved, and What a 450 Asks of You

https://dmarcguard.io/blog/yahoo-mail-mx-change/
2•meysamazad•47m ago•0 comments

Google Disrupts Its Search Advertising with Its Embrace of A.I

https://www.nytimes.com/2026/11/19/technology/google-search-ads-ai.html
2•ryan_j_naughton•51m ago•0 comments

Do Wavy Walls Use Fewer Bricks?

https://blog.tymscar.com/posts/crinklecranklewalls/
1•nopurpose•51m ago•0 comments

PII redaction before LLM processing

https://danb.id.au/blog/pii-redaction-before-llm.html
1•dbetteridge•53m ago•0 comments

CEO of homeless charity tried to flee on his luxury yacht before his arrest

https://lbpost.com/news/ceo-flee-yacht-homeless-housing-charity-fraud-helpful-housing/
4•nephihaha•56m ago•1 comments