SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Java SQL 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
-
Project mention: Performance Test: Flink 1.19 vs. Spark 4.0 vs. Kafka Streams 3.8 Windowed Aggregation Throughput | dev.to | 2026-05-04
Solution & Implementation: Migrated windowed aggregation from Kafka Streams 3.7 to Flink 1.19, reusing existing Kafka sources/sinks. Optimized Flink config: set parallelism to 16 (matching vCPU), enabled RocksDB state backend with 100ms watermark out-of-order tolerance, configured 5s checkpoints. Trained team on Flink watermarking and state management via Apache Flink GitHub repo documentation.
-
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: 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.
-
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:
-
Project mention: Architecture Teardown: How Meta Trains LLMs for Code Generation on 100k GPU Clusters | dev.to | 2026-04-29
-
-
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.
-
Project mention: 15 AWS EMR Cost Optimization Tips to Slash Your EMR Spending (2025) | dev.to | 2025-12-16
AWS EMR (Elastic MapReduce) is a fully managed big data platform. It manages the setup, configuration, and tuning of open source frameworks like Apache Hadoop, Apache Spark, Apache Hive, Presto, and more at scale on AWS infrastructure. EMR handles cluster scaling, resource allocation, and lifecycle management. This allows you to work with large datasets for various use cases, from ETL pipelines to ML workloads. EMR uses a pay-as-you-go pricing model. Costs for compute, storage, and other AWS services can add up quickly as your data grows, clusters get bigger, and jobs become more complex. If you're not careful, costs can skyrocket due to inefficient resource use, poor instance choices, and misconfigured storage. That's why AWS EMR Cost Optimization is key. It helps you get the best performance per dollar while maintaining data processing speed, reliability, and scalability.
-
JSqlParser
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
-
Project mention: Performance Comparison: Flyway 10.0 vs. Liquibase 4.28 vs. Prisma Migrate 6.0 for Database Migrations | dev.to | 2026-04-30
liquibase/liquibase
-
Is this reasoning, or measurement? If measurement, push it to a deterministic tool. Sonar, Spotless, Ruff, ESLint, coverage gates, pre-commit hooks, complexity calculators. Write a script if no tool exists. That's how just lint got built, and that's the Unix-philosophy move for agentic coding. Hooks fire on tool calls; CI fires on PRs; pre-commit fires on commit. Pick the cheapest layer that catches the failure and run it there.
-
-
Yes, you can use rate limiting with other caching solutions, such as Apache Ignite. However, Redis is a popular choice for rate limiting due to its ease of use and flexibility.
-
OrientDB
OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries.
-
esProc
esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine.
Project mention: Big data technology that is orders of magnitude faster than SQL | dev.to | 2025-11-30SPL is now open-source. You can obtain the source code from GitHub .
-
-
Crate
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
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 SQL discussion
Java SQL related posts
-
QuestDB 9.4.0
-
QuestDB 爆高危漏洞：无需密码，即可掌控你的数据库！附漏洞细节与临时缓解方案
-
ekbatan VS Hibernate - a user suggested alternative
2 projects | 20 May 2026 -
JOOQ: The easiest way to write SQL in Java
-
Zero Downtime Database Migrations: A Practical Guide for PostgreSQL
-
Why Apache IoTDB Is Written in Java: A Decade of Engineering Trade-offs
-
Node.js Database Migrations in Production: Zero-Downtime Strategies That Actually Work
-
A note from our sponsor - SaaSHub
www.saashub.com | 16 Jun 2026
Index
What are some of the best open-source SQL projects in Java? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | dbeaver | 50,531 |
| 2 | Apache Flink | 26,068 |
| 3 | shardingsphere | 20,735 |
| 4 | MyBatis | 20,426 |
| 5 | QuestDB | 17,039 |
| 6 | Presto | 16,712 |
| 7 | doris | 15,460 |
| 8 | Trino | 12,915 |
| 9 | starrocks | 11,781 |
| 10 | Flyway | 9,831 |
| 11 | beam | 8,610 |
| 12 | jOOQ | 6,730 |
| 13 | Hibernate | 6,441 |
| 14 | Apache Hive | 5,976 |
| 15 | JSqlParser | 5,945 |
| 16 | liquibase | 5,525 |
| 17 | spotless | 5,510 |
| 18 | Apache Calcite | 5,137 |
| 19 | Apache Ignite | 5,065 |
| 20 | OrientDB | 4,966 |
| 21 | esProc | 4,683 |
| 22 | H2 | 4,603 |
| 23 | Crate | 4,410 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com