Introducing Foundations JDBC: Type-Safe Database Access for the JVM
· 9 min read
What if your JDBC library actually knew what your database types were?
Not Object. Not getInt() with a column index and a prayer. Real types — int4range, jsonb, STRUCT, LIST<MAP<VARCHAR, INTEGER>>, GEOGRAPHY — modeled exactly as the database defines them, with full roundtrip fidelity.
That's what we built. Foundations JDBC is an open-source, MIT-licensed JDBC library for Java, Kotlin, and Scala. It gives you composable SQL fragments, typed row codecs, and test-time query verification — across PostgreSQL, MariaDB, DuckDB, Oracle, SQL Server, and DB2.
Today we're releasing 1.0.0-RC3.