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.

Ask HN: What made you pivot your interest to the field of AI?

2•learner_yearner•5m ago•0 comments

The Explorer Pattern for product invention and development

https://lethain.com/explorer-pattern/
1•gpi•5m ago•0 comments

Replaced PTX with MLIR, cutting asm regions from 499 to 81 across 20 kernels

https://vxlang.org/blog/handing-the-ptx-back-to-the-compiler.html
3•reshabh•6m ago•0 comments

San Francisco Braces for Record Tides as Mayor Urges Residents to Stay Put

https://kfn.one/news/san-francisco-braces-for-record-tides-as-mayor-urges-1d795047
1•reena•6m ago•0 comments

Back Pain (2021)

https://www.thomas-huehn.com/back-pain/
1•Curiositry•7m ago•0 comments

AI Supply Chain Security: What Canary Tokens Found

https://www.dragos.com/blog/ai-supply-chain-security-canary-tokens
2•kristianp•13m ago•0 comments

Replaying an agent run and what it takes

https://github.com/chizy7/tether/blob/master/docs/REPLAY.md
1•chizy7•14m ago•0 comments

Trump threatens penalties for US tech firms that build datacenters abroad

https://www.theguardian.com/us-news/2026/nov/20/trump-datacenters-white-house
1•Pxtl•15m ago•0 comments

AiDotNet – Comprehensive AI/ML Framework for .NET

https://github.com/ooples/AiDotNet
2•olvy0•18m ago•0 comments

Strangler pattern, a powerful simple concept to do refactoring (2019)

https://martinfowler.com/bliki/StranglerFigApplication.html
1•zenincognito•24m ago•0 comments

ING's $500M Data Center Loan Auction Stalls on Weak Demand

https://www.bloomberg.com/news/articles/2026-11-20/ing-s-500-million-data-center-loan-auction-sta...
1•cobychapple•25m ago•0 comments

Job ghosting: What applicants can do if employers do not respond

https://www.bbc.com/news/articles/cm2d94le23xyo
3•rustoo•25m ago•0 comments

Userscript managers in 2026: what Manifest V3 changed

https://www.softwr.com/news/best-userscript-managers
1•peter_d_sherman•27m ago•1 comments

"Dumbass" RFK Jr. Rescued Measles from Obscurity. What Horror Is Next?

https://newrepublic.com/post/218245/rfk-jr-measles-trump-outbreak
9•petethomas•34m ago•2 comments

What It Looks Like to Parent Without Gender

https://www.thenation.com/article/society/what-it-looks-like-to-parent-without-gender/
2•petethomas•36m ago•0 comments

One Vulnearbility Hacks Google, WordPress, Roundcube, Debian 13, Zoom, Box, etc.

https://pwn.ai/upload2shell/research.html
3•lovetoseeitgeth•49m ago•1 comments

A Collision for 38-Step SHA-256

https://eprint.iacr.org/2026/2913
1•gslin•55m ago•0 comments

NixOS bring-up on an Alibaba RISC-V board

https://feyor.sh/blog/nixos-bringup-on-an-alibaba-riscv-board/
2•todsacerdoti•55m ago•0 comments

Trump at the "Summit": One of His Dumbest Moments in the Last 10 Years

https://newrepublic.com/post/218235/trump-summit-xi-putin-nuclear
5•petethomas•59m ago•0 comments

Show HN: Vouch – See what AI assistants say about your brand mid-conversation

https://vouchgeo.com
1•samratkar•1h ago•0 comments

Thought Experiment: How Could One Save Nauru?

1•Kurio•1h ago•1 comments

Fast-Anything: Don't rewrite it in Rust. Rewrite the 5% that's slow

https://github.com/EL4CTEO/fast-anything
2•BaselAshraf81•1h ago•0 comments

Waymo plows through crossing gate after getting stuck on train tracks [video]

https://www.youtube.com/shorts/UiNIHWfbPRQ
1•mikhael•1h ago•0 comments

Toyota, Nissan, and Honda to Standardize Parts to Lower Costs

https://www.caranddriver.com/news/a74490092/toyota-nissan-honda-standardize-parts-lower-costs/
124•zdw•1h ago•63 comments

Five Kinds of Organizational Debt

https://www.constellaryhq.com/articles/five-kinds-of-organizational-debt
1•fagnerbrack•1h ago•0 comments

Japan-Inspired Tetris Game

https://daycarp.com/misc/linestokyoto/
2•coffeethursday•1h ago•0 comments

Mirage

https://akella.github.io/codevember-2026/15/
1•memalign•1h ago•0 comments

What Would Count as Superintelligence?

https://thefriendlyghost.nl/what-would-count-as-superintelligence
1•cvanelteren•1h ago•0 comments

How market fit is different for healthcare

https://davidngo1562.substack.com/p/its-not-about-the-money-until-it
2•illidan1000•1h ago•0 comments

On the probability of robots becoming more creative than humans

https://www.thetedkarchive.com/library/ted-kaczynski-on-the-probability-of-robots-becoming-more-c...
2•maplet•1h ago•2 comments