clickhouse-java
pgjdbc-ng
| clickhouse-java | pgjdbc-ng | |
|---|---|---|
| 1 | 1 | |
| 1,370 | 592 | |
| 0.7% | 0.0% | |
| 9.0 | 0.0 | |
| 4 days ago | about 2 months ago | |
| Java | Java | |
| Apache License 2.0 | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
clickhouse-java
-
SQL should be your default choice for data engineering pipelines
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
pgjdbc-ng
-
Postgres query execution: JDBC
The purists will point out that JDBC is not a product but a standard. And indeed, outside of the official postgres driver "PGJDBC" there are other drivers, such as PGJDBC-NG.
What are some alternatives?
dbt-unit-testing - This dbt package contains macros to support unit testing that can be (re)used across dbt projects.
pgjdbc - Postgresql JDBC Driver
jaybird - JDBC driver for Firebird
Hibernate - Hibernate's core Object/Relational Mapping functionality
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
aceql-http-client-jdbc-driver - Java JDBC Driver for easy access of remote SQL databases managed with AceQL HTTP
crate-jdbc - A JDBC driver for CrateDB.
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
jOOQ - jOOQ is the best way to write SQL in Java
java-quickstart - This repository contains code samples for getting started with Java and MariaDB.