LiteDB vs SQLDelight

LiteDB is a free, open-source, serverless .NET NoSQL document database distributed as a single DLL. It stores data in one file and supports ACID transactions, with WAL mode for recovery from write failures. Queries can use SQL-like commands or LINQ, and query EXPLAIN plans are available. LiteDB maps POCO classes to BsonDocument and offers a fluent API for custom mapping. Its intended uses include mobile apps, desktop and local applications, application file formats, web applications, and per-user data stores. FileStorage can keep files and streams in the database, though each root BSON document has a documented 16 MB limit. LiteDB describes itself as thread-safe, with cross-collection transactions, no reader locks, and per-collection writer locks. Password-protected datafile encryption uses salted AES; the documentation specifies ECB mode and says changing or removing a password requires rebuilding the file. LiteDB is free for everyone, including commercial use, under the MIT License. It is installable through NuGet, and the project links to LiteDB.Studio as an administration tool.

SQLDelight generates typesafe Kotlin APIs from SQL statements and checks database schemas, SQL statements, and migrations at compile time. Its IDE features include SQL autocomplete and refactoring support. Documented database dialects include SQLite, MySQL, and PostgreSQL; HSQL and H2 are experimental, while CockroachDB, DB2, and Oracle dialects are listed as third-party options. The JVM connection overview lists MySQL and PostgreSQL, with JDBC and R2DBC variants shown for supported dialects. The project provides a Gradle plugin and extensions for Kotlin coroutines, RxJava, and AndroidX Paging. Its coroutines extension can expose a query as a Flow and emit updated results when the queried data changes. The Gradle verifySqlDelightMigration task applies migrations to stored schema databases and checks whether they reach the latest schema. SQLDelight is open source under the Apache-2.0 license and has a free listing at free, with no paid tiers stated. Its listed platforms are Android, API, iOS, Linux, macOS, web, and Windows.