Top 15 Java Oracle Projects
Free universal database tool and SQL clientProject mention: Generate DDL | reddit.com/r/dbeaver | 2022-06-07
See if you can find it here: https://github.com/dbeaver/dbeaver
jOOQ is the best way to write SQL in JavaProject mention: Deepkit – High-Performance TypeScript Framework | news.ycombinator.com | 2022-06-07
Cool jooq-query-syntax-like ORM! https://deepkit.io/library/orm
It does not seem to have the code-generation (for the db table DTOs) though.
I also like typescript's "string & MinLength<3> & Email" type combining.
A quick edit-test-loop must be a great selling point of this kind of FW compared to FW in more strongly types languages (that have slower edit-test-loops due to compilation) that I usually prefer.
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.
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor PatternProject 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.
Main Liquibase SourceProject mention: springboot with stored procedures | reddit.com/r/SpringBoot | 2022-04-18
You might gain some efficiency but lose maintainability. I have worked on codebases were SP are coded, tuned and inserted by and, but this is painful for testing and so on. Instead, use FlywayDB https://flywaydb.org/ or Liquibase https://www.liquibase.org/ for configuration management of the DB, to handle the DB migrations including inserting the SPs. In Spring use the SimpleJdbcCallOperations interface to call the SPs (with the concrete implementation class being SimpleJdbc), that way it is easy to mock or stub the database calls for unit testing. Use the unit testing framework that works best with your database to test your SPs, e.g. for Oracle see https://docs.oracle.com/cd/E15846_01/doc.21/e15222/unit_testing.htm#RPTUG45064
requery - modern SQL based query & persistence for Java / Kotlin / Android
Ebean ORMProject mention: How do you guys go about the persistence layer? | reddit.com/r/java | 2022-03-23
You can have a look at https://ebean.io/ ... better control over the generated SQL, multiple levels of abstraction, can generate DB migrations and run the DB migrations, transparent encryption support, SQL 2011 history support, test against docker containers.
Container auto-configurations for Spring Boot based integration testsProject mention: Building a Scalable Live Stream Chat Service with Spring WebFlux, Redis PubSub, RSocket and Auth0 | dev.to | 2021-08-20
We will use the Playtika testcontainers-springboot library to easily spin up a Redis docker container while running the integration tests locally. This can then be used as our PubSub message broker as we test the functionality of the connection server.
Developer Ecosystem Survey 2022. Take part in the Developer Ecosystem Survey 2022 by JetBrains and get a chance to win a Macbook, a Nvidia graphics card, or other prizes. We’ll create an infographic full of stats, and you’ll get personalized results so you can compare yourself with other developers.
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: migrate giant 17TB DB from mariadb10.4 to MySQL 8 | reddit.com/r/mysql | 2021-12-10
Use replication. https://www.symmetricds.org/
Universal transaction managerProject mention: A Universal Transaction Manager | news.ycombinator.com | 2021-09-21
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
GitHub Action to download and install Oracle's Java Development Kit builds (by oracle-actions)Project mention: Which version you have found most useful and stable after Java 8 ? | reddit.com/r/java | 2022-05-04
Java code generator for calling PL/SQL.
A Simple tool that generates Micronaut ComponentsProject mention: Demo: Generating REST & Graph Endpoint In a Micronaut Application Using MicrostarterCLI | reddit.com/r/programming | 2022-02-04
Working apps demoing Autonomous Converged Database powerful capabilities for developersProject mention: NoSQL & SQL together: Spring Boot example🤯 | dev.to | 2022-04-29
Spring Boot sample app on GitHub
Shujutech Object Relational Mapping Interface, the only Java ORM that fully supports all OO concepts.
Java Oracle related posts
Which version you have found most useful and stable after Java 8 ?
1 project | reddit.com/r/java | 4 May 2022
global-tz, a new fork of iana-tz (uses JEP 330 to automate data transformation)
3 projects | reddit.com/r/java | 21 Mar 2022
Introducing the `oracle-actions/setup-java` GitHub action
3 projects | reddit.com/r/java | 14 Mar 2022
Setup local MS SQL docker container
4 projects | dev.to | 13 Dec 2021
What are some of the best open-source Oracle projects in Java? This list will help you:
Are you hiring? Post a new remote job listing for free.