Java Jdbc

Open-source Java projects categorized as Jdbc

Top 23 Java Jdbc Projects

  1. HikariCP

    光 HikariCP・A solid, high-performance, JDBC connection pool at last.

    Project mention: A Major Postgres Upgrade with Zero Downtime | news.ycombinator.com | 2025-01-29

    > 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

  2. 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.

    InfluxDB logo
  3. Trino

    Official repository of Trino, the distributed SQL query engine for big data, former

    Project mention: Every Database Will Support Iceberg — Here's Why | dev.to | 2025-04-22

    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.

  4. jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Streaming data from RDBMS with jooq | dev.to | 2025-02-23

    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!

  5. Hibernate

    Hibernate's core Object/Relational Mapping functionality

    Project mention: How To Secure APIs from SQL Injection Vulnerabilities | dev.to | 2025-03-19

    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.

  6. H2

    H2 is an embeddable RDBMS written in Java.

  7. linkis

    Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.

  8. requery

    requery - modern SQL based query & persistence for Java / Kotlin / Android

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  10. sqlite-jdbc

    SQLite JDBC Driver

    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.

  11. Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Effortless Database Subsetting with Jailer: A Must-Have Tool for QA and DevOps | news.ycombinator.com | 2025-05-13
  12. p6spy

    P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.

  13. 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-11

    Suppose 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):

  14. examples

    Apache Kafka, Apache Flink and Confluent Platform examples and demos (by confluentinc)

  15. Apache Drill

    Apache Drill is a distributed MPP query layer for self describing data (by apache)

  16. sqli

    orm sql query builder, API: QB, QB.X, QrB

  17. SchemaCrawler

    Free database schema discovery and comprehension tool

    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).

  18. pgjdbc

    Postgresql JDBC Driver

    Project mention: Migration Oracle -> PostgreSQL : il n’y a que le driver à changer ! Non ? | dev.to | 2025-05-07
  19. clickhouse-java

    ClickHouse Java Clients & JDBC Driver

  20. Ebean ORM

    Ebean ORM

  21. db-scheduler

    Persistent cluster-friendly scheduler for Java

  22. c3p0

    a mature, highly concurrent JDBC Connection pooling library, with support for caching and reuse of PreparedStatements.

    Project mention: Configuring a Connection Pool | dev.to | 2024-09-18

    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).

  23. jimmer

    The most advanced ORM of JVM, for both java & kotlin

  24. spring-boot-data-source-decorator

    Spring Boot integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth

  25. spring-data-relational

    Spring Data Relational. Home of Spring Data JDBC and Spring Data R2DBC.

  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Java Jdbc discussion

Log in or Post with

Java Jdbc related posts

  • Migration Oracle -> PostgreSQL : il n’y a que le driver à changer ! Non ?

    2 projects | dev.to | 7 May 2025
  • Every Database Will Support Iceberg — Here's Why

    10 projects | dev.to | 22 Apr 2025
  • JOOQ Is Not a Replacement for Hibernate. They Solve Different Problems

    1 project | dev.to | 11 Jan 2025
  • O que é o hikari pool?

    2 projects | dev.to | 6 Jan 2025
  • pg-index-health – a static analysis tool for you PostgreSQL database

    7 projects | dev.to | 6 Jan 2025
  • Java JDBC + IntelliJ + SQLite - A Beginner's Walkthrough

    1 project | dev.to | 16 Dec 2024
  • Optimize Database Performance in Ruby on Rails and ActiveRecord

    2 projects | news.ycombinator.com | 9 Nov 2024
  • A note from our sponsor - SaaSHub
    www.saashub.com | 16 Jun 2025
    SaaSHub helps you find the best software and product alternatives Learn more →

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

Sponsored
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.
www.influxdata.com

Did you know that Java is
the 8th most popular programming language
based on number of references?