This documentation is currently available in Portuguese. English and other languages are on the way.
Cookbook
Recipes · Data
SQLite in practice: opening the database, CRUD with parameters, transactions and heavy work off the paint thread.
How-to🟢
How to open or create a SQLite database
Open/create a .db file with try-with-resources, use an in-memory database, and create tables.
How-to🟡
How to access the database outside the paint thread
Run SQLite queries on a worker thread and return to the UI with Component.onUI.
How-to🔴
How to write in bulk with a transaction and bulkInsert
Insert thousands of rows fast — transaction, a reused statement with reset(), or native bulkInsert.
How-to🟢
How to do parameterized CRUD in SQLite
Insert, read, update, and delete with positional parameters and a cursor, without concatenating SQL.
How-to🔴
How to use an encrypted SQLite database
Open with a key, choose the cipher, change/remove the key, and detect a wrong key.