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. Learn more →
Top 23 Jdbc Open-Source Projects
-
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.
-
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
-
hertzbeat
Apache HertzBeat(incubating) is a real-time monitoring system with agentless, performance cluster, prometheus-compatible, custom monitoring and status page building capabilities.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
linkis
Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.
-
p6spy
P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.
-
kyuubi
Apache Kyuubi is a distributed and multi-tenant gateway to provide serverless SQL on data warehouses and lakehouses.
-
JDBI
The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Java virtual threads caused a deadlock in TPC-C for PostgreSQL | news.ycombinator.com | 2024-01-15Looks like HikariCP is also awaiting fixes for this https://github.com/brettwooldridge/HikariCP/pull/2055
Project mention: Trino: Fast distributed SQL query engine for big data analytics | news.ycombinator.com | 2024-03-19
> 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/
Project mention: Apache HertzBeat(incubating) Another Prometheus, Zabbix | news.ycombinator.com | 2024-04-17It seems that the deleted post cannot be reposted due to mistaken operation. Can the administrator help to restore the deleted post? Thank you.
Hi,
This is an open-source project that I have been developing full-time for over two years.
Name HertzBeat, in terms of functionality, it is similar to Prometheus and Zabbix.
Recently, the project has just entered the Apache Foundation Incubator.
Here, I want to share it with HN readers.
In a word, it is an easy-to-use, open source, real-time monitoring system with agentless, high performance cluster, prometheus-compatible, offers powerful custom monitoring and status page building capabilities.
github: https://github.com/apache/hertzbeat
I hope this product is helpful and any feedback (even negative) would bring me joy.
Project mention: H2 Database – CVE getting flagged by automated scans | news.ycombinator.com | 2023-07-18The URL should point to a particular comment, but HN removes fragments: https://github.com/h2database/h2database/issues/3686#issueco...
Project mention: Show HN: Jailer is a unique open-source database client tool | news.ycombinator.com | 2024-03-14
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. :)
https://github.com/zio/zio-quill
This library does exactly what you prescribe. Pretty sure under the hood it's using macros with string templates
Project mention: Permazen: Language-natural persistence to KV stores | news.ycombinator.com | 2023-09-19While 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.
Project mention: Git Query Language (GQL) Aggregation Functions, Groups, Alias | /r/ProgrammingLanguages | 2023-06-30Also are you familiar with apache drill . The idea is to put an SQL interpreter in front of any kind of database just like you are doing for git here.
Project mention: Java virtual threads caused a deadlock in TPC-C for PostgreSQL | news.ycombinator.com | 2024-01-15Was curious what it is "jasync". And man it hurts me to see documentation like this (when compared to classic javadocs)
https://github.com/jasync-sql/jasync-sql/wiki/API-Overview
From project WIKI (https://github.com/jasync-sql/jasync-sql/wiki)
Project mention: Password may not contain: select, insert, update, delete, drop | news.ycombinator.com | 2024-01-21The 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
Jdbc related posts
- Password may not contain: select, insert, update, delete, drop
- Java virtual threads caused a deadlock in TPC-C for PostgreSQL
- Contributing to a JavaScript project!
- About Pool Sizing
- Everything People Don't Get About CVEs
- H2 Database – CVE getting flagged by automated scans
- Como desenvolvi um backend web em Clojure
-
A note from our sponsor - InfluxDB
www.influxdata.com | 26 Apr 2024
Index
What are some of the best open-source Jdbc projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Apache Spark | 38,320 |
2 | HikariCP | 19,395 |
3 | Trino | 9,552 |
4 | jOOQ | 5,882 |
5 | Hibernate | 5,745 |
6 | hertzbeat | 4,730 |
7 | H2 | 4,048 |
8 | linkis | 3,227 |
9 | requery | 3,132 |
10 | Jailer | 2,705 |
11 | sqlite-jdbc | 2,674 |
12 | Quill | 2,136 |
13 | doobie | 2,118 |
14 | p6spy | 1,972 |
15 | kyuubi | 1,928 |
16 | sqli | 1,905 |
17 | JDBI | 1,901 |
18 | Apache Drill | 1,894 |
19 | examples | 1,845 |
20 | jasync-sql | 1,619 |
21 | SchemaCrawler | 1,548 |
22 | Ebean ORM | 1,429 |
23 | pgjdbc | 1,414 |
Sponsored