Kotlin Exposed Patterns

Comprehensive patterns for database access with JetBrains Exposed ORM.

When to Use

• Setting up database access with Exposed
• Writing SQL queries using Exposed DSL or DAO
• Configuring connection pooling with HikariCP
• Creating database migrations with Flyway
• Implementing the repository pattern with Exposed

How It Works

Exposed provides two query styles: DSL for direct SQL-like expressions and DAO for entity lifecycle management. All database operations run inside newSuspendedTransaction blocks for coroutine safety and atomicity.

DSL Query