跳到正文
cccskills
免费在 GitHub 公开

spring-boot-data-access

Optimize JPA, Hibernate, and database interactions in Spring Boot. Use when implementing JPA entities, repositories, or database access in Spring Boot.

中文简介正在准备中。当前显示原文说明。

实测评分 未实测

查看安装方法

包含的文件(3)

  • SKILL.md2.1 KB
  • evals/evals.json2.3 KB
  • references/implementation.md1.7 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Spring Boot Data Access

Priority: P0 (CRITICAL)

Configure JPA and Spring Data

  • Read-Only: Default to @Transactional(readOnly = true) on Services to optimize DB resources.
  • Projections: Use Java Records for Read-Only query results. Avoid fetching full @Entity objects when not necessary.
  • Pagination: ALWAYS use Pageable and Slice (or Page) to prevent loading massive datasets.
  • Spring Data: Prefer JpaRepository and Query methods. Use @Query with JPQL for complex logic. Use Flyway or Liquibase for migrations; never use ddl-auto=create in production.

See implementation examples for repository projections, EntityGraph, and transactional patterns.

Optimize Queries and Transactions

  • N+1 Problem: Fix N+1 selects using JOIN FETCH (JPQL) or @EntityGraph.
  • Open-In-View: Set spring.jpa.open-in-view=false in application.yaml.
  • Bulk Operations: Use @Modifying with @Query for updates/deletes to bypass EntityManager overhead.
  • Connection Pool: Configure HikariCP with explicit maximum-pool-size. Tune Hikari pool-size based on expected concurrent queries.

Anti-Patterns

  • No N+1 Selects: Use JOIN FETCH or @EntityGraph instead of lazy-loading in loops.
  • Entity Inflation: Don't use @Data (Lombok) on Entities as it breaks Proxy and hashCode/equals performance.
  • Transactional Leak: Don't put @Transactional on public Repository methods if Service already transactional.
  • Raw SQL: Avoid native SQL unless JPQL/Criteria API insufficient.

References

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Upgrade an Android project to Android Gradle Plugin (AGP) 9. Use when migrating to AGP 9, updating Gradle build files, migrating to built-in Kotlin, or adopting the new AGP DSL.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

Apply Clean Architecture layering, modularization, and Unidirectional Data Flow in Android projects. Use when setting up project structure, placing code in layers, configuring feature/core modules, or implementing UDF patterns; defer Compose state and ViewModel/StateFlow implementation to their specific skills.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

Implement WorkManager and background processing correctly on Android. Use when creating Worker classes, scheduling tasks, choosing between WorkManager and Foreground Services, or setting up Hilt in workers; defer FCM and notification delivery to android-notifications.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

Build high-performance declarative UI with Jetpack Compose. Use when writing Composable functions, optimizing recomposition, hoisting state, or working with LazyColumn and side effects; defer deep-link and navigation routing to android-navigation.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

Migrate an Android XML View to Jetpack Compose following a structured 10-step workflow. Use when converting XML layouts to Compose, setting up Compose in an existing View-based project, or incrementally adopting Compose.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

Write correct coroutine scopes, lifecycle collection, and dispatcher injection in Android production code. Use for suspend functions, coroutine scopes, and dispatcher mechanics; defer ViewModel StateFlow/LiveData architecture, Fragment lifecycle recipes, persistence/notifications, and unit-test recipes to their specific skills.

中文简介正在准备中。当前显示原文说明。

HoangNguyen0403/agent-skills-standard5812026年10月22日 更新

查看 HoangNguyen0403 的全部技能

报告此技能的问题