3 ms·
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 system
by flossly 6mo ago
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 https://github.com/bpdbi
It has an extensive benchmark that shows it's on par or faster compared to other db connectivity stacks.