SQLite Alternatives for Embedded and Serverless Databases

SQLite is alive and well maintained. The SQLite homepage lists version 3.54.1, released on October 16, 2026, and the source code remains in the public domain. It is still the default choice for an embedded database: one file, no server, and a library small enough for phones, browsers and desktop apps.

People look past it for a few specific reasons. SQLite allows many readers but only one writer at a time. It has no network protocol, so several servers cannot share one file. Column-heavy analytics run slower than in a columnar engine. Mobile teams have a fresh reason too: MongoDB deprecated its Atlas Device SDKs and Device Sync in September 2024 and removed them on September 30, 2025, per its deprecation notice. The seven picks below each fix one of those gaps, and the order runs from closest to SQLite to most different.

Prices below are as of November 8, 2026. Our method is on How we review tools.

Quick comparison

Turso

Turso started as libSQL, a fork of SQLite, and is now a from-scratch rewrite in Rust that reads and writes existing SQLite files. The headline feature is BEGIN CONCURRENT, which uses multi-version concurrency control so several transactions can write at once. The Turso repository also lists change data capture, vector search and io_uring async I/O on Linux, with Postgres compatibility and encryption at rest still marked experimental.

The same company runs a hosted service that syncs local databases to the cloud. Its free plan covers 100 databases, 5 GB of storage, 500 million rows read and 10 million rows written each month. On npm, @tursodatabase/database 0.8.3 is the current package, from October 12, 2026, under MIT.

Best for: Apps that hit SQLite's single-writer limit but want to keep the file format and the SQL dialect.

Pricing:

• Free: $0, 100 databases, 5 GB, 500 million rows read and 10 million written a month
• Developer: $4.99 a month billed yearly or $5.99 billed monthly; 9 GB, then $0.75 per GB
• Scaler: $29 a month billed monthly, or $24.92 a month billed yearly ($299 a year); 24 GB included
• Pro: $499 a month billed monthly, or $416.58 a month billed yearly ($4,999 a year); 50 GB included
• Enterprise: custom; prices in US dollars

Watch out for:

• It is not 1.0 yet. The project FAQ says some features are experimental and tells users to keep independent backups.
• Compatibility with SQLite is not complete. A COMPAT.md file in the repository tracks the gaps, and full compatibility is a stated 1.0 goal.

Official site: Turso.

PostgreSQL

Move to PostgreSQL when the app needs several servers writing to one database, row-level locking, or roles and permissions per user. It is the most common next step after SQLite, and most SQL you wrote for SQLite runs with small changes. Postgres also adds stricter types, real ALTER TABLE support and a large extension catalogue such as PostGIS and pgvector.

The PostgreSQL site shows PostgreSQL 18 as the current major version, with 19 in release candidate. Version 14 reaches end of life in November 2026. If you would rather not run a server, our Neon alternatives page compares managed and serverless Postgres hosts.

Best for: Apps with several writers or servers that have outgrown one database file.

Pricing:

• Free and open source under the PostgreSQL License
• Managed hosting billed by the provider

Watch out for:

• You now run a server. Backups, upgrades between majors, connection limits and pooling become your job or your host's.
• Each major is supported for about five years, so a version 14 install, which reaches end of life in November 2026, already needs an upgrade plan.

Official site: PostgreSQL.

DuckDB

DuckDB is in-process like SQLite but built for analytics. It stores data by column, runs queries on many cores and reads Parquet, CSV and JSON files directly, so a GROUP BY over millions of rows that drags in SQLite returns in seconds. It is a library you import from Python, R, Java, Node.js and other languages, with no server to install.

Version 2.0.0 arrived on PyPI on October 21, 2026, and the Python package needs Python 3.11 or newer. Many teams keep SQLite for the app and use DuckDB beside it for reports, since DuckDB can attach and query SQLite files.

Best for: Data analysis and reporting on large tables or files inside a single process.

Pricing:

• Free, MIT licence
• MotherDuck sells a hosted service built on DuckDB, priced separately

Watch out for:

