SQLDelight vs WatermelonDB
SQLDelight
sqldelight.github.ioWatermelonDB
watermelondb.devSide by side
| Figure | SQLDelight | WatermelonDB |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | Yes | — |
| Web | Yes | Yes |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| iOS | Yes | Yes |
| Android | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | — |
| Plans published | 2 | 1 |
| Spec score · Mobile Databases | 8.3 (#5) | 7.6 (#21) |
| Integrations | The docs provide extensions for Kotlin coroutines, RxJava, and AndroidX Paging, alongside a Gradle plugin. | The docs describe React and React Native usage, an optional RxJS API, and a JavaScript API for other UI frameworks. |
| Platforms | The docs list SQLite support for Android, native iOS/macOS/Linux/Windows, JVM, JavaScript in browsers and Node, and multiplatform projects. | The installation guide documents iOS, Android, web, Node.js, and experimental React Native Windows support. |
Plans
In their own words
SQLDelight
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.
WatermelonDB
WatermelonDB is a free, MIT-licensed reactive database framework for React and React Native applications. It is built for offline-first apps that synchronize local data with a remote database. Records load lazily, and queries run directly on SQLite on a separate native thread. The project describes a target scale from hundreds to tens of thousands of records. Record changes automatically re-render dependent UI components. Sync primitives and a built-in adapter work with backend endpoints that follow WatermelonDB’s protocol, but developers must provide that backend. Documented storage uses SQLite for React Native and Node.js, and LokiJS for web. Optional RxJS and JavaScript APIs support other UI frameworks. React Native Windows support is experimental, requires JSI and lacks Turbo Sync. The framework supports bidirectional synchronization and automatic conflict resolution, with documented sync edge cases.