frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Show HN: Belay – formal verification for SQLite migrations and queries in Lean 4

https://github.com/vihren-dev/belay
3•neprotivo•25m ago
Hi, I'm Tzanko and I'm the author of Belay.

Belay is a Lean 4 library for doing formal verification of SQLite queries and migrations. It implements a semantic model of a subset of SQLite, validated by differential tests that compare the output against native SQLite.

With Belay I wanted to see how difficult it is to use formal verification for everyday development tasks. It turns out it can be made not much harder than writing an integration test: you state the claim, the agent writes the proof, and Lean's kernel checks it, so the only thing you have to read is the claim (longer write-up on the motivation and agent workflow: https://vihren.dev/blog/20261112-belay/).

While a migration is being written, your agent can run #sql_check, which searches small databases for counterexamples to a claim, and is as easy to run as a linter.

Once the migration is settled, the agent writes a proof of the claims you need, for example that the migration preserves the results of existing queries and succeeds on valid data.

Currently Belay supports a subset of SQLite 3.51.0, cross-checked against native SQLite on 5,768 differential test cases, most of which come from SQLite's own test suite. Unsupported SQL is rejected with a reason and never approximated. Not every rule of the model has had a human audit yet. The model covers single-connection operational semantics only: it says nothing about query plans, locks, concurrency or crash behavior.

I think this approach can make formal verification as routine as testing, though two things stand in the way. The first is coverage: the model has to cover the full semantics of SQLite and all of its recent versions, and the same work has to be done for other engines such as PostgreSQL and ClickHouse. The second is proof cost: the proofs of common claims are still long for the agent to write, and they have to become short. I'm looking for design partners who want this for their workloads on SQLite or other open-source databases, because a real workload is the best guide to what to cover first. The models that come out of that work become part of Belay as open source. Reach out at contact@vihren.dev.

If you know a tricky SQLite edge case where the model might diverge from native SQLite, or a gnarly migration bug you've hit in production, I'd love to test it and hear your thoughts.

Gears (2020)

https://ciechanow.ski/gears/
1•dverlaeckt80•40s ago•0 comments

Vera Rubin NVL72: 2x Blackwell Ultra Performance in MLPerf Training v6.1

https://developer.nvidia.com/blog/nvidia-vera-rubin-nvl72-achieves-up-to-2x-blackwell-ultra-perfo...
1•wondersky•51s ago•0 comments

Efficacy of exercise therapies in knee osteoarthritis (network meta-analysis)

https://pmc.ncbi.nlm.nih.gov/articles/PMC13762337/
1•chavasorani•1m ago•0 comments

Show HN: Kalka – An open-source design tool where every layer is real HTML/CSS

https://github.com/leyscore/kalka
1•bauriceley•1m ago•0 comments

Show HN: LooPo – A word completion game run in the browser

https://loopo.online
1•yuzman•1m ago•0 comments

Using Tries to resolve bash command effects in 343 nanoseconds

https://dirac.run/posts/braket
1•GodelNumbering•2m ago•0 comments

Show HN: A base language model in Kannada (435M)

https://huggingface.co/SuhasBhairav/kalike
1•techappsdev•3m ago•0 comments

Show HN: Rewrite, a free editor that rewrites text and edits Word, LaTeX and PDF

https://github.com/SamratDuttaOfficial/Rewrite
1•TheDutta•4m ago•0 comments

Show HN: Skiss – Save websites with their real CSS, fonts and full-page shots

https://skiss.co/
1•tmaxxco•4m ago•0 comments

S. Korea to send nationwide emergency alerts over college entrance exam cheating

https://apnews.com/article/south-korea-exam-cheating-ai-college-e25b5612dbf4bd09fdf9197254c4547e
2•parksb•5m ago•0 comments

Show HN: An open virtual office to cowork with humans while your agents work

https://flat.social/virtual-office-platform
4•pawelwentpawel•5m ago•0 comments

InvizCrypt Interactive Docs Demo

https://www.invizcrypt.com/docs/privacy-demo
1•htewari•5m ago•0 comments

Saving money for the distant future is pointless with the advent of super intell

https://elonmuskarchive.org/posts/2115686311134744736
1•mudiadamz•7m ago•0 comments

The Useless Computer

https://bitfieldconsulting.com/posts/useless-computer
1•dxs•7m ago•0 comments

Keep your primary GPG key offline – Part 2

https://marcofranssen.nl/keep-your-primary-gpg-key-offline-part-2
1•marcofranssen•7m ago•0 comments

Larkdown: New default "open with" app for .md files on Mac

https://github.com/mikeokner/Larkdown
1•mikeokner•7m ago•0 comments

A shared AI works for the meeting. Yours works for you

https://ethanflow.com/writing/whose-ai-in-the-meeting/
2•ethan-ys•10m ago•0 comments

Pinecall – Open-source framework for voice apps, built on LiveKit

https://github.com/pinecall/pinecall
2•bernatch•10m ago•0 comments

SpaceX launched more mass to orbit this year than Europe in its history

https://www.kadoa.com/companies/insights/spacex-europe-payload
1•hubraumhugo•10m ago•1 comments

When Jorge Luis Borges Co-Wrote a Surreal Sci-Fi Noir Film: Invasión (1969)

https://www.openculture.com/2026/11/when-jorge-luis-borges-co-wrote-a-surreal-sci-fi-noir-film-in...
2•Brajeshwar•14m ago•0 comments

The Dark Side of the Moon Was the Brightest Part of 2026

https://www.wired.com/story/wired-yearbook-2026-artemis-crew/
2•Brajeshwar•15m ago•0 comments

Show HN: Tom – meeting recording and feedback specs, all locally on Mac

https://github.com/automatics-dev/mac-tom
3•mirceapreotu•15m ago•0 comments

Why was that backup so large?

https://eclecticlight.co/2026/11/17/why-was-that-backup-so-large/
3•Brajeshwar•15m ago•0 comments

ISO coding agent power users to try a new cloud – VC Backed company

https://console.openinfer.ai/register
1•cjbuffington•16m ago•0 comments

BlameGraph – Know which step broke your multi-agent run

https://agentschecked.com/try/
1•nickzoomer•17m ago•0 comments

Fact-Checking at Scale: Building a More Accurate Synopsis Factuality System

https://netflixtechblog.com/fact-checking-at-scale-building-a-more-accurate-and-efficient-synopsi...
1•torutofu•17m ago•0 comments

European Commission to Give Border Agency Frontex “Trusted Flagger” Status

https://www.eff.org/deeplinks/2026/11/european-commission-plan-give-frontex-trusted-flagger-statu...
1•iamnothere•19m ago•0 comments

How Much More Expensive Has Life Become Since 2020?

https://mfaani.com/posts/personal-finance/how-much-more-expensive-has-life-become-since-2020/
1•speckx•19m ago•0 comments

No Pain (no) Mind: my first year of Zen

https://objectiveobservations.substack.com/p/no-pain-no-mind
1•tskj•22m ago•0 comments

Planning, data and AI: where human judgment takes over

https://www.bmj.com/content/395/bmj-2026-101449
2•dberhane•22m ago•0 comments