Java Database

Open-source Java projects categorized as Database

Top 23 Java Database Projects

  • dbeaver

    Free universal database tool and SQL client

    Project mention: DBeaver – open-source Database client | news.ycombinator.com | 2024-03-10

    Yes but not in the community version:

    https://github.com/dbeaver/dbeaver/wiki/Schema-compare

  • shardingsphere

    Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.

    Project mention: Managing Data Residency - the demo | dev.to | 2023-05-25

    Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • HikariCP

    光 HikariCP・A solid, high-performance, JDBC connection pool at last.

    Project mention: Java virtual threads caused a deadlock in TPC-C for PostgreSQL | news.ycombinator.com | 2024-01-15

    Looks like HikariCP is also awaiting fixes for this https://github.com/brettwooldridge/HikariCP/pull/2055

  • Presto

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

    Project mention: Multi-Database Support in DuckDB | news.ycombinator.com | 2024-01-28

    We have some of this functionality in Presto (https://github.com/prestodb/presto), but it takes fair bit of work to implement it for all the different backends.

  • QuestDB

    An open source time-series database for fast ingest and SQL queries

    Project mention: How to Forecast Air Temperatures with AI + IoT Sensor Data | dev.to | 2024-03-24

    If your data lacks uniform time intervals between consecutive entries, QuestDB offers a solution by allowing you to sample your data. After that, MindsDB facilitates creating, training, and deploying your time-series models.

  • Neo4j

    Graphs for Everyone

    Project mention: How to choose the right type of database | dev.to | 2024-02-28

    Neo4j: An ACID-compliant graph database with a high-performance distributed architecture. Ideal for complex relationship and pattern analysis in domains like social networks.

  • Apache ZooKeeper

    Apache ZooKeeper

    Project mention: On Implementation of Distributed Protocols | dev.to | 2024-04-05

    Apache ZooKeeper — a distributed coordination, synchronization, and configuration service (written in Java);

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • Jedis

    Redis Java client

  • Realm

    Realm is a mobile database: a replacement for SQLite & ORMs

  • doris

    Apache Doris is an easy-to-use, high performance and unified analytics database.

    Project mention: Variant in Apache Doris 2.1.0: a new data type 8 times faster than JSON for semi-structured data analysis | dev.to | 2024-03-27

    As an open-source real-time data warehouse, Apache Doris provides semi-structured data processing capabilities, and the newly-released version 2.1.0 makes a stride in this direction. Before V2.1, Apache Doris stores semi-structured data as JSON files. However, during query execution, the real-time parsing of JSON data leads to high CPU and I/O consumption in addition to high query latency, especially when the dataset is huge and complicated. Moreover, the lack of a pre-defined schema means there is no handle for query optimization.

  • debezium

    Change data capture for a variety of databases. Please log issues at https://issues.redhat.com/browse/DBZ.

    Project mention: Choosing Between a Streaming Database and a Stream Processing Framework in Python | dev.to | 2024-02-10

    They manage data in the application layer and your original data stays where it is. This way data consistency is no longer an issue as it was with streaming databases. You can use Change Data Capture (CDC) services like Debezium by directly connecting to your primary database, doing computational work, and saving the result back or sending real-time data to output streams.

  • Trino

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

    Project mention: Trino: Fast distributed SQL query engine for big data analytics | news.ycombinator.com | 2024-03-19
  • Apache Cassandra

    Mirror of Apache Cassandra

    Project mention: How to Choose the Right MQTT Data Storage for Your Next Project | dev.to | 2023-07-23

    Apache Cassandra{:target="_blank"} is a highly scalable and fault-tolerant database that can handle large volumes of data across multiple nodes or clusters. It provides fast read and write operations, making it suitable for real-time analytics or applications with high throughput requirements.

  • Android Debug Database

    A library for debugging android databases and shared preferences - Make Debugging Great Again

  • shardingsphere-elasticjob

    Distributed scheduled job

  • Flyway

    Flyway by Redgate • Database Migrations Made Easy.

    Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14

    Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/

    (Though I don't think it is "complete" or "perfect", either.)

    EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's tooling you can package your migration "runner application" as a single deployable executable for most platforms. You can build the executable once and run it in all your environments. (The same tool that updates your QA and Staging updates your Prod, testably running the same migrations.) Given the single executable deployable I might even consider using it for projects not themselves written in C#.

  • starrocks

    StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.

    Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09

    tidb 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

  • Leaf

    Distributed ID Generate Service (by Meituan-Dianping)

  • Zeppelin

    Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.

    Project mention: Serverless Apache Zeppelin on AWS | dev.to | 2024-02-04

    Now we can proceed with the definition of Apache Zeppelin. It is a web-based notebook that enables data-driven, interactive data analytics and collaborative documents with Python, Scala, SQL, Spark, and more. You can execute code and even schedule a job (via cron) to run at regular intervals.

  • jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: ORMs are nice but they are the wrong abstraction | news.ycombinator.com | 2024-02-01
  • Hibernate

    Hibernate's core Object/Relational Mapping functionality

    Project mention: Como desenvolvi um backend web em Clojure | dev.to | 2023-07-03
  • Apache Hive

    Apache Hive

  • lettuce

    Advanced Java Redis client for thread-safe sync, async, and reactive usage. Supports Cluster, Sentinel, Pipelining, and codecs.

    Project mention: Redis Cluster with heavy write application results in bad redis read latency | /r/redis | 2023-06-05

    I am using lettuce java library with async api. They says it used pipelining as default. Also I tried manually command flushing. I don't see the improvement.

  • 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). The latest post mention was on 2024-04-14.

Java Database related posts

Index

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

Project Stars
1 dbeaver 37,191
2 shardingsphere 19,406
3 HikariCP 19,344
4 Presto 15,562
5 QuestDB 13,420
6 Neo4j 12,398
7 Apache ZooKeeper 11,911
8 Jedis 11,592
9 Realm 11,440
10 doris 11,272
11 debezium 9,843
12 Trino 9,519
13 Apache Cassandra 8,502
14 Android Debug Database 8,334
15 shardingsphere-elasticjob 8,053
16 Flyway 7,754
17 starrocks 7,684
18 Leaf 6,277
19 Zeppelin 6,261
20 jOOQ 5,874
21 Hibernate 5,726
22 Apache Hive 5,314
23 lettuce 5,245
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com