Nov 1, 2023 · Backend Development

Evolution of the Rainbow Bridge Architecture: From BIO to NIO with Custom Database Driver and Connection Pool

The article chronicles the Rainbow Bridge proxy’s shift from a blocking BIO JDBC driver to a custom Netty‑based NIO driver with an event‑loop‑affine connection pool, detailing optimizations such as codec skipping and lock‑free queues that yield up to 67% higher throughput, 37% lower load, and a 98% reduction in thread usage.

AsynchronousConnection PoolDatabase Driver

0 likes · 11 min read

Evolution of the Rainbow Bridge Architecture: From BIO to NIO with Custom Database Driver and Connection Pool

Laravel Tech Community

Jun 15, 2021 · Databases

PostgreSQL JDBC Driver 42.2.21 Release Highlights

The PostgreSQL JDBC Driver (PgJDBC) version 42.2.21 introduces documentation updates for the deprecated DataSource API, ensures primary keys for updatable result sets, adds asynchronous notification handling, rewrites the OSGi bundle activator, and fixes metadata retrieval when search_path is not specified.

Database DriverJDBCPGJDBC

0 likes · 2 min read

PostgreSQL JDBC Driver 42.2.21 Release Highlights