Database & Storage in Compose Desktop: Exposed ORM & SQLite | Kotlin Desktop #9

Описание: Build a Contact Manager with Compose Desktop! Learn the Exposed ORM with SQLite for local persistence, CRUD operations wrapped in
transactions, search with SQL LIKE queries, Scaffold with FloatingActionButton, and reusable dialog forms — all in about 130 lines of Kotlin
with no external API needed.

What You'll Learn:
Exposed IntIdTable for schema definition with typed columns
Database.connect() with SQLite JDBC driver
SchemaUtils.create() for automatic table creation
Transaction blocks wrapping all database operations
CRUD: selectAll, insert, update, deleteWhere
Search with SQL LIKE queries
Scaffold with FloatingActionButton for material layout
LazyColumn for efficient scrollable lists
AlertDialog with OutlinedTextField for data entry forms
State refresh pattern: re-query after mutations

Timestamps:
0:00 - Introduction
0:15 - Preview: What We're Building
0:45 - Project Setup (Gradle, Exposed Dependencies)
2:25 - Database Schema (IntIdTable, initDatabase)
3:24 - Contact Repository (CRUD Operations)
5:22 - App Content (Scaffold, Search, Dialogs)
9:59 - Main & Compile
11:41 - App Demo (Add, Search, Edit, Delete)
12:56 - Recap & Key Takeaways
13:56 - Thanks for Watching

Key Takeaways:
1. Table Definition — Exposed IntIdTable defines schema with typed columns
2. Connect — Database.connect() with SQLite JDBC driver string
3. Repository — Transaction blocks wrap all CRUD operations
4. State Refresh — Re-query after mutations to keep UI in sync
5. Dialogs — AlertDialog with OutlinedTextField for data entry

Previous Lesson:
Lesson 08: HTTP & APIs
   / .  .

Next Lesson:
Lesson 10: Drag & Drop (coming soon)

Tech Stack:
Kotlin 2.1, Compose Multiplatform 1.7.3, Material3
Exposed ORM 0.56.0, SQLite JDBC 3.47.1.0
Gradle 8.10, JVM 17+

Source Code: https://github.com/GoCelesteAI/kotlin...

Taught by CelesteAI

If you found this helpful, please like and subscribe for more Kotlin Desktop tutorials!

#kotlin #compose #desktop #material3 #exposed #sqlite #database #crud #orm #storage #tutorial #programming

Tags

kotlin, compose multiplatform, compose desktop, material3, exposed orm, sqlite, database, crud operations, contact manager, transaction,
jetbrains exposed, dialogs, lazy column, scaffold, floating action button, kotlin tutorial, desktop app, jvm, jetbrains compose, composable

Category

Science & Technology