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
光 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
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 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 is the best way to write SQL in JavaProject 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's core Object/Relational Mapping functionalityProject mention: JobRunr: A library for background processing in Java | news.ycombinator.com | 2023-05-25
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 - modern SQL based query & persistence for Java / Kotlin / AndroidProject 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
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
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 DriverProject mention: Exciting SQLite Improvements Since 2020 | news.ycombinator.com | 2023-04-29
There's also a fairly popular JDBC driver for SQLite too:
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 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 is a distributed MPP query layer for self describing dataProject 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 is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integrationProject 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
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.
Feedback and ideas for improvement are very welcome.
Free database schema discovery and comprehension toolProject 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 ORMProject mention: loom and database drivers | reddit.com/r/java | 2023-02-18
Postgresql JDBC DriverProject 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
Java client and JDBC driver for ClickHouseProject 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 connector for JDBC-compatible databases
Persistent cluster-friendly scheduler for JavaProject 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 RelationalProject 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 integration with p6spy, datasource-proxy, flexy-pool and spring-cloud-sleuth
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.
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
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
2 projects | dev.to | 21 May 2023
Automatically Document Your Database in Markdown
1 project | dev.to | 23 Apr 2023
HikariCP maximumPoolSize based on AWS ECS number of tasks
1 project | reddit.com/r/SpringBoot | 21 Apr 2023
Is it just me, or does the Spring Framework lead to hard-to-maintain code and confusion with annotations?
7 projects | reddit.com/r/java | 19 Apr 2023
Janet for Mortals
6 projects | news.ycombinator.com | 31 Mar 2023
For daily Java programmers: after almost one decade of Java 8, are streams and lambdas fully adopted by the Java community?
2 projects | reddit.com/r/java | 31 Mar 2023
Can someone tell me a good resource to learn and practice JDBC in java?
1 project | reddit.com/r/javahelp | 30 Mar 2023
A note from our sponsor - ONLYOFFICE
www.onlyoffice.com | 31 May 2023
What are some of the best open-source Jdbc projects in Java? This list will help you:
|23||Simple Flat Mapper||421|