Skip to main content

Supported Databases

Each database has its own type hierarchy that knows exactly how to read and write values. Full roundtrip fidelity for every type — read a value from the database and write it back without loss or corruption.

Databases​

  • PostgreSQL — arrays, ranges, geometric types, network types, JSON, text search, and all the exotic ones
  • MariaDB / MySQL — unsigned integers, spatial types, sets, JSON, and year types
  • DuckDB — lists, structs, maps, unions, enums, and 128-bit integers
  • Oracle — OBJECT types, nested tables, VARRAYs, intervals, and LOB types
  • SQL Server — geography, geometry, hierarchyid, and Unicode types
  • DB2 — standard SQL types with DB2-specific handling

Type-Safe Database Types​

Each database has its own typed hierarchy:

// PostgreSQL types
PgType<int[]> intArray = PgTypes.int4.array();
PgType<Range<LocalDate>> dateRange = PgTypes.daterange;
PgType<PGpoint> point = PgTypes.point;

// MariaDB types
MariaType<JsonNode> json = MariaTypes.json(mapper);

// Oracle types
OracleType<List<MyObject>> nested = OracleTypes.nestedTable("MY_TYPE", myObjectType);

// DuckDB types
DuckDbType<Map<String, Integer>> map = DuckDbTypes.map(DuckDbTypes.varchar, DuckDbTypes.integer);