SQL, JSON, and Java

As multi-model databases like Oracle, Postgres, and MySQL gain traction for document storage, they're starting to outpace dedicated NoSQL solutions like MongoDB in both performance and versatility. Traditional relational databases now offer support for binary JSON encodings and SQL to provide scalable, low-latency access to JSON data. This video covers: • Trade-offs between storing objects using JSON and a relational model • ISO standard SQL for querying JSON • Using binary JSON encodings to support low-latency, queryable storage of Java objects with JDBC • Integrations with Jackson Databind and Jakarta JSON to avoid string parsing and serialization • How new Java 21 features like record patterns complement schema-less, JSON storage Presented by Josh Spiegel - Software Architect (Database Group - Oracle) at JavaOne 2025 (CA, March 2025). All JavaOne 2025 talks ➤ https://www.youtube.com/playlist?list=PLX8CzqL3ArzVV1xRJkRbcM2tOgVwytJAi ➤ https://github.com/oracle/json-in-db/tree/master/JdbcExamples Tags: #Java #JSON #SQL #JavaOne SES1638