Top 23 Java Jdbc Projects
-
Project mention: Java SQL code generator. SQL and OOP united finally. | reddit.com/r/java | 2022-06-17
There's a reason pretty much any system will use a connection pool (Hikari is the de facto standard). Yours should to.
-
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Project mention: How-to-Guide: Contributing to Open Source | reddit.com/r/dataengineering | 2022-06-11Although Trino (formerly Presto) is in the awesome for beginners list, it’s also a really good DE project as it is a distributed query engine that connects to most of the projects listed above. So depending on where you work in this project you can gain a depth of knowledge on the query engine or breadth across all the connectors …or go hybrid .
-
JetBrains
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.
-
One of my colleagues made a PR to Hibernate to fix query statistics for the case when your usual query is less than 1 millisecond and you have millions of them (not per second surely, but during the lifetime of the application - there were some thousands per second) - that was the case on one of our projects - https://github.com/hibernate/hibernate-orm/pull/810 And that was many years ago - computers got faster since than.
-
Project mention: Deepkit – High-Performance TypeScript Framework | news.ycombinator.com | 2022-06-07
Cool jooq[1]-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.
-
H2 - Free, Embedded & Open source
-
-
> Take the Jetbrains IDEs. I don't mean to offend any VSC fans out there but the Jetbrains IDEs are simply better and more mature in every single way.
I just discontinued my Jetbrains subscription after 10 years or so. Now I'm using VS Code and don't miss anything. My reasons for switching to VS Code are unrelated to the costs but purely due to quality issues and missing or poorly implemented features:
1. For all Jetbrains IDEs, ISO keyboard layout with dead keys doesn't work on Ubuntu based distros. I was baffled when I found out after saying goodbye to Windows lately. When filing a bug I was asked to wade through years old pages of comments to find somewhere someone who posted a workaround that was not compatible with the Toolbox. Well, at least the support could have sent me the instructions to fix it to save me spending an hour to read those threads at the Youtrack.
2. Vue 3 support was a disaster for itself. Still, Vue 3 support is very much behind the VS Code extension.
3. Same for Svelte. They are not even working on bugs / feature requests like intellisense in the templates.
4. Same for TailwindCSS. Never ending storing. Don't know and care if Jetbrains got it right by now.
5. Starting maybe 2 years ago, Jetbrains added feature for feature that were just distracting and annoying. This "run command in terminal" thingie for example. They're bloating their IDEs with new (mostly useless stuff) but don't fix essential bugs or get Webstorm back into shape.
6. Datagrip still doesn't (or maybe it does in the meantime) support SQLite STRICT TABLES (version 3.37). The simple answer from Jetbrains was: "The open source lib we're using does not support it so we don't." (Actually the lib (https://github.com/xerial/sqlite-jdbc) is currently unmaintained - another reason to be careful depending on a lib maintained by a single person.). The reply would be perfectly fine for an open source project, but not for a multi billion dollar company I as a customer had payed accumulated several thousand Euros in the last years.
I'm using mainly Go, Rust and several frontend frameworks. VS Code support for those is really good. Many things work much better in VS Code.
-
SonarLint
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
-
Project mention: DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It | dev.to | 2022-06-02
Apache Drill, Druid, Flink, Hive, Kafka, Spark
-
p6spy
P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.
-
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: What is a simple way to read from a Oracle DataBase and write to a text file, not using Spring Batch (but using Java)? Too complicated for Spring Batch. | reddit.com/r/javahelp | 2022-05-17Another option is JDBI, that helps you with mappings too while having less features than JPA: https://jdbi.org/
-
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.
-
Project mention: Jailer: A tool for database subsetting, schema and data browsing | reddit.com/r/devops | 2022-05-21
Jailer is a tool for database subsetting, schema and data browsing. It creates small slices from your database and lets you navigate through your database following the relationships.. Ideal for creating small samples of test data or for local problem analysis with relevant production data. https://github.com/Wisser/Jailer
-
-
Project mention: Postgres Java lib returns wrong numeric value after 5 reads | news.ycombinator.com | 2022-04-06
-
Event sourcing is an effective architectural pattern to record changes to the application state. Event sequence is important - we need changes as they were originally applied. incoming events are first persisted into Kafka and then processed by services independently. Kafka, hence, becomes our source of truth (SOT), a data source that gives a complete picture of the data object as a whole. This, however, meant dramatic changes in our core application. Our source of truth is still the core database, but we generate events in Kafka when data gets persisted. To ensure transactional behavior, we employed Transactional Outbox pattern. Essentially, we a) created a new events table in the database, b) wrote event data in the same transaction when we update our SOT table. Kafka Connect is subsequently used to read this table and insert records in relevant Kafka topics. This ensures that we never have an inconsistent situation where data was inserted in the database but the event is not added to Kafka topic or vice versa. We evaluated a few connectors for sourcing data from Mysql (JdbcSourceConnector, and Debezium). Our scenario was supported out of the box in JdbcSourceConnector, making it possible to have one event table in Mysql where different rows could be routed to a relevant topic based on the topic field.
-
-
This is not correct. You're thinking Spring Data JPA [1]. Spring Data JDBC [2] does _not_ use any Hibernate nonsense.
-
pgjdbc-ng
A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres
The purists will point out that JDBC is not a product but a standard. And indeed, outside of the official postgres driver "PGJDBC" there are other drivers, such as PGJDBC-NG.
-
spring-boot-data-source-decorator
Spring Boot integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth
-
Simple Flat Mapper
Fast and Easy mapping from database and csv to POJO. A java micro ORM, lightweight alternative to iBatis and Hibernate. Fast Csv Parser and Csv Mapper
-
Does jOOQ work best with a particular framework or driver, or would community projects (e.g. quarkus-jooq, vertx-jooq) be adequate? Assuming they're well maintained, of course.
-
quickperf
QuickPerf is a testing library for Java to quickly evaluate and improve some performance-related properties
-
Project mention: Containerizing a Spring/Angular application with Docker Compose | dev.to | 2021-12-07
Spring Boot-powered REST API
Java Jdbc related posts
- What is a simple way to read from a Oracle DataBase and write to a text file, not using Spring Batch (but using Java)? Too complicated for Spring Batch.
- What happens when the poolsize is too low?
- Struggling to understand how to set up Micronaut for an SQL app that uses repositories for inserts and SQL queries for queries.
- Do people use JPA a whole lot?
- GitHub - mariadb-developers/java-quickstart: This repository contains code samples for getting started with Java and MariaDB.
- Postgres Java lib returns wrong numeric value after 5 reads
- how do i determine the db pool size of each instances of my application if my database has max connection while my loadbalancer can scale to any number instances
Index
What are some of the best open-source Jdbc projects in Java? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | HikariCP | 16,882 |
| 2 | Trino | 5,581 |
| 3 | Hibernate | 4,977 |
| 4 | jOOQ | 4,966 |
| 5 | H2 | 3,334 |
| 6 | requery | 3,097 |
| 7 | sqlite-jdbc | 2,097 |
| 8 | Apache Drill | 1,686 |
| 9 | p6spy | 1,677 |
| 10 | JDBI | 1,653 |
| 11 | Ebean ORM | 1,301 |
| 12 | Jailer | 1,297 |
| 13 | SchemaCrawler | 1,235 |
| 14 | pgjdbc | 1,113 |
| 15 | kafka-connect-jdbc | 830 |
| 16 | db-scheduler | 598 |
| 17 | spring-data-relational | 586 |
| 18 | pgjdbc-ng | 546 |
| 19 | spring-boot-data-source-decorator | 483 |
| 20 | Simple Flat Mapper | 409 |
| 21 | vertx-jooq | 351 |
| 22 | quickperf | 342 |
| 23 | spring-petclinic-rest | 324 |
Are you hiring? Post a new remote job listing for free.
