SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Java Jdbc Projects
-
> are they using a connection pooler
We use Hikari [1] an in-process connection pooler. We didn't opt for pgbouncer at al, because we didn't want to add the extra infra yet.
> since what they did in code can be natively done with PgBouncer, PgCat, et al.
Can you point me to a reference I could look at, about doing a major version upgrade with PgBouncer et al? My understanding that we would still need to write a script to switch masters, similar to what we wrote.
> all the active connections
The active connections we were referring too were websocket connections, we haven't had problems with PG connections.
Right now the algorithm we use to find affected queries and notify websockets starts to falter when the number of active websocket connections get too high. We're working on improving it in the coming weeks. I'll update the essay to clarify.
> I did feel for them here:
Thank you! That part was definitely the most frustrating.
[1] https://github.com/brettwooldridge/HikariCP
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
Traditional databases — PostgreSQL, MySQL, etc. — store their data in proprietary formats. That format is optimized for that engine and can’t be directly accessed by anything else. Even if something like Trino can connect to Postgres, it’s still running queries through Postgres itself, not reading its storage directly. You’re just a client.
-
Relational databases provide components such as cursors, which can be used to process large datasets while fetching only a limited number of rows at a time. With the help of jooq framework,we can take it a step further—leveraging cursors under the hood while seamlessly integrating with Java's Stream API. Let’s see it in action!
-
Object-Relational Mapping frameworks like Hibernate (Java), SQLAlchemy (Python), and Sequelize (Node.js) typically use parameterized queries by default and abstract direct SQL interaction. These frameworks help eliminate common developer errors that might otherwise introduce vulnerabilities.
-
-
linkis
Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Project mention: A year of uv: pros, cons, and should you migrate | news.ycombinator.com | 2025-02-18
Cross-platform Java apps do it to. For e.g., see https://github.com/xerial/sqlite-jdbc. But it does not become a clusterfuck like it does with python. After downloading gigabytes and gigabytes of dependencies repeatedly, the python tool you are trying to run will refuse to do so for random reasons.
You cannot serve end users a shit-sandwich of this kind.
The python ecosystem is a big mess and, outside of a few projects like uv, I don't see anyone trying to build a sensible solution that handles both speed/performance and packaging/distribution.
-
Project mention: Effortless Database Subsetting with Jailer: A Must-Have Tool for QA and DevOps | news.ycombinator.com | 2025-05-13
-
p6spy
P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.
-
JDBI
The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
Project mention: JOOQ Is Not a Replacement for Hibernate. They Solve Different Problems | dev.to | 2025-01-11Suppose we're developing an application that allows speakers to submit their talks to a conference (for simplicity, we'll only record the talk's title). Following the Transaction Script pattern, the method for submitting a talk might look like this (using JDBI for SQL):
-
-
-
-
Project mention: pg-index-health – a static analysis tool for you PostgreSQL database | dev.to | 2025-01-06
PostgreSQL (like many other relational databases) stores metadata about all objects and relationships between them and provides it externally in the form of information_schema. We can use queries to information_schema to identify any deviations, problems, or common errors (this is exactly what SchemaCrawler does).
-
Project mention: Migration Oracle -> PostgreSQL : il n’y a que le driver à changer ! Non ? | dev.to | 2025-05-07
-
-
-
-
c3p0
a mature, highly concurrent JDBC Connection pooling library, with support for caching and reuse of PreparedStatements.
Putting the connection pool in the application (application-side connection pooler) can be very easy as many ORMs or database drivers support that out of the box. For instance, JDBC supports that with c3p0 and ODBC supports that out of the box. This brings many benefits. We don’t need to install and maintain any additional components as the pooler lives inside the application. We only need to deploy the new version of the application and we get the pooling ready. This also reduces the network latency, as we don’t have any additional network hops (everything lives inside our application).
-
-
spring-boot-data-source-decorator
Spring Boot integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Java Jdbc discussion
Java Jdbc related posts
-
Migration Oracle -> PostgreSQL : il n’y a que le driver à changer ! Non ?
-
Every Database Will Support Iceberg — Here's Why
-
JOOQ Is Not a Replacement for Hibernate. They Solve Different Problems
-
O que é o hikari pool?
-
pg-index-health – a static analysis tool for you PostgreSQL database
-
Java JDBC + IntelliJ + SQLite - A Beginner's Walkthrough
-
Optimize Database Performance in Ruby on Rails and ActiveRecord
-
A note from our sponsor - SaaSHub
www.saashub.com | 16 Jun 2025
Index
What are some of the best open-source Jdbc projects in Java? This list will help you:
# | Project | Stars |
---|---|---|
1 | HikariCP | 20,484 |
2 | Trino | 11,438 |
3 | jOOQ | 6,421 |
4 | Hibernate | 6,173 |
5 | H2 | 4,376 |
6 | linkis | 3,373 |
7 | requery | 3,130 |
8 | sqlite-jdbc | 3,041 |
9 | Jailer | 3,005 |
10 | p6spy | 2,144 |
11 | JDBI | 2,052 |
12 | examples | 1,979 |
13 | Apache Drill | 1,975 |
14 | sqli | 1,893 |
15 | SchemaCrawler | 1,703 |
16 | pgjdbc | 1,592 |
17 | clickhouse-java | 1,544 |
18 | Ebean ORM | 1,494 |
19 | db-scheduler | 1,387 |
20 | c3p0 | 1,302 |
21 | jimmer | 1,256 |
22 | spring-boot-data-source-decorator | 948 |
23 | spring-data-relational | 796 |