Manage Postgres JDBC in Kotlin with Migrator, DAO, and transactions.
npx skills add https://github.com/navikt/helved-utbetaling --skill database-navikt
Please help me install this Agent Skill. Skill: database Source: https://github.com/navikt/helved-utbetaling/tree/main/.agents/skills/database Command: npx skills add https://github.com/navikt/helved-utbetaling --skill database-navikt
Solves the complexity of JDBC usage in Kotlin by providing Migrator, Dao<T>, and transactional utilities.
Define your data models and companion object DAOs, initialize the JDBC at startup, and run DB tasks inside transaction blocks using the provided jdbcCtx.
High-intent search queries and answers about installing and using this skill.
Kotlin JDBC transaction scoping is managed using transaction { } blocks to ensure atomic multi-statement operations and safe rollback on failure. A CoroutineDatasource carries the DataSource through the coroutine context to enable per-app DB access.
Type-safe database queries without an ORM are achieved by implementing a companion object : Dao<T> on row types. This DAO pattern enables type-safe queries and updates directly via JDBC, avoiding the overhead of full object-relational mapping frameworks.
Versioned SQL migrations are executed using a custom Migrator that manages SQL files under main/migrations. You structure your files as V<n>__<description>.sql, and the Migrator workflow applies them to the Postgres database.
Yes, this JDBC pattern targets Kotlin services managing Postgres data with coroutine-bound contexts. It is explicitly designed for modules that require robust data access, transaction scoping, and per-context JDBC datasource initialization.
JDBC datasource initialization at startup is performed using Jdbc.initialize and .context() methods. This wiring obtains a jdbcCtx for service layers, establishing the database connection required for subsequent DAO queries and transactional work.
mitul-bhatiaArchitect Kotlin database access using Exposed ORM patterns.
RUSHYOPStandardizes Kotlin Exposed DSL and DAO usage for safe database access.
prismaGenerate, validate, and execute Prisma Next migration packages for Postgres and MongoDB.
vuralserhat86Facilitate type-safe ORM for Cloudflare D1 databases with Drizzle.
