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.

主要功能

01Advanced PostgreSQL support for JSONB and array operations

02Standardized repository structures for CRUD operations

03Complex query templates for joins, filtering, and pagination

04Atomic transaction handling and batch processing logic

05Type-safe record-to-entity mapping patterns

061 GitHub stars

使用场景

01Architecting a clean data access layer in Kotlin or Java applications

02Implementing dynamic search filters and paginated API endpoints

03Integrating advanced PostgreSQL features into a type-safe application environment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ashchupliak/dream-team jooq-patterns

For use in Claude.ai and ChatGPT

Download Skill