frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Is your Postgres migration safe or not safe?

https://safenotsafe.dev/
22•vira28•2h ago

Comments

kettlecrisp99•59m ago
Thing that bit me most wasn't the DDL itself, it was lock queuing. An ADD COLUMN is instant but if it waits behind a long read, every query behind it piles up too. Lock_timeout plus retry saved us more than any clever migration tool.
vira28•7m ago
Agree. `lock_timeout` will go a long way in terms of damage control.
jokull•44m ago
Very cool! I wrote a go library for this https://onwardpg.solberg.is
vira28•5m ago
Nice. Integrating it on CI and catching there is still the best way/place. Having said, it doesn't work like that in practice.
vira28•27m ago
Author here: Adding some context. I led the Postgres platform team (2019-23) at Cloudflare and we were supporting 170+ growing product teams. One of the constant asks is schema migration review. We published a lot of best practices, added CI checks however, it was still hard to catch. Also, I tried to explain the internals of how the locking (rewrite) works, but I realized most of the devs just want the answer - Is it safe or not safe to run?

Not sure if it rings a bell, the name is a reference to the Silicon Valley Jian Yang's hot dog or not hot dog app.

Also, I understand the decision of safe vs not-safe depends heavily on data/histogram and edge cases, but still quite a lot of low-hanging issues can be easily caught with a deterministic rule engine. So I ported pg_savior[1] and used sql parser from libpg-query-node[2] which compiles as WASM, so it entirely runs on the browser. No telemetry, no login. Source attached [3]

[1] https://github.com/viggy28/pg_savior [2] https://github.com/constructive-io/libpg-query-node [3] https://github.com/viggy28/safe-not-safe

necovek•19m ago
Wow, great idea!

It's not immediately clear from the README, but is it easy to run with multiple profiles like "backwards-compatible", "revertable" (both data and schema) and "destructive" for that final clean-up in multi-staged no-downtime migrations? Basically common subsets of "safe-ness" of the schema migration queries.

I imagine it can be tuned, but I'd love this for all my projects.

And since I am currently on a project doing MS SQL (gasp), that'd be cool too ;)

I am familiar with an "is it a hot dog" app from back in the day, bit would have never made the connection :)

rohansx•23m ago
really like the browser-only approach here - catching the obvious migration risks locally before they ever reach CI feels super useful

Revealing the details of how OpenAI agents hacked Hugging Face

https://swarmtraces.org/
486•specked-citrus•12h ago•293 comments

How to keep enjoying programming in a world of LLMs

https://discourse.haskell.org/t/how-to-keep-enjoying-programming-in-a-world-of-llms/14705
5•signa11•15m ago•1 comments

A single function Jev-like wrapper for LLMs, including vision models

http://allanrbo.blogspot.com/2026/09/a-jev-like-wrapper-for-llms-including.html
68•allanrbo•5h ago•18 comments

We're gonna need a lot more mathematicians

https://terrytao.wordpress.com/2026/09/24/were-gonna-need-a-lot-more-mathematicians/
128•srcreigh•7h ago•155 comments

Plan mode is dead

https://www.aymannadeem.com/artificial/intelligence,/developer/tools/2026/09/24/plan-mode-is-dead...
323•jmvldz•1d ago•299 comments

Ollaya – Ollama for open-source, Jev-style decision models

https://ollaya.dev/
459•Ardakilic•15h ago•117 comments

Is your Postgres migration safe or not safe?

https://safenotsafe.dev/
22•vira28•2h ago•7 comments

Show HN: Jev Plays Pokémon Red

https://jev-pokemon.vercel.app/
201•pancomplex•19h ago•84 comments

What even is an OS now?

https://sockpuppet.org/blog/2026/09/25/what-even-is-an-os-now/
200•fratellobigio•12h ago•282 comments

The Murky History of Soviet-Born Tetris

https://thereader.mitpress.mit.edu/the-bizarre-murky-history-of-soviet-born-tetris/
47•EA-3167•1d ago•12 comments

Floci: Locally emulating any cloud service

https://floci.io
5•theanonymousone•1h ago•0 comments

16GB iPod Nano 3G Upgrade

https://tuckerosman.com/projects/16gb-ipod-nano
11•Ivoah•2d ago•1 comments

Jury finds Facebook liable for deceiving users in Cambridge Analytica case

https://www.cbsnews.com/news/facebook-liable-deceiving-users-cambridge-analytica/
223•pseudolus•8h ago•49 comments

Gravity seems holographic. What does that mean for reality?

https://www.quantamagazine.org/gravity-seems-holographic-what-does-that-mean-for-reality-20260925/
197•ibobev•18h ago•171 comments

Ask HN: Who's still keeping a DOS machine up because the business depends on it?

123•mlaux•14h ago•108 comments

Scientists build most accurate atomic clock

https://phys.org/news/2026-09-scientists-world-accurate-atomic-clock.html
13•wglb•2d ago•3 comments

Fourier Analysis: Drawing Llamas with Circles

https://adekau.github.io/posts/2020/llamas.html
40•cebert•1d ago•2 comments

Postgres SELECT DISTINCT Does Not Scale

https://www.dbos.dev/blog/postgres-select-distinct-does-not-scale
83•KraftyOne•1d ago•23 comments

Excel now supports multiple values in a single cell

https://techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-...
185•luispa•13h ago•137 comments

HomelabFest will be in St. Louis in September 2027

https://www.homelabfest.org
29•geerlingguy•7h ago•15 comments

One Piece of Flock Camera Data Put This Innocent Woman in Jail for 13 Days

https://www.jezebel.com/flock-cameras-data-innocent-woman-arrested-lindsey-isaacs-palm-beach-flor...
175•HotGarbage•8h ago•76 comments

First Principles Thinking

https://sunilsadasivan.com/writing/first-principles-thinking/
263•sunils34•20h ago•112 comments

Show HN: Hacker Atlas - A map of what Hacker News talks about

https://hackeratlas.com/
62•andrearitossa•20h ago•20 comments

Lab on a Contact Lens Can Measure Stress Through Serotonin

https://spectrum.ieee.org/serotonin-stress-smart-contact-lens
42•marc__1•11h ago•11 comments

I wrote a ray tracer in Brainfuck

https://epestr.com/blog/writing-a-ray-tracer-in-brainfuck/
73•epestr•23h ago•17 comments

A new world airport and its baggage

https://computer.rip/2026-09-20-denver-baggage.html
23•firloop•2d ago•2 comments

Remembering Johannes Doerfert

https://blog.llvm.org/posts/2026-09-24-rememberingjohannesdoerfert/
92•sdko•1d ago•2 comments

Alberta's image as world's only rat-free region shattered by discovery of rat

https://www.theguardian.com/world/2026/sep/25/alberta-canada-rat-patrol
22•pseudolus•3h ago•17 comments

U.S. appeals court upholds designation of Anthropic as supply chain risk

https://www.cnbc.com/2026/09/25/pentagon-anthropic-ai-risk-appeals-court.html
445•cramer4next•18h ago•767 comments

Microsoft abandons personal AI chatbot race with Copilot reboot

https://www.bloomberg.com/news/articles/2026-09-25/microsoft-abandons-personal-ai-chatbot-race-wi...
125•sbulaev•19h ago•117 comments