Distributed SQLite on FoundationDB

In plain words

Distributed SQLite on FoundationDB is a drop-in replacement for SQLite that adds multi-version concurrency control and runs on FoundationDB. It requires only an `LD_PRELOAD` to work with existing SQLite applications. Built to provide SQL capabilities for the Blueboat platform, it offers a self-hostable distributed SQL database that addresses FoundationDB's transaction size and duration limits through a multi-version page store backend.

written from the facts on this page · September 2026

From the sources

Distributed, MVCC SQLite that runs on FoundationDB. - losfair/mvsqlite

In the maker’s words, at launch

Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https://github.com/losfair/blueboat) needs a native…

• SO
  SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

  SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

• 
  Embed an SQLite database in your PostgreSQL table2024 · github.com · ▲180

  pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…

• DU
  Doculite – Use SQLite as a Document Database2023 · npmjs.com · ▲160

  Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…

• 
  Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3Mar 2026 · github.com · ▲185

  I built a SQLite VFS in Rust that serves cold queries directly from S3 with sub-second performance, and often much faster. It’s called turbolite. It is experimental, buggy, and may corrupt data. I would not trust it with anything important yet. I wanted to explore whether object storage has gotten fast enough to support embedded databases over cloud storage. Filesystems reward tiny random reads and in-place mutation. S3 rewards fewer requests, bigger transfers, immutable objects, and aggressively parallel operations where bandwidth is often the real constraint. This was explicitly inspired…

• 
  Bi-directional sync between Postgres and SQLite2023 · powersync.com · ▲356

  Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…

• 
  Replicate App-Embedded DuckDBs into PostgreSQL with SyncLite OSS2024 · github.com · ▲73

  Hi HN, We have been building SyncLite, an open-source platform to simplify offline-first application development. If your application uses SQLite or DuckDB, SyncLite lets it continue using the local database as usual while synchronization happens in the background. For SQL-based applications, SyncLite records transactions into transactionally consistent .sqlog files using SQLite as an open replication format. A background consolidator replays those transactions, derives row-level CDC and schema changes, and applies them transactionally to destination databases like PostgreSQL. The same…

• 
  /dev/null▲481

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲341

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  Locofy.ai▲720

  Hey there, I am Honey - Co-founder at Locofy. We, along with other makers, have been building Locofy.ai to help massively accelerate the builders - the designers, developers, product managers & founders, and we're excited to share it today with the HN Community. Locofy.ai simply converts designs into production-ready frontend code for web and mobile apps. It adapts to your preferred design tools, tech stack, and workflows with ease and lets you launch upto 4x faster, while letting designers design the way they want and giving high-quality responsive code that developers love. With this…

  Dev tools · 2022 · locofy.ai

• PO
  Porting OpenBSD Pledge() to Linux▲571

  Life & fun · 2022 · justine.lol

• 
  PocketBase – Open Source realtime backend in one file▲563

  Open Source realtime backend in 1 file. Contribute to pocketbase/pocketbase development by creating an account on GitHub.

  Dev tools · 2022 · github.com

• 
  ruttl▲552

  Visual & Design Feedback Tool that helps you review design, content and report bugs on websites, applications, PDFs and images.

  Dev tools · 2022 · ruttl.com

• 
  Pipes puzzle (a.k.a. Net) on a hexagonal grid▲537

  Hello, HN - I wanted to share this puzzle game I made during my vacation. I'm rather fond of the pipes puzzle where your goal is to restore a scrambled network of connections by rotating tiles. It's usually played on a grid of squares and this all started when I decided to make a programmatic solver for that kind of puzzle. Then I realized that with some minor changes the solver could generate new puzzle instances. I thought about what kind of puzzle to make and someone suggested a hexagonal grid. Adapting the generator wasn't too hard but then I had to create a way to play this variant. So…

  Life & fun · 2022 · hexapipes.vercel.app

• 
  Parsnip – Duolingo for Cooking▲536

  We're building Parsnip to create a "tech tree" of cooking skills that allows anyone to level up on the building blocks of cooking knowledge while tracking their progress over time. It took us a few iterations to figure out the right product; here's the story of our latest pivot: [https:&#x2F;&#x2F;parsnip.substack.com&#x2F;p&#x2F;a-new-hope] The goal is to create a personalized way to learn any recipe on the Internet, then use this as a springboard to help home cooks of all levels solve the problem of repeated meal planning in a 10x better way:…

  Work · 2022 · parsnip.ai