SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Java SQL Projects
-
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
In conclusion, Apache Flink is more than a big data processing tool—it is a thriving ecosystem that exemplifies the power of open source collaboration. From its impressive technical capabilities to its innovative funding model, Apache Flink shows that sustainable software development is possible when community, corporate support, and transparency converge. As industries continue to demand efficient real-time data processing solutions, the future looks bright for Apache Flink. Whether you’re a developer, business analyst, or technology enthusiast, understanding the dynamics behind Apache Flink provides valuable insights into the evolving landscape of open source software. For further exploration of this subject, visit the official Apache Flink website or explore the comprehensive details hosted by the Apache Software Foundation. Stay tuned for more articles that delve into how open source models are shaping the future of technology. Happy coding!
-
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: Using IRIS and Presto for high-performance and scalable SQL queries | dev.to | 2025-01-19
The rise of Big Data projects, real-time self-service analytics, online query services, and social networks, among others, have enabled scenarios for massive and high-performance data queries. In response to this challenge, MPP (massively parallel processing database) technology was created, and it quickly established itself. Among the open-source MPP options, Presto (https://prestodb.io/) is the best-known option. It originated in Facebook and was utilized for data analytics, but later became open-sourced. However, since Teradata has joined the Presto community, it offers support now.
-
Project mention: QuestDB is an open source time-series database for fast ingest and SQL queries | news.ycombinator.com | 2024-08-31
-
Project mention: Apache Doris: open-source data warehouse for real time data analytics | news.ycombinator.com | 2024-10-26
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
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: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb
Somewhat relatedly, StarRocks is also MySQL compatible, written in Java and C++, but it's tackling OLAP use-cases. https://github.com/StarRocks/starrocks
-
Project mention: Ne jouez plus tout l'historique de vos migrations Flyway grâce au baseline ! | dev.to | 2025-01-09
-
Even ASF does not use Maven to build some of its projects anymore: Beam, Groovy, Lucene, Geode, POI, and Solr are not built with Maven. Those are not the most popular ASF projects, I know, but still, it is something.
-
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.
-
Project mention: Hive: An Open-Source Data Warehouse Built on Apache Hadoop | news.ycombinator.com | 2024-08-13
-
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
-
-
Apache Ignite — Free and open-source, Apache Ignite is a horizontally scalable key-value cache store system with a robust multi-model database that powers APIs to compute distributed data. Ignite provides a security system that can authenticate users' credentials on the server. It can also be used for system workload acceleration, real-time data processing, analytics, and as a graph-centric programming model.
-
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.
-
-
Project mention: We Have Code Quality At Home: Open Source Java Code Quality Tools | dev.to | 2024-05-06
Spotless is an open-source, multi-language, customizable code formatter for projects. It comes with a Maven Plugin that can be customized as needed.
-
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.
-
-
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.
Great initiative making a list of possible Rockset replacements. Would it be possible to open the Notion page for guest contributions?
I would like to add CrateDB (I work there) to the list. CrateDB is a distributed SQL database purposely built for real-time analytics across large datasets of structured and semi-structured data. Similarly to Rockset, it indexes all data in real-time (text, vector, geospatial, time-series, and JSON) for the most efficient search and fast ad hoc query execution at any scale. It is built on top of Apache Lucene and unlike Rockset is open-source (https://github.com/crate/crate).
Rocket frequently comes up among other solutions our users were looking at before choosing CrateDB. For example https://cratedb.com/customers/govspend.
-
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 SQL discussion
Java SQL related posts
-
How To Secure APIs from SQL Injection Vulnerabilities
-
We Built an Open Source DuckDB Alternative
-
Probably the Most Lightweight Columnar Storage Technology
-
DeepSeek Drops Distributed DuckDB
-
Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points
-
Complement a certain average value to ensure that the total sum remains unchanged:SQL VS SPL
-
esProc SPL & MongoDB: A Match Made in Data Heaven
-
A note from our sponsor - SaaSHub
www.saashub.com | 24 Mar 2025
Index
What are some of the best open-source SQL projects in Java? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | dbeaver | 42,302 |
| 2 | Apache Flink | 24,649 |
| 3 | shardingsphere | 20,128 |
| 4 | MyBatis | 20,011 |
| 5 | Presto | 16,272 |
| 6 | QuestDB | 15,000 |
| 7 | doris | 13,362 |
| 8 | Trino | 11,023 |
| 9 | starrocks | 9,701 |
| 10 | Flyway | 8,628 |
| 11 | beam | 8,046 |
| 12 | jOOQ | 6,338 |
| 13 | Hibernate | 6,115 |
| 14 | Apache Hive | 5,659 |
| 15 | JSqlParser | 5,609 |
| 16 | liquibase | 4,954 |
| 17 | Apache Ignite | 4,897 |
| 18 | OrientDB | 4,785 |
| 19 | Apache Calcite | 4,763 |
| 20 | spotless | 4,755 |
| 21 | esProc | 4,627 |
| 22 | H2 | 4,311 |
| 23 | Crate | 4,198 |
Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai