Java Jdbc

Open-source Java projects categorized as Jdbc Edit details
Related topics: #Java #Database #SQL #ORM #Projects

Top 23 Java Jdbc Projects

  • HikariCP

    光 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.

  • 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-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 .

  • 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.

  • Hibernate

    Hibernate's core Object/Relational Mapping functionality

    Project 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

    jOOQ is the best way to write SQL in Java

    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.

    [1]: https://www.jooq.org/

  • H2

    H2 is an embeddable RDBMS written in Java.

    Project mention: Database of Databases | dev.to | 2022-06-23

    H2 - Free, Embedded & Open source

  • requery

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

  • sqlite-jdbc

    SQLite JDBC Driver

    Project 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.

  • 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.

  • Apache Drill

    Apache Drill is a distributed MPP query layer for self describing data

    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-17

    Another option is JDBI, that helps you with mappings too while having less features than JPA: https://jdbi.org/

  • Ebean ORM

    Ebean ORM

    Project 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.

  • Jailer

    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

  • SchemaCrawler

    Free database schema discovery and comprehension tool

  • pgjdbc

    Postgresql JDBC Driver

    Project mention: Postgres Java lib returns wrong numeric value after 5 reads | news.ycombinator.com | 2022-04-06
  • kafka-connect-jdbc

    Kafka Connect connector for JDBC-compatible databases

    Project 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.

  • db-scheduler

    Persistent cluster-friendly scheduler for Java

  • spring-data-relational

    Spring Data Relational

    Project mention: Jodd – The Unbearable Lightness of Java | news.ycombinator.com | 2022-01-17

    This is not correct. You're thinking Spring Data JPA [1]. Spring Data JDBC [2] does _not_ use any Hibernate nonsense.

    [1] https://spring.io/projects/spring-data-jdbc

  • pgjdbc-ng

    A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres

    Project 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-data-source-decorator

    Spring Boot integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth

    Project mention: P6Spy - มา debug SQL command จาก JPA | dev.to | 2022-02-03
  • 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

  • vertx-jooq

    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

    QuickPerf is a testing library for Java to quickly evaluate and improve some performance-related properties

  • spring-petclinic-rest

    REST version of the Spring Petclinic sample application

    Project mention: Containerizing a Spring/Angular application with Docker Compose | dev.to | 2021-12-07

    Spring Boot-powered REST API

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 2022-06-23.

Java Jdbc related posts

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
Find remote jobs at our new job board 99remotejobs.com. There are 4 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
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.
scoutapm.com