Top 23 Java Jdbc Projects
光 HikariCP・A solid, high-performance, JDBC connection pool at last.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.
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-11
Although 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 .
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.
Hibernate's core Object/Relational Mapping functionalityProject mention: Do people use JPA a whole lot? | reddit.com/r/java | 2022-05-13
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.
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.
H2 is an embeddable RDBMS written in Java.Project mention: Database of Databases | dev.to | 2022-06-23
H2 - Free, Embedded & Open source
requery - modern SQL based query & persistence for Java / Kotlin / Android
SQLite JDBC DriverProject mention: I’m Switching from VS Code to vs Codium | news.ycombinator.com | 2022-06-12
> 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.
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.
Apache Drill is a distributed MPP query layer for self describing dataProject 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 is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.
jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integrationProject 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-17
Another option is JDBI, that helps you with mappings too while having less features than JPA: https://jdbi.org/
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.
Database Subsetting and Relational Data Browsing Tool.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
Free database schema discovery and comprehension tool
Postgresql JDBC DriverProject mention: Postgres Java lib returns wrong numeric value after 5 reads | news.ycombinator.com | 2022-04-06
Kafka Connect connector for JDBC-compatible databasesProject mention: How Sendoso is using Kafka for Event-Driven Architecture | dev.to | 2021-08-31
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.
Persistent cluster-friendly scheduler for Java
Spring Data Relational
A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and PostgresProject mention: Postgres query execution: JDBC | dev.to | 2021-08-24
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 integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuthProject mention: P6Spy - มา debug SQL command จาก JPA | dev.to | 2022-02-03
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
A jOOQ-CodeGenerator to create vertx-ified DAOs and POJOs.Project mention: What is the state of Spring WebFlux and R2DBC | reddit.com/r/java | 2021-11-06
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 is a testing library for Java to quickly evaluate and improve some performance-related properties
REST version of the Spring Petclinic sample applicationProject 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.
3 projects | reddit.com/r/javahelp | 17 May 2022
What happens when the poolsize is too low?
1 project | reddit.com/r/SpringBoot | 16 May 2022
Struggling to understand how to set up Micronaut for an SQL app that uses repositories for inserts and SQL queries for queries.
2 projects | reddit.com/r/javahelp | 14 May 2022
Do people use JPA a whole lot?
1 project | reddit.com/r/java | 13 May 2022
GitHub - mariadb-developers/java-quickstart: This repository contains code samples for getting started with Java and MariaDB.
1 project | reddit.com/r/java | 5 May 2022
Postgres Java lib returns wrong numeric value after 5 reads
1 project | news.ycombinator.com | 6 Apr 2022
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
1 project | reddit.com/r/node | 6 Apr 2022
What are some of the best open-source Jdbc projects in Java? This list will help you:
|20||Simple Flat Mapper||409|
Are you hiring? Post a new remote job listing for free.