Skip to content

adbcBridge v0.1.4

Latest

Choose a tag to compare

@github-actions github-actions released this 28 Oct 01:41
· 8 commits to main since this release
ca96682

adbcBridge 0.1.4

A second driver: QuestDB over QWP. QuestDB 10 moved its preferred wire to QWP, its own columnar protocol over WebSocket, and asked for ADBC to arrive that way rather than over the PostgreSQL wire. adbc_driver_questdb is that driver: an ADBC 1.1.0 shell over QuestDB's official C client, built as its own CMake project under questdb/ (it needs a Rust toolchain), results passed through as the client's Arrow batches, bulk ingest through the client's Arrow sender with CREATE TABLE from the Arrow schema and a wait for the WAL to apply, catalog from tables() and table_columns(). Measured on one machine against QuestDB 10.1.0: 2,000,000 rows into Arrow in 0.125 s against 1.47 s through the ODBC route. Tested in CI against QuestDB 10.1.0. Docs: docs/getting-started/questdb-qwp.md. (#166)

Windows: prefetch and parallel ingest. The reader's prefetch pipeline and the ingest connection pool were compiled out on Windows; a small threading shim (src/odbc_threads.h, SRWLOCK, CONDITION_VARIABLE, _beginthreadex) brings both to the Windows build, so adbc.odbc.prefetch and ingest_connections behave the same on every platform. (#155)

Connection options set before AdbcConnectionInit are kept. batch_size, prefetch and sqllen_32bit set on a connection before it was initialised were overwritten by the database's defaults at init; they now survive. (#154)

install.sh --drivers bootstraps the open-licence ODBC drivers. One command installs SQLite, PostgreSQL (psqlodbc), MariaDB and ClickHouse ODBC drivers through apt, dnf or Homebrew (ClickHouse from its pinned release tarball, SHA-256 checked), registers them, and prints the connection strings to start from. Verified in CI on Linux. (#156)

Housekeeping: dependency updates across the Java, .NET, Rust and workflow manifests; the GitHub Actions and Maven plugin bumps that Dependabot opened.

Verified before the tag: every CI job on the merge commit, including the new QuestDB job; the Linux C, Python, Go, Rust, .NET and Java suites; Windows x64 and Win32 builds in CI.


What's Changed

  • docs: psqlodbc timestamptz session time zone — quirks and tracker rows by @singhpratech in #115
  • docs: tracker — omniload adbcbridge backend contributed (#362) by @singhpratech in #116
  • docs: tracker — pandas, Polars and conda-forge contributions by @singhpratech in #117
  • docs: tracker — clickhouse-odbc #335 maintainer reply by @singhpratech in #118
  • docs: tracker — clickhouse-odbc #335: fix PR #585 opened, verified on its CI build by @singhpratech in #119
  • docs: tracker — clickhouse-odbc #335 fixed by #585; compatibility row and matrix comment by @singhpratech in #120
  • docs: tracker sweep — omniload #362 approved; clickhouse-odbc #335 row leads with fixed by @singhpratech in #121
  • docs: tracker — omniload #362 merged by @singhpratech in #125
  • docs: tracker — omniload backend shipped in v0.17.0 by @singhpratech in #126
  • README: integrated in omniload since v0.17.0 by @singhpratech in #127
  • README: omniload release named without a three-part version literal by @singhpratech in #128
  • docs: tracker — DuckDB ODBC SQL_DBMS_VER fix sent upstream (duckdb-odbc#523) by @singhpratech in #129
  • docs: tracker — DuckDB ODBC parameter-array fix sent upstream (duckdb-odbc#524) by @singhpratech in #130
  • docs: tracker — fix PRs sent upstream: ArcadeDB #7815, SingleStore #47 and #48 by @singhpratech in #131
  • docs: tracker — DuckDB ODBC SQL_DBMS_VER fix merged upstream (duckdb-odbc#523) by @singhpratech in #132
  • docs: tracker — ArcadeDB transaction-control fix merged upstream (ArcadeData/arcadedb#7815) by @singhpratech in #133
  • upstream status: a merged fix pull request counts as fixed by @singhpratech in #134
  • docs: DuckDB ODBC parameter-array fix merged upstream (duckdb/duckdb-odbc#524) by @singhpratech in #135
  • docs: tracker — three more fixes sent upstream (clickhouse-odbc#586, virtuoso#1477, #1478) by @singhpratech in #136
  • docs: ArcadeDB — DATETIME_MICROS reported as #8090; the NULL BOOLEAN note is stale by @singhpratech in #138
  • docs: link ArcadeDB's published account of the four protocol findings by @singhpratech in #140
  • docs: ArcadeDB #8090 fixed in #8096, verified on the 26.10.1 snapshot by @singhpratech in #141
  • docs: SingleStore SQLGetTypeInfo fix merged upstream (#48) by @singhpratech in #142
  • docs: link omniload's actual release tag, and the install extra by @singhpratech in #143
  • docs: Ignite ODBC parameter-array fix sent upstream (apache/ignite#13610) by @singhpratech in #144
  • docs: SingleStore catalogue NULL fix merged upstream (#47) by @singhpratech in #145
  • docs: publish the compatibility matrix as machine-readable data by @singhpratech in #146
  • docs: clickhouse-odbc SQL_NULL_DATA fix merged upstream (#586) by @singhpratech in #148
  • README: link ArcadeDB's own account of the integration by @singhpratech in #149
  • docs: tracker — fix PRs sent for OpenSearch #101/#102 and ClickHouse's parameter-array half by @singhpratech in #150
  • docs: tracker — questdb#7568 reviewed; DEALLOCATE ALL will succeed but release nothing by @singhpratech in #151
  • docs: clickhouse-odbc #588 merged — both halves of #582 fixed on master by @singhpratech in #153
  • connection: keep reader options set before ConnectionInit by @singhpratech in #154
  • threads: prefetch pipeline and parallel ingest on Windows by @singhpratech in #155
  • build(deps): bump cc from 1.4.4 to 1.5.1 in /rust by @dependabot[bot] in #152
  • build(deps): Bump github.com/apache/arrow-go/v18 from 18.7.0 to 18.8.0 in /go by @dependabot[bot] in #96
  • build(deps): Bump actions/setup-go from 5 to 7 by @dependabot[bot] in #98
  • build(deps): bump actions/setup-java from 4 to 6 by @dependabot[bot] in #123
  • Bump Microsoft.NET.Test.Sdk from 18.9.0 to 18.10.1 by @dependabot[bot] in #124
  • build(deps-dev): Bump org.junit.jupiter:junit-jupiter from 5.11.4 to 6.1.3 in /java by @dependabot[bot] in #97
  • build(deps-dev): Bump org.apache.maven.plugins:maven-resources-plugin from 3.3.1 to 3.5.0 in /java by @dependabot[bot] in #94
  • build(deps-dev): Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.1 to 3.5.1 in /java by @dependabot[bot] in #93
  • install.sh --drivers: bootstrap the open-licence ODBC drivers by @singhpratech in #156
  • QuestDB over QWP: adbc_driver_questdb, a native driver on c-questdb-client by @singhpratech in #166
  • release: 0.1.4 by @singhpratech in #167

Full Changelog: v0.1.3...v0.1.4