About SQLDelight
SQLDelight is an open source tool that generates type-safe Kotlin APIs from SQL statements. It checks your schema and queries at compile time and works with SQLite and several other databases.
What it does
You write SQL statements and SQLDelight generates Kotlin code to run each one. It verifies the schema, statements and migrations during the build. IDE features such as autocomplete and refactoring work on the SQL, which makes the database code easier to maintain as the project grows.
Key features
- Type-safe Kotlin APIs generated from SQL
- Compile-time checks for schema and queries
- Migration verification
- SQLite on Android, iOS, JVM and JavaScript
- Gradle plugin setup
Who it's for
SQLDelight suits Kotlin developers who prefer writing SQL directly instead of using an ORM. It also helps multiplatform teams that share database code across targets, and Android developers who want typed queries.
Pricing and good to know
SQLDelight is open source under the Apache 2.0 license. Snapshot builds are published in the Central Portal. If you are moving from version 1.x, read the upgrade guide first, because version 2.0 changed the package names used in the build coordinates.
Highlights
- Generate typed Kotlin code from SQL statements
- Catch schema and query errors at compile time
- Verify migrations as part of the build
- Use SQLite on Android, iOS, JVM and JavaScript
