logoalt Hacker News

flosslytoday at 9:23 AM0 repliesview on HN

JDBC does not allow pipelining (a Postgres only feature).

It can reduce the number of db round-trips a lot, especially when using Supabase+RLS (or other systems that require frequent setting of configuration values that are basically fire-and-forget).

Meet Bpdbi, a library with first-class pipelining, which provides a Postgres db driver (that's binary only, as the legacy text-based protocol is no longer needed, it just takes up space) and exposes an API that's more close to Jdbi's that to JDBC's (developer friendly).

https://github.com/bpdbi

It has an extensive benchmark that shows it's on par or faster compared to other db connectivity stacks.