SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Java Database Projects
-
Project mention: CLI to manage your SQL database schemas and migrations | news.ycombinator.com | 2025-11-01
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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.
-
This caught two N+1 queries and a missing `connection.close()` in a rarely-hit endpoint — exactly the kind of bugs that sleep until traffic spikes wake them up. ## Gotchas - **maxLifetime = server timeout** is a race condition, not a match. Always go 30+ seconds shorter. - **PgBouncer transaction mode breaks prepared statements silently.** You will only see errors under load, which makes debugging painful. Disable caching upfront. - **Pool sizing formula uses app instance cores, not database cores.** A 64-core DB server does not mean you need 128 connections. You probably need 8–10 per node. - **connectionTimeout at 30 seconds is too generous.** Your mobile clients have already left. Use 5 seconds, fail fast, and handle retries at the application layer. - **Connection leaks hide in low-traffic endpoints.** Add detection early, not after your first spike. ## Conclusion The connection pool is the narrowest pipe in your mobile backend. We spent two weeks tuning application code that turned out not to matter. The pool config took an afternoon and fixed everything. Start with `maxLifetime` below your server-side timeouts, disable prepared statement caching when using PgBouncer transaction mode, and size your pool per app instance — not per database. These three changes took our p99 from 2,400 ms to 85 ms under 10x load. **Further reading:** - [HikariCP Configuration Guide](https://github.com/brettwooldridge/HikariCP#frequently-used) - [PostgreSQL Wiki: Number of Connections](https://wiki.postgresql.org/wiki/Number_Of_Database_Connections) - [PgBouncer Feature Matrix](https://www.pgbouncer.org/features.html)
-
shardingsphere
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
-
-
Project mention: How to Build Presto from Source - OSS Contribution Guide (Step by Step Tutorial) | dev.to | 2026-01-14
[Important Links] Presto Website: https://prestodb.io Join Slack: https://communityinviter.com/apps/prestodb/prestodb
-
Project mention: How to give Claude Code persistent memory with a self-hosted mem0 MCP server | dev.to | 2026-02-18
The stack runs on Qdrant for vector storage, Ollama for local embeddings, and optional Neo4j for a knowledge graph that I added later. I also set it up to route different operations to the best LLM for each task. It provides eleven tools for your Claude Code instance to manage long-term memory operations, and your memories data never leaves your machine.
-
Project mention: Apache Doris 4.0: One Engine for Analytics, Full-Text Search, and Vector Search | dev.to | 2025-10-24
The latest version of Apache Doris is now available for download. Visit doris.apache.org for detailed release notes and upgrade guides, and join the Doris community to explore, test, and share your feedback.
-
We can now create a schema on Iceberg to hold our table. We also create a new table called employee to store employee details. The Trino processing engine will be used to perform these actions.
-
debezium
Change data capture for a variety of databases. Please log issues at https://github.com/debezium/dbz/issues.
Project mention: 7 Free Tools for Data Pipeline Reconciliation and Cross-Source Validation | dev.to | 2026-05-13Debezium is an open-source CDC (change data capture) platform that streams database changes - inserts, updates, deletes - from supported databases (PostgreSQL, MySQL, MongoDB, SQL Server) to downstream consumers via Apache Kafka.
-
Project mention: Turning Google Search into a Kafka Event Stream for Many Consumers | dev.to | 2026-02-03
Next, Kafka requires Zookeeper and a broker. Instead of installing them manually, we use Docker Compose with this YAML file.
-
Project mention: War Story: We Survived a 2-Hour Outage with Redis 8.0 Cluster and Sentinel | dev.to | 2026-05-02
We recommend the official go-redis client for Go, redis-py for Python, and Jedis for Java, as all three have added support for Redis 8.0’s new Cluster and Sentinel features. Avoid using older clients or community-maintained forks that may not support Redis 8.0’s updated gossip protocol or slot migration logic. All three official clients include error handling for Sentinel failover events, which is critical for minimizing traffic drops during failover. We use go-redis v9.4.0 in production, which has handled 142k writes/sec with <0.01% error rate post-fix.
-
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.
-
-
If you are using Flyway for migrations (as we do on Libelo), put this in your first migration file and it will run once on initial database setup:
-
Apache Cassandra
Open source transactional distributed database. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure without compromising performance.
-
Android Debug Database
A library for debugging android databases and shared preferences - Make Debugging Great Again
I am Amit Shekhar, Founder @ Outcome School, I have taught and mentored many developers, and their efforts landed them high-paying tech jobs, helped many tech companies in solving their unique problems, and created many open-source libraries being used by top companies. I am passionate about sharing knowledge through open-source, blogs, and videos.
-
-
-
-
-
Zeppelin
Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.
Project mention: Woxi: Wolfram Mathematica Reimplementation in Rust | news.ycombinator.com | 2026-02-25I wonder if it would make a good Zeppelin interpreter. https://zeppelin.apache.org/
-
The ORM as it's referred to in classic programming books (e.g. Hibernate and friends) is a very different beast from today's ORM. Modern ORMs like Drizzle (and to some extent Prisma) are more akin to typed query builders.
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
-
Kronotop: Distributed, transactional document database on FoundationDB
-
Show HN: Kronotop – A distributed multi-model database built on FoundationDB
-
QuestDB 9.4.0
-
QuestDB 爆高危漏洞：无需密码，即可掌控你的数据库！附漏洞细节与临时缓解方案
-
JOOQ: The easiest way to write SQL in Java
-
IndexNow, libSQL, and three other tools I reached for this week
-
Using PostGIS with Azure Database for PostgreSQL
-
A note from our sponsor - SaaSHub
www.saashub.com | 14 Jun 2026
Index
What are some of the best open-source Database projects in Java? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | dbeaver | 50,531 |
| 2 | Chat2DB | 25,751 |
| 3 | HikariCP | 21,113 |
| 4 | shardingsphere | 20,735 |
| 5 | QuestDB | 17,039 |
| 6 | Presto | 16,712 |
| 7 | Neo4j | 16,708 |
| 8 | doris | 15,460 |
| 9 | Trino | 12,915 |
| 10 | debezium | 12,813 |
| 11 | Apache ZooKeeper | 12,763 |
| 12 | Jedis | 12,329 |
| 13 | starrocks | 11,781 |
| 14 | Realm | 11,465 |
| 15 | Flyway | 9,831 |
| 16 | Apache Cassandra | 9,774 |
| 17 | Android Debug Database | 8,659 |
| 18 | shardingsphere-elasticjob | 8,205 |
| 19 | hertzbeat | 7,276 |
| 20 | Leaf | 6,741 |
| 21 | jOOQ | 6,730 |
| 22 | Zeppelin | 6,630 |
| 23 | Hibernate | 6,441 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com