Java Jdbc

Open-source Java projects categorized as Jdbc

Top 23 Java Jdbc Projects

  • HikariCP

    光 HikariCP・A solid, high-performance, JDBC connection pool at last.

    Project mention: HikariCP maximumPoolSize based on AWS ECS number of tasks | reddit.com/r/SpringBoot | 2023-04-21
  • Trino

    Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

    Project mention: Multi-Databases across Multiple Servers - MySQL | reddit.com/r/Database | 2023-05-27

    There are distributed query engines like Trino that help with this sort of problem https://trino.io/

  • ONLYOFFICE

    ONLYOFFICE Docs — document collaboration in your environment. Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises

  • jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Do you use DB Enum Types? | reddit.com/r/ExperiencedDevs | 2023-05-30

    Some of our applications already use DB schema-based code generation too (e.g. jOOQ), which makes using the DB-defined enum quite easy.

  • Hibernate

    Hibernate's core Object/Relational Mapping functionality

    Project mention: JobRunr: A library for background processing in Java | news.ycombinator.com | 2023-05-25
  • H2

    H2 is an embeddable RDBMS written in Java.

    Project mention: SQLite Internals: How the Most Used Database Works | news.ycombinator.com | 2022-12-19

    > ...than it would be to learn the exact syntax and quirks and possibly bugs of someone else's implementation...

    Yup. Also, having deep knowledge of the language is required.

    SQLite's grammar is neat. Creating a compatible parser would make a fun project. Here's a pretty good example: https://github.com/bkiers/sqlite-parser (Actual ANTLR 4 grammar: https://github.com/bkiers/sqlite-parser/blob/master/src/main... )

    Postgres, which tries to be compliant with the latest standards, however...

    SQL-2016 is a beast. Not to mention all the dialects.

    I'm updating my personal (soon to be FOSS) grammar from ANTLR 3 LL(k) to ANTLR 4 ALL().

    I've long had a working knowledge of SQL-92, with some SQL-1999 (eg common table expressions).

    But the new structures and extensions are a bit overwhelming.

    Fortunately, ANTLR project has ~dozen FOSS grammars to learn from. https://github.com/antlr/grammars-v4/tree/master/sql

    They mostly mechanically translate BNFs to LL(k) with some ALL(). Meaning few take advantage of left-recursion. https://github.com/antlr/antlr4/blob/master/doc/left-recursi...

    Honestly, I struggled to understand these grammars. Plus, not being conversant with the SQL-2016 was a huge impediment. Just finding a succinct corbis of test cases was a huge hurdle for me.

    Fortunately, the H2 Database project is a great resource. https://github.com/h2database/h2database/tree/master/h2/src/...

    Now for the exciting conclusion...

    My ANTLR grammar which passes all of H2's tests looks nothing like any of the official or product specific BNFs.

    Further, I found discrepancy between the product specific BNFs and their implementations.

    So a lot of trial & error is required for a "real world" parser. Which would explain why the professional SQL parsing tools charge money.

    I still think creating a parser for SQLite is a great project.

  • requery

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

    Project mention: Learning Android’s Room Database Made Easy | reddit.com/r/androiddev | 2023-01-22

    ah, I was thinking of https://github.com/requery/requery but I wasn't really sure, also that project is dead oh no :D

  • linkis

    Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.

    Project mention: FLiP Stack Weekly for 13-Feb-2023 | dev.to | 2023-02-13
  • Sonar

    Write Clean Java Code. Always.. Sonar helps you commit clean code every time. With over 600 unique rules to find Java bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • sqlite-jdbc

    SQLite JDBC Driver

    Project mention: Exciting SQLite Improvements Since 2020 | news.ycombinator.com | 2023-04-29

    There's also a fairly popular JDBC driver for SQLite too:

    https://github.com/xerial/sqlite-jdbc

    Mentioning that because from (very) rough memory, Excel can work with JDBC too.

    So if the ODBC approach doesn't work for someone, there's potentially another thing they can try. :)

  • p6spy

    P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.

    Project mention: Logging FULL select in hibernate | reddit.com/r/javahelp | 2022-12-19
  • Apache Drill

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

    Project mention: Building a Data Lakehouse for Analyzing Elon Musk Tweets using MinIO, Apache Airflow, Apache Drill and Apache Superset | dev.to | 2023-01-20

    💡 You ca read more here.

  • 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: Is it just me, or does the Spring Framework lead to hard-to-maintain code and confusion with annotations? | reddit.com/r/java | 2023-04-19
  • Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Database Subsetting and Relational Data Browsing | news.ycombinator.com | 2023-05-30

    This is my passion project. The subsetter is certainly something for specialists, but the data browser is unique and very useful for many.

    https://github.com/Wisser/Jailer

    Feedback and ideas for improvement are very welcome.

  • SchemaCrawler

    Free database schema discovery and comprehension tool

    Project mention: Automatically Document Your Database in Markdown | dev.to | 2023-04-23

    Grab the Python script of "markdown.py" from SchemaCrawler's GitHub repository, and save it in your local directory.

  • Ebean ORM

    Ebean ORM

    Project mention: loom and database drivers | reddit.com/r/java | 2023-02-18
  • pgjdbc

    Postgresql JDBC Driver

    Project mention: For daily Java programmers: after almost one decade of Java 8, are streams and lambdas fully adopted by the Java community? | reddit.com/r/java | 2023-03-31
  • clickhouse-java

    Java client and JDBC driver for ClickHouse

    Project mention: SQL should be your default choice for data engineering pipelines | news.ycombinator.com | 2023-01-30

    Agree with the OP that SQL will almost assuredly still be in use for 20+ years in the future, given the simplicity and flexibility of the declarative language, standardization, and as applicable to today as it was then to our big data problems.

    Any discussion of SQL at scale must include ClickHouse [https://clickhouse.com/docs/en/install#self-managed-install], given it's broad open-source use, integrations available for Spark with JDBC [https://github.com/ClickHouse/clickhouse-jdbc/] or the open-source Spark-ClickHouse Connector [https://github.com/housepower/spark-clickhouse-connector], and capability to scale SQL as a network service.

    Disclosure: I work for ClickHouse

  • kafka-connect-jdbc

    Kafka Connect connector for JDBC-compatible databases

  • db-scheduler

    Persistent cluster-friendly scheduler for Java

    Project mention: JobRunr: A library for background processing in Java | news.ycombinator.com | 2023-05-25

    db-scheduler is also worth checking out: https://github.com/kagkarlsson/db-scheduler

  • spring-data-relational

    Spring Data Relational

    Project mention: You might not need an ORM | news.ycombinator.com | 2023-01-25

    What do you think of Spring Data JDBC (https://spring.io/projects/spring-data-jdbc)?

  • spring-boot-data-source-decorator

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

  • datasource-proxy

    Provide listener framework for JDBC interactions and query executions via proxy.

    Project mention: Integration Tests for N + 1 problem in Java | dev.to | 2023-05-21

    There is a cool library called datasource-proxy. It provides a convenient API to wrap javax.sql.DataSource interface with a proxy containing specific logic. For example, we can register callbacks invoked before and after query execution. What's interesting is that the library also contains out-of-the-box solution to count executed queries. We're going to alter it a bit to serve our needs.

  • pgjdbc-ng

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

  • 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

  • CodiumAI

    TestGPT | Generating meaningful tests for busy devs. Get non-trivial tests (and trivial, too!) suggested right inside your IDE, so you can code smart, create more value, and stay confident when you push.

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 2023-05-30.

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 18,222
2 Trino 7,865
3 jOOQ 5,445
4 Hibernate 5,411
5 H2 3,720
6 requery 3,117
7 linkis 3,064
8 sqlite-jdbc 2,412
9 p6spy 1,844
10 Apache Drill 1,814
11 JDBI 1,777
12 Jailer 1,615
13 SchemaCrawler 1,409
14 Ebean ORM 1,385
15 pgjdbc 1,266
16 clickhouse-java 1,242
17 kafka-connect-jdbc 910
18 db-scheduler 880
19 spring-data-relational 668
20 spring-boot-data-source-decorator 636
21 datasource-proxy 591
22 pgjdbc-ng 568
23 Simple Flat Mapper 421
Access the most powerful time series database as a service
Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
www.influxdata.com