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. Learn more →
Top 23 Java Database Projects
-
-
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.
-
Chat2DB
🔥🔥🔥AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
Project mention: Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles | dev.to | 2025-05-06Go to Chat2DB website 🙋 Join the Chat2DB Community 🐦 Follow us on X 📝 Find us on Discord
-
> 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
-
shardingsphere
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Project mention: Apache ShardingSphere: Effortless Database Scaling and Beyond! | dev.to | 2025-02-21View the Project on GitHub
-
Project mention: Data Warehouses and Data Lakes: Understanding Modern Data Storage Paradigms 📦 | dev.to | 2025-04-25
Follow Presto at Official Website, Linkedin, Youtube, and Slack channel to join the community.
-
Project mention: QuestDB is an open source time-series database for fast ingest and SQL queries | news.ycombinator.com | 2024-08-31
-
Project mention: 6 retrieval augmented generation (RAG) techniques you should know | dev.to | 2025-04-25
The key difference lies in the retrieval mechanism. Vector databases focus on semantic similarity by comparing numerical embeddings, while graph databases emphasize relations between entities. Two solutions for graph databases are Neptune from Amazon and Neo4j. In a case where you need a solution that can accommodate both vector and graph, Weaviate fits the bill.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Project mention: Apache Doris: open-source data warehouse for real time data analytics | news.ycombinator.com | 2024-10-26
-
Zookeeper is a distributed coordination service used in older versions of Kafka to manage cluster metadata, leader election, and configuration. It ensures consistency and synchronization across Kafka brokers.
-
As we mentioned earlier, we conducted a prototype test that revealed the limit of 30k msg/s throughput when using PostgreSQL for persistence message storage. At the moment we migrated to Redis, we already used the Jedis library for Redis interactions, primarily for cache management, and extended it to handle message persistence for persistent MQTT clients. However, the initial results of the Redis implementation with Jedis were unexpected. While we anticipated Redis would significantly outperform PostgreSQL, the performance improvement was modest — reaching only 40k msg/s throughput compared to the 30k msg/s limit with PostgreSQL.
-
-
debezium
Change data capture for a variety of databases. Please log issues at https://issues.redhat.com/browse/DBZ.
Project mention: Streaming Postgres Changes with Debezium and Kafka Connect: A Hands-On Tutorial | dev.to | 2025-05-05Debezium
-
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.
-
starrocks
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
-
Project mention: Twitter's 600-Tweet Daily Limit Crisis: Soaring GCP Costs and the Open Source Fix Elon Musk Ignored | dev.to | 2025-04-10
Cassandra: Cassandra is a highly scalable and fault-tolerant NoSQL database. It is designed to handle large amounts of data across multiple commodity servers, making it suitable for high-availability and data-intensive applications.
-
Project mention: Ne jouez plus tout l'historique de vos migrations Flyway grâce au baseline ! | dev.to | 2025-01-09
-
Android Debug Database
A library for debugging android databases and shared preferences - Make Debugging Great Again
-
-
-
Zeppelin
Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.
To do so, we will use Kinesis Data Analytics to run an Apache Flink application. To enhance our development experience, we will use Studio notebooks for Kinesis Data Analytics that are powered by Apache Zeppelin.
-
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!
-
hertzbeat
Apache HertzBeat(incubating) is a real-time monitoring system with agentless, performance cluster, prometheus-compatible, custom monitoring and status page building capabilities.
Project mention: Ask HN: How to do dead simple heartbeat monitoring? | news.ycombinator.com | 2024-05-06Maybe can try use opensource project apache hertzbeat to monitoring heartbeat. https://github.com/apache/hertzbeat
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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 Database discussion
Java Database related posts
-
A programming language coding in a grid
-
What else can Stream&Kotlin evolve into？
-
6 retrieval augmented generation (RAG) techniques you should know
-
Data Warehouses and Data Lakes: Understanding Modern Data Storage Paradigms 📦
-
Introduction to Presto: Open Source SQL Query Engine that's changing Big Data Analytics
-
Why You Shouldn’t Invest In Vector Databases?
-
How to Dump Database Tables into Files to Speed Up Queries with EsProc
-
A note from our sponsor - InfluxDB
www.influxdata.com | 12 May 2025
Index
What are some of the best open-source Database projects in Java? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | dbeaver | 43,451 |
| 2 | Chat2DB | 22,742 |
| 3 | HikariCP | 20,430 |
| 4 | shardingsphere | 20,221 |
| 5 | Presto | 16,325 |
| 6 | QuestDB | 15,153 |
| 7 | Neo4j | 14,277 |
| 8 | doris | 13,640 |
| 9 | Apache ZooKeeper | 12,465 |
| 10 | Jedis | 12,041 |
| 11 | Realm | 11,484 |
| 12 | debezium | 11,354 |
| 13 | Trino | 11,241 |
| 14 | starrocks | 9,960 |
| 15 | Apache Cassandra | 9,181 |
| 16 | Flyway | 8,729 |
| 17 | Android Debug Database | 8,493 |
| 18 | shardingsphere-elasticjob | 8,183 |
| 19 | Leaf | 6,574 |
| 20 | Zeppelin | 6,480 |
| 21 | jOOQ | 6,374 |
| 22 | hertzbeat | 6,241 |
| 23 | Hibernate | 6,145 |
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