CloudKit vs SQLDelight

CloudKit is Apple’s service for storing structured app and user data in iCloud and synchronizing it across devices and the web. Data is organized in containers with public, private, and shared databases, and synchronization is bidirectional across iOS, iPadOS, macOS, tvOS, watchOS, visionOS, and web apps. CloudKit supports Swift, Objective-C, and JavaScript. Apple Developer Program membership includes up to 1PB of free storage for each app. CloudKit Console lets developers manage containers and schemas, inspect test data, and review telemetry, logs, and alerts. Fields in private databases can be configured for encryption in storage and while travelling to the application. Public databases use World, Authenticated, and Creator roles. Separate sandbox and production environments are provided; production schemas can only be changed in a forward-compatible manner. Automation supports integration tests from Xcode or a CI system, and CKTool JS can be embedded in developer tools. CloudKit JS adds CloudKit support to web apps. A free plan is listed at free, while pricing is from $99/yr. Incoming traffic is throttled by limits and controls that may change over time.

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.