Dev tools · alternatives · 2026
24 alternatives to Stanchion – Column-oriented tables in SQLite
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…
Stanchion adds column-oriented table storage to SQLite, enabling data warehouse capabilities on resource-constrained devices without requiring separate database infrastructure. Designed for applications already using… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Prices are shown for the 1 we have checked on their own sites, 1 of them free or with a free tier. Stanchion – Column-oriented tables in SQLite launched in 2024; newer entries below may have overtaken it.
- 1SO
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 →
- 2
"Mongita is to MongoDB as SQLite is to SQL". Contribute to scottrogowski/mongita development by creating an account on GitHub.
2021 · github.com · its alternatives →
- 3
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 4
I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…
2025 · menial.co.uk · its alternatives →
- 5
This is a simple graph database in SQLite, inspired by "SQLite as a document database" - dpapathanasiou/simple-graph
2020 · github.com · its alternatives →
- 6
Hi HN, I have been making this Cozo database since half a year ago, and now it is ready for public release. My initial motivation is that I want a graph database. Lightweight and easy to use, like SQLite. Powerful and performant, like Postgres. I found none of the existing solutions good enough. Deciding to roll my own, I need to choose a query language. I am familiar with Cypher but consider it not much of an improvement over CTE in SQL (Cypher is sometimes notationally more convenient, but not more expressive). I like Gremlin but would prefer something more declarative. Experimentations…
2022 · github.com · its alternatives →
- 7
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 →
- 8
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 →
- 9
Capsule packages your entire app — UI, data, and assets — into a single portable file. No cloud. No accounts. Just share it.
Sep 2026 · withcapsule.app · its alternatives →
- 10DU
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…
2023 · npmjs.com · its alternatives →
- 11
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 →
- 12
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
- 13
Bunny Database▲244The content delivery platform that truly hops.
Feb 2026 · bunny.net · its alternatives →
- 14
We just launched Outerbase Studio, the open-source version of our core database offering. It works in your browser or as a desktop app and supports MySQL, PostgreSQL, and SQLite. What it does: • Connects to MySQL, PostgreSQL, and SQLite databases. • Spin up local databases directly through the UI, even if you don’t have one running. • Manage and query your data in a lightweight, intuitive interface. • Completely open source. Why we built it: We wanted to share the core Outerbase experience with the developer community as a free, open-source tool. It’s simple, fast, and removes the barriers…
2024 · github.com · its alternatives →
- 15
A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.
2023 · github.com · its alternatives →
- 16
Build a database-backed full-stack app in under a minute.
2021 · blog.glitch.com · its alternatives →
- 17
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…
2024 · github.com · its alternatives →
- 18
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 →
- 19
Hey HN, we want to share HelixDB (https://github.com/HelixDB/helix-db/), a project a college friend and I are working on. It’s a new database that natively intertwines graph and vector types, without sacrificing performance. It’s written in Rust and our initial focus is on supporting RAG. Here’s a video runthrough: https://screen.studio/share/szgQu3yq. Why a hybrid? Vector databases are useful for similarity queries, while graph databases are useful for relationship queries. Each stores data in a way that’s best for its main type of query (e.g.…
2025 · github.com · its alternatives →
- 20
- 21
WunderBase is an open source Serverless GraphQL database built on SQLite, Firecracker, and Prisma. Sleep mode saves cost—perfect for fast, lightweight apps.
2022 · wundergraph.com · its alternatives →
- 22
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…
Mar 2026 · github.com · its alternatives →
- 23
Hi HN! I’m Justin, founder and CEO of Arctype, and we’re very excited to share Arctype with the community. Arctype is a cross-platform GUI (soon to be open-sourced) to manage and query your databases, with built-in collaboration and visualization. It currently supports Postgres, MySQL, and SQLite, as well as newer-generation databases like ClickHouse, PlanetScale, and Yugabyte (and more coming very soon!). Think of Arctype as “phpMyAdmin meets Postman”. Most of our team grew up learning how to program using the LAMP stack and we missed the experience of interacting with our databases using…
2022 · arctype.com · its alternatives →
- 24
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/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/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/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 →
Also compare
- SQLite Online – 11 years of solo development, 11K daily users alternatives
- Mongita is to MongoDB as SQLite is to SQL alternatives
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- Base, an SQLite database editor for macOS alternatives
- Simple-graph – a graph database in SQLite alternatives
- Cozo – new Graph DB with Datalog, embedded like SQLite 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 →