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: Java virtual threads caused a deadlock in TPC-C for PostgreSQL | news.ycombinator.com | 2024-01-15

    Looks like HikariCP is also awaiting fixes for this https://github.com/brettwooldridge/HikariCP/pull/2055

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • Trino

    Official repository of Trino, the distributed SQL query engine for big data, former

    Project mention: Trino: A fast distributed SQL query engine for big data analytics | news.ycombinator.com | 2024-07-09
  • jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

    > 2. ORMs do not hide SQL nastiness.

    This is certainly true!

    I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".

    I think the are of ORMs is over. It simply did not deliver.

    If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.

    I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.

    There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)

    https://www.jooq.org/

    https://hasura.io/

  • Hibernate

    Hibernate's core Object/Relational Mapping functionality

  • hertzbeat

    Apache HertzBeat(incubating) is a real-time monitoring system with agentless, performance cluster, prometheus-compatible, custom monitoring and status page building capabilities.

    Project mention: Ask HN: How to do dead simple heartbeat monitoring? | news.ycombinator.com | 2024-05-06

    Maybe can try use opensource project apache hertzbeat to monitoring heartbeat. https://github.com/apache/hertzbeat

  • H2

    H2 is an embeddable RDBMS written in Java.

    Project mention: H2 Database – CVE getting flagged by automated scans | news.ycombinator.com | 2023-07-18

    The URL should point to a particular comment, but HN removes fragments: https://github.com/h2database/h2database/issues/3686#issueco...

  • linkis

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

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • requery

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

  • Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Jailer – open-source database client | news.ycombinator.com | 2024-04-30
  • sqlite-jdbc

    SQLite JDBC Driver

    Project mention: The Great Database Migration | news.ycombinator.com | 2024-06-30

    Yes [1], but it sounds like they committed the sqlite file into Github as well?

    [1]: https://github.com/xerial/sqlite-jdbc?tab=readme-ov-file#how...

  • p6spy

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

  • JDBI

    The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

    Project mention: Permazen: Language-natural persistence to KV stores | news.ycombinator.com | 2023-09-19

    While this may work for greenfield applications, I don't see this working well for preexisting schemas. From their getting started page: "Database fields are automatically created for any abstract getter methods", which definitely scares me away since they seem to be relying on automatic field type conversions.

    I prefer to manage my schemas when I can and do type and DAO conversions via mapper classes in the very simple and elegant JDBI framework where you write SQL annotations above your DAO methods https://jdbi.org/#_declarative_api

    JDBI does wonders for wonky old schemas you've inherited, since joins etc work out of the box (just throw them in your annotations!) The annotations can also link to .SQL files for the big hairy queries.

    All these "do magic" frameworks (hibernate being one of the first) work in the simple cases but then fall apart whenever you need to do anything complex/not-prescribed. I end up having to dig into the internals of the framework to see what's going wrong which negates their whole value add.

  • Apache Drill

    Apache Drill is a distributed MPP query layer for self describing data (by apache)

  • sqli

    orm sql query builder, API: QB, QB.X, QrB

  • SchemaCrawler

    Free database schema discovery and comprehension tool

    Project mention: SQLite Schema Diagram Generator | news.ycombinator.com | 2024-03-23
  • pgjdbc

    Postgresql JDBC Driver

    Project mention: Password may not contain: select, insert, update, delete, drop | news.ycombinator.com | 2024-01-21

    The method doAppendEscapeLiteral (Line 66) is a good example; https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main...

    I didn’t take notes all the way down, but at the end of the day this method is invoked when a prepared statements’ parameters are being bound

  • Ebean ORM

    Ebean ORM

  • clickhouse-java

    Java client and JDBC driver for ClickHouse

  • db-scheduler

    Persistent cluster-friendly scheduler for Java

    Project mention: Open source Job Scheduler Library in java for high throughput | /r/java | 2023-11-20

    In java we have found Quartz( Quartz) , Job Runr(Jobrunr) and db-scheduler(db-scheduler) and need to evaluate these for our use case.

  • kafka-connect-jdbc

    Kafka Connect connector for JDBC-compatible databases

  • spring-boot-data-source-decorator

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

  • OpenAM

    OpenAM is an open access management solution that includes Authentication, SSO, Authorization, Federation, Entitlements and Web Services Security.

  • spring-data-relational

    Spring Data Relational. Home of Spring Data JDBC and Spring Data R2DBC.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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).

Java Jdbc discussion

Log in or Post with

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 19,647
2 Trino 9,873
3 jOOQ 6,021
4 Hibernate 5,830
5 hertzbeat 5,205
6 H2 4,120
7 linkis 3,265
8 requery 3,132
9 Jailer 2,787
10 sqlite-jdbc 2,743
11 p6spy 2,002
12 JDBI 1,938
13 Apache Drill 1,921
14 sqli 1,904
15 SchemaCrawler 1,583
16 pgjdbc 1,455
17 Ebean ORM 1,446
18 clickhouse-java 1,395
19 db-scheduler 1,176
20 kafka-connect-jdbc 1,008
21 spring-boot-data-source-decorator 795
22 OpenAM 743
23 spring-data-relational 737

Sponsored
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com

Did you konow that Java is
the 8th most popular programming language
based on number of metions?