• Only one process can open a database for writing. The concurrency docs say other processes get read-only access, and two threads updating the same row produce a conflict error.
• It is tuned for scans, not for thousands of small inserts and updates per second, which is what most app back ends do.

Official site: DuckDB.

PGlite

PGlite compiles Postgres to WebAssembly and packs it into a download under 3 MB gzipped. That gives you SQLite's embedded model with Postgres SQL, types and extensions, and pgvector and PostGIS load at runtime. It runs in the browser and in Node.js, Bun and Deno.

Data lives in memory by default, in IndexedDB in the browser or in a folder on disk in server runtimes, per the PGlite docs. The npm package @electric-sql/pglite is at 0.5.15, published on November 3, 2026, and is dual-licensed under Apache 2.0 and the PostgreSQL License.

Best for: Local-first web apps and tests that should run the same SQL as a production Postgres server.

Pricing:

• Free, Apache 2.0 or PostgreSQL License

Watch out for:

• There is one exclusive connection per database. Browser tabs that share data need the multi-tab worker the docs describe.
• Version 0.5 is pre-1.0, so expect API changes between releases.

Official site: PGlite.

ObjectBox

For mobile developers moving off MongoDB's Atlas Device SDKs, ObjectBox is the most direct swap. You store objects rather than rows, so there is no SQL layer or mapping code, and it adds on-device vector search for local AI features. Bindings exist for Kotlin, Java, Swift, Dart and Flutter, Go, C and Python.

The ObjectBox FAQ lists Android 5.0 or newer, 64-bit iOS 12 or newer, Linux, Windows and macOS 10.15 or newer. An optional Sync product keeps devices and servers in step, which is the piece MongoDB shut down.

Best for: Android, iOS and Flutter apps that stored objects with the Atlas Device SDKs and need a maintained replacement.

Pricing:

• Local database: free to try and use
• ObjectBox Sync: price on request through a demo booking

Watch out for:

• Only the language bindings carry a clear open source licence. The Java repository is Apache 2.0 but says other components have their own terms on the website.
• Sync has no public price, so budgeting for offline sync means a sales call.

Official site: ObjectBox.

H2

H2 is SQLite's counterpart for the JVM. It is pure Java in a jar of around 2.5 MB, and it runs embedded in your process, as a server, or entirely in memory. That last mode is why so many Spring and Java projects use it for fast unit tests that need a real SQL database.

The H2 home page lists version 2.5.252 from September 23, 2026. A built-in web console lets you browse and query a database during development without a separate client.

Best for: Java and Kotlin apps that want an embedded database or a throwaway test database.

Pricing:

• Free, open source

Watch out for:

• It is a Java library. Apps written in other languages cannot embed it and must talk to its server mode instead.
• Files from the old 1.4 line do not open in 2.x. Moving them means exporting to a SQL script and importing it again.

Official site: H2.

LiteDB

LiteDB brings the one-file idea to .NET as a document store. You save C# objects as BSON documents in a single data file, query them with LINQ, and ship the whole engine as one DLL under 450 KB. It needs no native binaries, which avoids the platform packaging issues some .NET apps have with SQLite.

The latest stable release on NuGet is 5.0.21 from July 5, 2024, with 48.5 million downloads in total. Version 6 is in long-running prereleases, the newest being 6.0.0-prerelease.355 from October 26, 2026.

Best for: .NET desktop and small server apps that store documents rather than relational tables.

Pricing:

• Free, MIT licence

Watch out for:

• Do not rely on its encryption. The LiteDB README says datafile encryption is currently not secure and should not be used.
• The last stable release is more than two years old, and version 6 has not left prerelease.

Official site: LiteDB.

How to choose

When to stay with SQLite

Stay with SQLite if one process does the writing, which covers most mobile apps, desktop tools, small websites and local caches. Its appropriate uses page spells out where it fits and where a client/server database is better. WAL mode lets readers keep working while a write is in progress, and the public domain licence means no legal review. Switch only when you can name the limit you hit.

Frequently asked questions