Is pagination supported in these patterns?

Yes, it includes templates for dynamic filtering combined with offset-based pagination and total count retrieval for building efficient list views.

Does this skill support PostgreSQL-specific features?

Yes, it includes specific patterns for advanced PostgreSQL features like JSONB column manipulation, array operations, and ON CONFLICT (upsert) clauses.

How does it handle database transactions?

The skill provides patterns for explicit transaction control using dsl.transactionResult, ensuring multiple database operations can be executed atomically within the same context.

jOOQ is a library that generates Java or Kotlin code from your database schema, allowing you to build type-safe SQL queries through a fluent DSL rather than using string-based queries.

jOOQ Database Patterns

Name: jOOQ Database Patterns
Author: ashchupliak

byashchupliak

•

数据库管理

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

关于

The jOOQ Database Patterns skill provides a comprehensive collection of implementation templates for developers using the jOOQ SQL library. It focuses on creating type-safe repositories, mapping database records to domain entities, and executing complex SQL operations such as multi-table joins, aggregations, and batch processing. This skill is particularly useful for building data-heavy backend services that require the power of raw SQL with the safety of a typed DSL, including advanced support for PostgreSQL-specific features like JSONB and array types.

主要功能

Advanced PostgreSQL support for JSONB and array operations
Standardized repository structures for CRUD operations
Complex query templates for joins, filtering, and pagination
Atomic transaction handling and batch processing logic
Type-safe record-to-entity mapping patterns
1 GitHub stars

使用场景

Architecting a clean data access layer in Kotlin or Java applications
Implementing dynamic search filters and paginated API endpoints
Integrating advanced PostgreSQL features into a type-safe application environment

关于

主要功能

Advanced PostgreSQL support for JSONB and array operations
Standardized repository structures for CRUD operations
Complex query templates for joins, filtering, and pagination
Atomic transaction handling and batch processing logic
Type-safe record-to-entity mapping patterns
1 GitHub stars

使用场景

Architecting a clean data access layer in Kotlin or Java applications
Implementing dynamic search filters and paginated API endpoints
Integrating advanced PostgreSQL features into a type-safe application environment