Top 21 Java Oracle Projects

• dbeaver

  27 37,391 9.9 Java

  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

• APIJSON

  0 16,643 8.4 Java

  🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.

  

• InfluxDB

  www.influxdata.com sponsored

  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.

  

• Chat2DB

  3 12,566 9.9 Java

  AI-driven data management platform Over 1 million developers are using Chat2DB

  

Project mention: Show HN: AI-driven data development and analysis platform | news.ycombinator.com | 2024-04-08

• ali-dbhub

  2 8,454 9.5 Java

  已迁移新仓库，此版本将不再维护

  

Project mention: FLaNK Stack Weekly for 20 June 2023 | dev.to | 2023-06-20

ChatGPT Mac/Windows App for SQL https://github.com/alibaba/Chat2DB

• jOOQ

  94 5,882 9.8 Java

  jOOQ is the best way to write SQL in Java

  

Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

> 2. ORMs do not hide SQL nastiness.

This is certainly true!

I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".

I think the are of ORMs is over. It simply did not deliver.

If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.

I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.

There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)

https://www.jooq.org/

https://hasura.io/

• JSqlParser

  4 4,956 9.2 Java

  JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

  

• liquibase

  54 4,394 9.9 Java

  Main Liquibase Source

  

Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12

While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase

• WorkOS

  workos.com sponsored

  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.

  

• requery

  1 3,132 0.0 Java

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

  

• Jailer

  217 2,705 9.6 Java

  Database Subsetting and Relational Data Browsing Tool.

Project mention: Show HN: Jailer is a unique open-source database client tool | news.ycombinator.com | 2024-03-14

• Ebean ORM

  7 1,429 9.5 Java

  Ebean ORM

  

• oracle-db-examples

  2 1,263 7.0 Java

  Examples of applications and tool usage for Oracle Database

  

Project mention: JSON Relational Duality View (Oracle 23g) | news.ycombinator.com | 2023-07-05

Interesting idea from Oracle. See also https://github.com/oracle-samples/oracle-db-examples/tree/ma...

• testcontainers-spring-boot

  2 829 9.7 Java

  Container auto-configurations for Spring Boot based integration tests

  

• symmetric-ds

  12 691 9.5 Java

  SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.

  

Project mention: FLaNK Stack Weekly for 14 Aug 2023 | dev.to | 2023-08-14

• ReplicaDB

  1 357 5.7 Java

  ReplicaDB is open source tool for database replication, designed for efficiently transferring bulk data between relational and non-relational databases

• obevo

  2 227 0.0 Java

  Obevo is a database deployment tool that handles enterprise scale schemas and complexity

  

Project mention: Working with jOOQ and Flyway using Testcontainers | /r/java | 2023-06-08

The one that does complex stuff (aka super Enterprise) which you would think would be closed source is open source: https://github.com/goldmansachs/obevo

• setup-java

  6 58 7.9 Java

  GitHub Action to download and install Oracle's Java Development Kit builds (by oracle-actions)

  

• oracle-jdbc-tester

  1 49 0.0 Java

  A simple command line Java application to test JDBC connection to Oracle database

• OBridge

  0 23 0.6 Java

  Java code generator for calling PL/SQL.

• MicrostarterCli

  8 16 5.2 Java

  A Simple tool that generates Micronaut Components

• autonomous-database-for-developers

  1 4 0.0 Java

  Working apps demoing Autonomous Converged Database powerful capabilities for developers

• StORMi

  3 0 3.4 Java

  Shujutech Object Relational Mapping Interface, the only Java ORM that fully supports all OO concepts.

Project mention: Ask HN: Is there still ORM hate these days? | news.ycombinator.com | 2023-11-16

• SaaSHub

  www.saashub.com sponsored

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Java Oracle related posts

• Which version you have found most useful and stable after Java 8 ?
  1 project | /r/java | 4 May 2022
• global-tz, a new fork of iana-tz (uses JEP 330 to automate data transformation)
  3 projects | /r/java | 21 Mar 2022
• Introducing the `oracle-actions/setup-java` GitHub action
  3 projects | /r/java | 14 Mar 2022
• Setup local MS SQL docker container
  4 projects | dev.to | 13 Dec 2021

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending Java projects with our weekly report!