412-frameworks-quarkus-panache

What problem does it solve?

This Skill enhances Quarkus applications by simplifying and optimizing data access using Hibernate ORM with Panache patterns, improving efficiency and maintainability.

Core Features & Use Cases

• Hibernate ORM with Panache: Simplifies database interactions with active record and repository patterns.
• Active Record vs Repository: Offers guidance on choosing between active record and repository for different scenarios.
• Parameterized Queries: Securely performs JPQL queries with positional and named parameters.
• Named Queries: Utilizes named queries for validated, reusable queries.
• DTO Projections: Enables selective data fetching with project(Class).
• Pagination: Implements efficient pagination for data retrieval.
• N+1 Query Avoidance: Uses JOIN FETCH to prevent N+1 query problems.
• Optimistic Locking: Implements optimistic locking for concurrency control.
• Transactions and Testing: Provides guidance on transactions and testing with Panache.

Quick Start

Run the 412-frameworks-quarkus-panache skill to apply Panache patterns to your Quarkus application and enhance your Hibernate ORM data access.