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

Top 23 Jdbc Open-Source Projects

  • GitHub repo Apache Spark

    Apache Spark - A unified analytics engine for large-scale data processing

    Project mention: Hi we have a stranege error while moving to spark 3.0.2 | reddit.com/r/apachespark | 2021-05-07

    Checking the code that seems to throw this error (here) this seems to hint at having some form of column name repeated. It may be an internal issue, and that you are reusing a name that is already present in one of the base tables, for instance. It's hard to know with the rewritten query you provide, since you may have rewritten it "correctly", also, the error could actually be propagated from some naming before, since this is a whole plan rewrite stage after all.

  • GitHub repo HikariCP

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

    Project mention: How big should your connection pool be? | news.ycombinator.com | 2021-04-30
  • GitHub repo Hibernate

    Hibernate's core Object/Relational Mapping functionality

    Project mention: Using Value Objects as Aggregate Identifiers with Hibernate | dev.to | 2021-04-27

    This is perfectly possible to do with JPA and Hibernate, but requires some additional work as it goes against the design principles of JPA where you should not have to care about the IDs at all and just work with your entity objects directly. Let's have a look at how. We will be building on the code and principles laid out in my posts about value objects and aggregates so please read those first if you haven't already.

  • GitHub repo jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Windyquery: A non-blocking Python PostgreSQL query builder | news.ycombinator.com | 2021-05-10

    > Given that most query builders allow arbitrary parameters (such as table and column names), you can't actually ensure the query is correct at compile time, regardless of the type of language.

    JOOQ [0] does a great job of providing a type-safe query builder that can guarantee correct queries at compile-time. It indeed also supplies arbitrary strings for names and sql components which will break that guarantee, but apart from that you can extract your databases' schema into typed classes and use those to run your queries.

    I really like it, but it is definately not a replacement for an ORM.

    [0] https://github.com/jOOQ/jOOQ

  • GitHub repo Trino

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

    Project mention: Why hasn't Presto become industry standard? | news.ycombinator.com | 2021-04-01

    * Active-active HA is not really necessary IMO as Trino is designed for low latency interactive queries in general. It can handle longer running batch queries but it gives up fault tolerance to fail fast and you just resubmit the query vs predecessors like Hive, Spark, etc... that handle ETL and long running batch processes efficiently but this adds complexity to the query to checkpoint the work. I could see the need for an active-passive HA to have on deck during a failure. Setting up your own active-passive HA is as simple as putting two coordinators behind a proxy and pointing your workers to the proxy address. Then you basically have the proxy run health checks and flip over in the event of an outage. Here's the issue to track native HA though https://github.com/trinodb/trino/issues/391.

  • GitHub repo requery

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

  • GitHub repo H2

    H2 is an embeddable RDBMS written in Java.

    Project mention: Reliable WebSockets-based pub/sub with Spring Boot | dev.to | 2021-04-09

    Firstly, let's set up a basic Spring Boot application. We can use the Spring Initializr with Spring Data JPA, H2 Database, Lombok added. H2 Database will provide us with a simple database, and Spring Data JPA will allow us to easily interact with it using Hibernate. Lombok will make it easier to write concise and readable classes.

  • GitHub repo Quill

    Compile-time Language Integrated Queries for Scala (by getquill)

    Project mention: Ideas for a Scala 3 MapStruct library? | reddit.com/r/scala | 2021-05-01

    https://getquill.io/#docs (Look under SCHEMA).

  • GitHub repo doobie

    Functional JDBC layer for Scala.

  • GitHub repo sqlite-jdbc

    SQLite JDBC Driver

    Project mention: jOOQ 3.14.9 + SQLite | reddit.com/r/jOOQ | 2021-05-11

    we've been using jOOQ just great with MariaDB and H2 (same app, different "scale" setup), it works like a charm. But tried to put SQLite into "ballbark" as well, using https://github.com/xerial/sqlite-jdbc but jOOQ gives me hard time, at runtime (when SQLite DB is created from the scratch), DDL first command is `create schema PUBLIC` no matter how I parametrize the DDL executoin. Naturally, SQLite chokes on it.

  • GitHub repo p6spy

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

    Project mention: How/Where I can learn the micro level structure of a real world Java web application with sample code and explanation | reddit.com/r/learnjava | 2021-04-26

    But, there is a library called p6spy which implements database logging with a fake JDBC driver that is called before the real JDBC driver, and logs everything which goes through. It's handy if you're not using JPA and not using Spring.

  • GitHub repo Ebean ORM

    Ebean ORM

    Project mention: Stop Using JPA/Hibernate | news.ycombinator.com | 2021-04-11

    I wouldn't call it micro, but https://ebean.io/ is pretty nice.

  • GitHub repo ScalikeJDBC

    A tidy SQL-based DB access library for Scala developers. This library naturally wraps JDBC APIs and provides you easy-to-use APIs.

    Project mention: Query DSL in Scala 3 | reddit.com/r/scala | 2021-02-24
  • GitHub repo jasync-sql

    Java & Kotlin Async DataBase Driver for MySQL and PostgreSQL written in Kotlin

  • GitHub repo examples

    Apache Kafka and Confluent Platform examples and demos (by confluentinc)

    Project mention: Kafka client for Dart | reddit.com/r/dartlang | 2021-05-07

    Digging into this a bit, I guess the fastest way would be to use librdkafka via Dart FFI. It's what Confluent uses in their Node.js example. That way you only have to worry about the FFI parts.

  • GitHub repo SchemaCrawler

    Free database schema discovery and comprehension tool

  • GitHub repo kafka-connect-jdbc

    Kafka Connect connector for JDBC-compatible databases

    Project mention: Data Pipeline between PostgreSQL and Cassandra using Kafka Connect | dev.to | 2021-01-18

    This is different compared to the "polling" technique adopted by the Kafka Connect JDBC connector

  • GitHub repo Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Jailer Data Browser. Navigate through the database by following relationships. | reddit.com/r/SQL | 2021-05-18
  • GitHub repo db-scheduler

    Persistent cluster-friendly scheduler for Java

  • GitHub repo 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

  • GitHub repo Doma 2

    DAO oriented database mapping framework for Java 8+

  • GitHub repo jaydebeapi

    JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

    Project mention: Bulk load Pandas DataFrames into SQL databases using Jaydebeapi | dev.to | 2021-05-09

    Loading Pandas DataFrames into SQL databases of all names is a common task between all developers working on building data pipelines for their environments or trying to automate ETL jobs generally. And for that, Pandas DataFrame class has the built-in method pandas.DataFrame.to_sql that allows to do so very quickly, for SQLite and all the databases supported by SQLAlchemy library, and when it comes to those who doesn’t have a good support by it ( in my case was IBM DB2 ), developers find themselves forced to think twice for some work around in order to get the job done. Jaydebeapi introduces himself as a good alternative, and it’s particularly seen thus by all developers coming from a Java background and having some familiarities of working with JDBC API to access the database. Let’s start first by creating the database connection. for that reason I will be creating a simple function that takes in params all the informations required and it will give a connection to DB2 as a return.

  • GitHub repo Anorm

    The Anorm database library

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 2021-05-18.


What are some of the best open-source Jdbc projects? This list will help you:

Project Stars
1 Apache Spark 29,645
2 HikariCP 14,984
3 Hibernate 4,617
4 jOOQ 4,374
5 Trino 3,295
6 requery 3,049
7 H2 2,798
8 Quill 1,859
9 doobie 1,808
10 sqlite-jdbc 1,777
11 p6spy 1,438
12 Ebean ORM 1,192
13 ScalikeJDBC 1,148
14 jasync-sql 1,126
15 examples 1,104
16 SchemaCrawler 1,053
17 kafka-connect-jdbc 725
18 Jailer 587
19 db-scheduler 388
20 Simple Flat Mapper 375
21 Doma 2 267
22 jaydebeapi 253
23 Anorm 209