Ditto vs SQLDelight

Ditto is a distributed database and Edge SDK for applications that must operate when networks are unreliable or unavailable. Its embedded database lets devices read and write offline, then synchronize through Bluetooth Low Energy, peer-to-peer Wi‑Fi, or a local area network without internet access or extra hardware. Devices using the SDK can form wireless mesh networks for real-time sharing in bandwidth-constrained environments. Ditto automatically resolves conflicts between peers and with the cloud when available. The platform supports Android, iOS, Windows, and Linux, with SDK languages including Swift, Kotlin, JavaScript, C#, C++, Rust, Flutter, and React Native. The Free plan costs nothing and includes 10 cloud device connections, 2GB storage, 5GB transfer, limited support, and no SLA.

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.