Topic 14. Working with relational databases using the Exposed library

Goal: learn to describe an SQLite schema, run DSL queries, build reports, and verify the atomicity of transactions.

Lecture contents

1. The database and connection — From a collection to a database · Preparing the project and connecting
2. Tables and DSL queries — Describing a table and its constraints · DSL: create, read, update, and delete
3. Relationships and joins — Relationships and joins
4. DAO and transactions — DAO: a row as an object · A transaction as an integrity boundary
5. Repository, migrations, and tests — The repository and coroutines · Migrations, protection, and tests

Practice and review

• Practice — 3 worked examples with complete code
• Tasks — 30 variants, each with tasks at three difficulty levels
• Summary — conclusions and self-check questions