Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises Learn more →
Top 23 Java Jdbc Projects
-
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-27There 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
-
Some of our applications already use DB schema-based code generation too (e.g. jOOQ), which makes using the DB-defined enum quite easy.
-
Project mention: JobRunr: A library for background processing in Java | news.ycombinator.com | 2023-05-25
-
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.
-
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.
-
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.
-
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: 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 -
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.
-
Grab the Python script of "markdown.py" from SchemaCrawler's GitHub repository, and save it in your local directory.
-
-
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
-
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
-
-
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
-
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
-
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.
Java Jdbc related posts
- Integration Tests for N + 1 problem in Java
- Automatically Document Your Database in Markdown
- HikariCP maximumPoolSize based on AWS ECS number of tasks
- Is it just me, or does the Spring Framework lead to hard-to-maintain code and confusion with annotations?
- Janet for Mortals
- For daily Java programmers: after almost one decade of Java 8, are streams and lambdas fully adopted by the Java community?
- Can someone tell me a good resource to learn and practice JDBC in java?
-
A note from our sponsor - ONLYOFFICE
www.onlyoffice.com | 31 May 2023
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 |