Connectorx

ConnectorX

Features

* Add experimental support on federated query (support PostgreSQL only) 280
* BigQuery support experimental -> stable 152
* Upgrade rust version to `nightly-2022-04-17`

Bug Fix
* Arrow2 add blob 261
* Mssql datetime fix 263
* Add Mssql encryption option 265
* Fix Mssql count query construction for queries with `OFFSET`
* Add binaryfloat and binarydouble to Oracle 273

ConnectorX

Features

* Build wheel for m1 machine through cross compile 238
* Support client authentication on postgres 222
* Expose `partition_sql` and `get_meta` for Python API
* Parse connection url's scheme as the substring before '+', to compatible with possible `sqlalchemy` user's input

Bug Fix
* Sqlite windows path error 245
* Oracle convert Number(0,0) to float for round(x, y) 227

Bug Fix
* Fixing deallocating None bug 201
* Clickhouse support on new version 165
* Shrink array before return for arrow2 to reduce memory usage when result is small 196
* Fix Oracle port error 209

Others
* Improve Oracle performance by enlarging array size using prepared statement 127
* Upgrade arrow2 to 0.9 221
* Add Postgres Json, TimestampTz support to arrow2 235 229
* Clean up python dependencies (remove ones for benchmarking)

Features
* Add Google BigQuery as source https://github.com/sfu-db/connector-x/issues/152 - need benchmark and more tests
* Add windows trust_connection for mssql https://github.com/sfu-db/connector-x/discussions/145
* Support Postgres HStore (only for cursor protocol) https://github.com/sfu-db/connector-x/issues/174

Others
* Investigate SQLite in-memory database https://github.com/sfu-db/connector-x/issues/172
* Add redshift to connection uri automatically use cursor protocol https://github.com/sfu-db/connector-x/pull/187
* Test on mariadb https://github.com/sfu-db/connector-x/issues/193
* Test on azure sql database

Features
* Stream write to destination https://github.com/sfu-db/connector-x/pull/147
* Support CTE https://github.com/sfu-db/connector-x/pull/161
* Add money type support in mssql https://github.com/sfu-db/connector-x/issues/141
* Add support of converting bytea in postgres arrow https://github.com/sfu-db/connector-x/issues/148

Bug Fixes
* Test each feature gate https://github.com/sfu-db/connector-x/issues/139
* Support Python 3.10 https://github.com/sfu-db/connector-x/issues/157
* Adding instance name to connect mssql https://github.com/sfu-db/connector-x/issues/140
* Support multiple integer types when for count query in postgres https://github.com/sfu-db/connector-x/pull/153
* Support unsigned for mysql: https://github.com/sfu-db/connector-x/issues/163
* Fix issue when limit > count: https://github.com/sfu-db/connector-x/issues/166

Other Changes
* Add turbodbc in benchmark https://github.com/sfu-db/connector-x/issues/124
* Update polars dependency https://github.com/sfu-db/connector-x/pull/154