Developer library

Sqldelight guides for real project decisions

Nine static, focused guides explain setup, query design, testing, adapters, migrations, platform planning and troubleshooting without external dependencies.

Sqldelight Example for Kotlin Multiplatform feature image
Example

Sqldelight Example for Kotlin Multiplatform

Follow a practical Sqldelight example with schema files, labeled queries, generated Kotlin APIs, driver boundaries and a small repository workflow.

Read Guide
SQLDelight vs Room: Choosing a Database Layer feature image
Comparison

SQLDelight vs Room: Choosing a Database Layer

Compare SQLDelight vs Room for SQL control, generated APIs, annotations, migrations, Kotlin Multiplatform targets, testing and team workflow.

Read Guide
Sqldelight Wasm Planning Guide feature image
Platform

Sqldelight Wasm Planning Guide

Plan a Sqldelight wasm target carefully by checking driver availability, browser storage, generated APIs, testing boundaries and fallback options.

Read Guide
Sqldelight Query Patterns That Stay Maintainable feature image
Queries

Sqldelight Query Patterns That Stay Maintainable

Write maintainable Sqldelight query files with clear labels, focused projections, safe parameters, transactions, pagination and result models.

Read Guide
SQLDelight Testing for Queries and Migrations feature image
Testing

SQLDelight Testing for Queries and Migrations

Create a practical SQLDelight testing plan for generated queries, adapters, transactions, schema creation, migrations and platform drivers.

Read Guide
SQLDelight Boolean Mapping With Column Adapters feature image
Adapters

SQLDelight Boolean Mapping With Column Adapters

Learn how SQLDelight Boolean values can be stored in SQLite, mapped with a ColumnAdapter, tested for round trips and migrated safely.

Read Guide
Sqldelight Migration Setup and Review Checklist feature image
Migrations

Sqldelight Migration Setup and Review Checklist

Plan Sqldelight migrations with ordered .sqm files, schema snapshots, upgrade tests, data transformations and a production review checklist.

Read Guide
Common Sqldelight Errors and Practical Fixes feature image
Troubleshooting

Common Sqldelight Errors and Practical Fixes

Fix common Sqldelight errors involving Gradle versions, source folders, SQL compilation, missing drivers, adapters, migrations and stale generated code.

Read Guide
Sqldelight Performance Settings and Query Tuning feature image
Performance

Sqldelight Performance Settings and Query Tuning

Improve Sqldelight performance with focused queries, indexes, transactions, batching, listener control, pagination and platform-aware testing.

Read Guide