Firestore vs SQLDelight
Firestore
cloud.google.comSQLDelight
sqldelight.github.ioSide by side
| Figure | Firestore | SQLDelight |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | Yes |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| iOS | Yes | Yes |
| Android | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 9 | 2 |
| Spec score · Mobile Databases | 9.2 (#1) | 8.3 (#5) |
| Documentation depth | The documentation set includes developer guides, API references, source repositories, issue trackers, Stack Overflow links, samples, and library integrations. | The generated API reference exposes separate modules for drivers, compiler, Gradle plugin, dialects, migrations, coroutines, RxJava, paging, JSON, and adapters. |
| Integrations | The product page names Google AI Studio, remote MCP, LangChain, and LlamaIndex integrations for building generative AI applications. | The docs provide extensions for Kotlin coroutines, RxJava, and AndroidX Paging, alongside a Gradle plugin. |
| What it does | Firestore is a fully managed, scalable JSON document database for mobile, web, and server applications. | SQLDelight converts SQL statements into type-safe Kotlin APIs and checks schemas, queries, and migrations during compilation. |
Plans
Firestore
- Standard edition — document readsPrice not published
- Standard edition — document writesPrice not published
- Standard edition — document deletesPrice not published
- Standard edition — stored dataPrice not published
- Free quotaFree
- Free quotaFree
- Standard edition pay-as-you-go$0.03 a month
- Enterprise editionPrice not published
- Standard editionPrice not published
In their own words
Firestore
Firestore is a fully managed, serverless document database for building AI, web, and mobile applications. It stores flexible JSON data and supports vector search, full-text search, geospatial queries, and ACID transactions on JSON or BSON-compatible documents. Client SDKs for Android, iOS, and web provide real-time updates and automatic syncing for offline access. Firestore can replicate data across multiple regions with strong consistency; multi-region deployments have a stated 99.999% SLA-backed availability. Integrations named for generative AI application work include Google AI Studio, remote MCP, LangChain, and LlamaIndex. Identity controls connect with Cloud IAM, Cloud Identity Platform, and Firebase Authentication. Data is encrypted before it is written to disk, with customer-managed keys available through Cloud KMS. The free quota applies to one database per project and includes 1 GiB of storage, daily read, write, and delete allowances, and 10 GiB monthly outbound transfer. New customers receive $300 in credits, separate from that quota. Server client libraries bypass Firestore Security Rules, so server access needs IAM controls.
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.