Table index annotation

Identity generation strategy

Auditing listener

Audit timestamp fields

EnableJpaAuditing config

Enum stored as string

Non-null column constraints

OneToMany cascade and orphan

Collection initialized

Lazy loading default

JOIN FETCH query

No EAGER on collection

Projection for reads

JpaRepository extension

Interface projection

Pageable parameter

PageRequest sort

JPQL @Query

@Param binding

Cursor pagination query

Service @Transactional

readOnly = true for reads

No EAGER collection fetch

Avoid select *

HikariCP maximum-pool-size

HikariCP minimum-idle

HikariCP connection-timeout

HikariCP validation-timeout

Batch size property

saveAll for bulk insert

Flyway or Liquibase migration

No Hibernate auto DDL

@DataJpaTest annotation

Testcontainers usage

SQL debug logging

Bind parameter trace logging