PostgreSQL
Use JdbcTemplate, method annotations, Mapper files, or the Builder API with PostgreSQL. The following pages cover database-specific configuration and usage.
| Scenario | Usage |
|---|---|
| Key generation | IDENTITY, SERIAL, and sequences |
| Pagination | LIMIT / OFFSET |
| Insert conflicts | ON CONFLICT |
| Data backfill | Return written fields with RETURNING |
| Vector operations | pgvector field mapping, distance thresholds, and indexes |
- Mapper API: annotations, Mapper reads and writes, and execution differences.
- Builder API: Supported operations, datasource-specific behavior, and usage.
- Pagination: Page queries and total counts.
- Insert Conflicts: Handle existing records during insertion.
- Vector Operations: Configure vector fields, distance thresholds, and search indexes.
- Key Generation: Configure and retrieve IDs.
- Data Backfill: Read values returned by a write.
- Type Support: Choose Java property types.
- Transaction Support: Roll back multiple writes on failure.