Java SQL

Open-source Java projects categorized as SQL | Edit details

Top 23 Java SQL Projects

  • GitHub repo dbeaver

    Free universal database tool and SQL client

    Project mention: Discussion Thread | reddit.com/r/neoliberal | 2022-01-11

    install DBeaver because it's better anyway DBeaver fails to download plugins from server because of outdated SSL certificates "fixed in early access version" install early access version realize it's the same version that was already published not fixed

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • GitHub repo MyBatis

    MyBatis SQL mapper framework for Java

    Project mention: 20 years of Hibernate | reddit.com/r/java | 2021-05-24

    How about batch insert, updates, and deletes? I had to fix a broken MyBatis project recently and was surprised that this feature doesn't even seem to be implemented, at least according to this GitHub issue.

  • GitHub repo shardingsphere

    Building a Standard Layer & Ecosystem Above Heterogeneous Databases

    Project mention: Learn how to use ShardingSphere version 5.0 in a practical scenario case integrating data sharding, read/write splitting, and data encryption & decryption. Details below, no paywall: | reddit.com/r/programming | 2021-12-23
  • GitHub repo Presto

    The official home of the Presto distributed SQL query engine for big data

    Project mention: Let's write a compiler, part 5: A code generator | news.ycombinator.com | 2021-08-19
  • GitHub repo QuestDB

    An open source SQL database designed to process time series data, faster

    Project mention: questdb: NEW Data - star count:7726.0 | reddit.com/r/algoprojects | 2022-01-15
  • GitHub repo Flyway

    Flyway by Redgate • Database Migrations Made Easy.

    Project mention: Misunderstandings about deploying, docker, and databases | reddit.com/r/learnprogramming | 2021-12-21

    I use a schema versioning tool in the application repo. The one I use is called Flyway and is often used for JVM based applications.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • GitHub repo beam

    Apache Beam is a unified programming model for Batch and Streaming

    Project mention: Jinja2 not formatting my text correctly. Any advice? | reddit.com/r/learnpython | 2021-12-10

    ListItem(name='Apache Beam', website='https://beam.apache.org/', category='Batch Processing', short_description='Apache Beam is an open source unified programming model to define and execute data processing pipelines, including ETL, batch and stream processing'),

  • GitHub repo Trino

    Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

    Project mention: Distributed SQL query engine for big data | reddit.com/r/techtravel | 2021-12-22
  • GitHub repo jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: How does jooq do Prepared statements for DDL in Postgres | reddit.com/r/jOOQ | 2022-01-19

    Then test that against your pgjdbc driver version and server version, to remove jOOQ from the equation. Pretty sure, this issue has nothing to do with jOOQ directly, although I think we could add some convenience in the future to work around having to specify the Settings.statementType for DDL statements manually in case a static statement is preferred: https://github.com/jOOQ/jOOQ/issues/12901

  • GitHub repo 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: Any graph database with a future? | reddit.com/r/learnprogramming | 2021-11-11

    I think the best multi-modal with a high focus on their graph-side outside of Neo4j for the last few years has been OrientDB.

  • GitHub repo Apache Hive

    Apache Hive

    Project mention: Apache Hive in the vein! | dev.to | 2021-12-22
  • GitHub repo Apache Ignite

    Apache Ignite (by apache)

    Project mention: Which library/project do you wish was ported to golang? | reddit.com/r/golang | 2022-01-09

    Apache Ignite https://ignite.apache.org/

  • GitHub repo 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: Open Source SQL Parsers | dev.to | 2021-10-08

    JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.

  • GitHub repo Crate

    CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.

    Project mention: Parser generators vs. handwritten parsers: surveying major languages in 2021 | news.ycombinator.com | 2021-08-21
  • GitHub repo H2

    H2 is an embeddable RDBMS written in Java.

    Project mention: Ask HN: Who wants to be hired? (December 2021) | news.ycombinator.com | 2021-12-01
  • GitHub repo requery

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

  • GitHub repo liquibase

    Main Liquibase Source

    Project mention: SQL - Moving from concatenated queries to parameterized queries | reddit.com/r/learnprogramming | 2022-01-05

    However, if you’re concerned if these queries will continue to work as before, I would recommend investing in creating tests for these. Using an in-memory database such as H2 or using Testcontainers, perhaps mixed with Liquibase to automate database updates, would allow you to create a stable database on which you can perform and test your queries.

  • GitHub repo Apache Calcite

    Apache Calcite

    Project mention: Anyone know of any software that can help in designing then outputting to various database | reddit.com/r/DatabaseHelp | 2021-11-21

    Abstraction Layer - You can use something like Calcite to abstract out your data storage. https://calcite.apache.org/

  • GitHub repo spotless

    Keep your code spotless

    Project mention: The obligatory braces and if/else questions | reddit.com/r/javahelp | 2021-09-10

    I use Spotless and it works quite well, but there are many other options. Also good IDEs can reformat your code.

  • GitHub repo Apache Drill

    Apache Drill is a distributed MPP query layer for self describing data

    Project mention: Apache Drill: the reports of my death have been greatly exaggerated | news.ycombinator.com | 2021-11-01

    >We’ve started talking about speeding up our release cadence to better reflect our recent activity.

    There's been only one release per year in the past so you can't fault anyone to think the project is dead.

    https://github.com/apache/drill/releases

  • GitHub repo JDBI

    jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integration

    Project mention: Spring Data — Power of Domain Events | dev.to | 2021-11-27

    By the way, you probably don't need Spring Data and Hibernate, if you apply the Transaction Script pattern. Since all business rules are bound to services, Hibernate will bring overhead and not so many benefits. Instead, you could try to use JDBI, JOOQ or even plain JDBC.

  • GitHub repo Ebean ORM

    Ebean ORM

    Project mention: What do you whish for Spring 6? | reddit.com/r/java | 2021-09-28

    There is https://ebean.io/ and looks like it a community driven alternative to jOOQ.

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). The latest post mention was on 2022-01-19.

Java SQL related posts

Index

What are some of the best open-source SQL projects in Java? This list will help you:

Project Stars
1 dbeaver 24,162
2 Apache Flink 18,010
3 MyBatis 16,715
4 shardingsphere 15,116
5 Presto 13,043
6 QuestDB 7,781
7 Flyway 6,326
8 beam 5,218
9 Trino 4,745
10 jOOQ 4,725
11 OrientDB 4,401
12 Apache Hive 4,083
13 Apache Ignite 4,050
14 JSqlParser 3,455
15 Crate 3,270
16 H2 3,126
17 requery 3,073
18 liquibase 2,933
19 Apache Calcite 2,864
20 spotless 2,324
21 Apache Drill 1,624
22 JDBI 1,593
23 Ebean ORM 1,270
Find remote jobs at our new job board 99remotejobs.com. There are 28 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
OPS - Build and Run Open Source Unikernels
Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
github.com/nanovms