JDBCX is a driver that extends JDBC, aiming to enhance data format and compression support, object mapping, advanced type conversion, and multilingual query capabilities. It simplifies federated queries through dynamic embedding and provides a remote bridge for seamless connection to multiple data sources.
Main capabilities:
- Extends JDBC functionality, supporting enhanced data formats and compression.
- Provides object mapping and advanced type conversion.
- Supports dynamic multilingual queries.
- Optional bridge server for federated data source connections.
- Supports encrypted data source credentials, with keys typically stored as encrypted secret files in k8s or docker swarm. Note: if a data source is renamed, its credentials must be re-encrypted.
- Provides a server authentication mechanism.
Usage:
- Can be used as a standard JDBC driver.
- Can be used as a standalone bridge server.
- Can also combine both functionalities.
Applicable scenarios:
- Scenarios requiring federated queries and connections to multiple data sources.
- Environments requiring dynamic multilingual queries.
- JDBC applications requiring enhanced data formats, compression, object mapping, and type conversion.
Limitations:
- The materials do not provide specific installation commands, code examples, pricing information, platform support details, or performance data.
- Test environment information: JDK openjdk 17.0.7, Apache JMeter 5.6.2, ClickHouse 22.8, clickhouse-jdbc v0.4.6; test configuration: 20 concurrent users, 1000 loops, connection pool size 30, initialization SQL and validation query are the same.
