Dev tools · alternatives · 2026

24 alternatives to BSON Extension for SQLite

sqlite is, well, everywhere. It's a little shy on high-fidelity types, though, esp no dates and penny-precise numbers. And carrying rich shapes in JSON doesn't really help because JSON lacks those too. BSON supports these types but more importantly is a data carrier external to the database; you can fluidly move BSON in and out of sqlite without creating your own binary representations; just use the BSON SDK for your environment. Upwards of 20 languages are supported. The BSON extension is designed to exploit sqlite built-in JSON functions as desired.

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. BSON Extension for SQLite launched in 2024; newer entries below may have overtaken it.

1. 1
   BSON Extension for Postgres▲115

   JSON support in postgres is superb but sometimes you really want decimal, date, and binary types, "carefree" UTF8 string handling (i.e. no escaping), and robust roundtrippability. So I made an extension for BSON.

   2024 · github.com · its alternatives →

2. 2
   SQLite JavaScript - extend your database with JavaScript▲199

   Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js

   2025 · github.com · its alternatives →

3. 3
   Datasette – Create and publish an API for SQLite databases▲269

   I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, …

   2017 · simonwillison.net · its alternatives →

4. 4
   A SQL database implemented purely in TypeScript type annotations▲426

   A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql

   2020 · github.com · its alternatives →

5. 5SO
   SQLite Online – 11 years of solo development, 11K daily users▲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

   2025 · sqliteonline.com · its alternatives →

6. 6
   Stanchion – Column-oriented tables in SQLite▲273

   Hello HN! I built stanchion to scratch my own itch. I have personal applications running on SQLite where I want to store log and metric data (basically forever) but don't want to add complexity by bringing in a new database or whole separate server. Some of these applications are running on a Raspberry Pi, where storage and compute are limited, but I still want data warehouse like capabilities. I envision stanchion being used in similar scenarios: on phones and resource-limited devices in applications that are already using SQLite. I know that there are alternatives like DuckDB (which is…

   2024 · github.com · its alternatives →

7. 7
   NoSQL, but it's SQLite▲98

   Manipulate your SQLite database like a giant Javascript object. Built with o1.

   2024 · gist.github.com · its alternatives →

8. 8
   Bi-directional sync between Postgres and SQLite▲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…

   2023 · powersync.com · its alternatives →

9. 9
   I wrote a RDBMS (SQLite clone) from scratch in pure Python▲371

   I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

   2023 · github.com · its alternatives →

10. 10
    Node.js ORM to query SQL database through an array-like API▲123

    Hello everyone! I'm exited to share a NodeJS package I was working on for the past two months. The package is designed to simplify querying SQL databases through an array-like API. Qustar supports PostgreSQL, SQLite, MySQL, and MariaDB, and offers TypeScript support for a robust development experience. It's in early stage of development. I would like to hear your thoughts about it.

    2024 · github.com · its alternatives →

11. 11
    MongoDB Protocol for SQLite▲147

    A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.

    2023 · github.com · its alternatives →

12. 12DU
    Doculite – Use SQLite as a Document Database▲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&#x2F;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…

    2023 · npmjs.com · its alternatives →

13. 13
    Querying JSON documents using SQL-like language in Scala▲70

    SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql

    2020 · github.com · its alternatives →

14. 14DP
    Datasette Publish – Turn CSVs into a SQLite-Backed JSON API▲101

    2018 · publish.datasettes.com · its alternatives →

15. 15
    SQLite Plugin for Jekyll▲227

    I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV&#x2F;JSON&#x2F;YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering&#x2F;sorting&#x2F;merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll&#x2F;Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…

    2024 · github.com · its alternatives →

16. 16
    Sqlify▲191

    JSON, CSV and SQL converter

    2017 · its alternatives →

17. 17
    Embed an SQLite database in your PostgreSQL table▲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…

    2024 · github.com · its alternatives →

18. 18SA
    Squirrelbyte – a SQLite-based JSON document server▲118

    2021 · squirrelbyte.com · its alternatives →

19. 19
    Distributed SQLite on FoundationDB▲150

    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:&#x2F;&#x2F;github.com&#x2F;losfair&#x2F;blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…

    2022 · github.com · its alternatives →

20. 20
    Postgres-SQLite: SQLite as first-class types in Postgres▲15

    In Memory SQLlite as a Postgres data type. Contribute to michelp/postgres-sqlite development by creating an account on GitHub.

    2025 · github.com · its alternatives →

21. 21
    LatticeDB – Like SQLite but for graph databases▲190

    We have been using graph DBs more and more at work. I found them painful to work with locally and decided to try and build something better.

    Aug 2026 · github.com · its alternatives →

22. 22
    TABLUM.IO▲159

    Turn CSV, XML & JSON into a live analysis-ready SQL database

    2023 · tablum.io · its alternatives →

23. 23BA
    BedquiltDB – A Mongo-like JSON doc store built on Postgres▲145

    2016 · bedquiltdb.github.io · its alternatives →

24. 24
    A parser for sqlite databases to implement full ALTER TABLE support▲19

    A parser for SQLite create table sql statements. Contribute to marcobambini/sqlite-createtable-parser development by creating an account on GitHub.

    2018 · github.com · its alternatives →

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →