Database Technology

A new PostgreSQL-first JDBC driver has been released in pre-release, built from the ground up by Sehrope Sarkini. The architecture prioritizes the database wire protocol over legacy JDBC constraints, treating JDBC as an adapter layer rather than the core foundation. Full compliance is a long-term objective, but the immediate focus is on exposing native capabilities directly.

• Native API is designed around PostgreSQL wire protocol, not lowest common denominator
• JDBC layer sits on top of native API to preserve execution performance
• Full JDBC compliance remains a long-term goal rather than immediate requirement
• Current release includes standard java.sql.* interfaces like Connection and ResultSet

PostgreSQL 18.6 is now available as a maintenance release for the 18 series. The release includes bug fixes and stability improvements for the current major version. No specific feature changes or performance enhancements are detailed in the source material.

• PostgreSQL 18.6 is a standard maintenance release for v18.
• Focuses on stability and bug fixes rather than new features.
• No specific changelog details provided in the source excerpt.

The PostgreSQL community has published the third beta release for version 19. This build continues the iterative refinement process leading up to the stable release, allowing users to validate compatibility and performance characteristics. As a pre-release candidate, it is intended for evaluation rather than production deployment.

• Available now for testing in non-production environments
• Focus is on stability and bug fixing before final release
• Verify application compatibility with current beta changes
• Monitor for regressions in critical query paths

PostgreSQL has released version 17.11 as a maintenance update for the 17 series. This release addresses security vulnerabilities and includes general bug fixes to improve stability. It is the recommended update for all users running PostgreSQL 17 to ensure their databases remain secure and reliable.

• Upgrade to 17.11 to patch known security vulnerabilities in the 17 series.
• Apply this maintenance release to improve overall database stability and performance.
• Verify extension compatibility before upgrading in production environments.
• Review the official release notes for specific bug fixes and changes.

PostgreSQL 16.15 is now available as a maintenance release for the 16 series. The 16 branch remains the current Long Term Support version, making this update critical for stability and security compliance. Specific change details are not provided in the source excerpt, but standard maintenance releases typically include bug fixes and security patches.

• Maintains support status for the active LTS branch
• Apply promptly to address latent security vulnerabilities
• Standard regression test suite should be run post-upgrade
• No major feature changes expected in maintenance releases
• Coordinate with cloud providers if using managed services

Amazon RDS for MariaDB now supports the 12.3.2 minor version of MariaDB 12.3, the latest Long-Term Support release. Key features include Oracle TO_DATE() function compatibility to ease migration, native IS JSON predicate validation, and optimizer improvements for LEFT JOINs and range partition scans.

• MariaDB 12.3 is the current LTS release, now available on RDS.
• Oracle TO_DATE() compatibility reduces refactoring effort for migrations.
• Native IS JSON predicate enables in-database document validation.
• Query optimizer handles reorderable LEFT JOINs and range scans more efficiently.
• Upgrade via Blue/Green deployment to minimize downtime.

Fleet impact: For RDS MariaDB fleets, this LTS release offers native JSON validation and Oracle syntax compatibility, simplifying migrations and reducing application-layer overhead. Plan Blue/Green upgrades to leverage the improved query optimizer for LEFT JOINs and range partition scans without code changes.