CHANGELOG.md

ADBC Changelog

ADBC Libraries 0.1.0 (2022-12-25)

Fix

• python: make package names consistent (#258)
• c/driver_manager: accept connection options pre-Init (#230)
• c/driver_manager,c/driver/postgres: fix version inference from Git tags (#184)
• c/driver/postgres: fix duplicate symbols; add note about PKG_CONFIG_PATH (#169)
• c/driver/postgres: fix wheel builds (#161)
• c/validation: validate metadata more fully (#142)
• c/validation: free schema in partitioning test (#141)
• c/validation: cast to avoid MSVC warning (#135)

Feat

• c/driver_manager: allow Arrow data as parameters in DBAPI layer (#245)
• c/driver/postgres,c/driver/sqlite: add pkg-config/CMake definitions (#231)
• c/driver/sqlite: add Python SQLite driver bindings (#201)
• c/driver/sqlite: port SQLite driver to nanoarrow (#196)
• c/driver_manager: expose ADBC functionality in DBAPI layer (#143)
• c/driver_manager: don't require ConnectionGetInfo (#150)

Refactor

• python: allow overriding package version (#236)
• c: build Googletest if needed (#199)
• c/driver_manager: remove unnecessary libarrow dependency (#194)
• c: derive version components from base version (#178)
• java/driver/jdbc: use upstream JDBC utilities (#167)
• c/validation: split out test utilities (#151)

ADBC Libraries 0.2.0 (2023-02-08)

Fix

• go/adbc/driver/flightsql: deal with catalogless schemas (#422)
• dev/release: correct the name of the Go tag (#415)
• go/adbc/driver/flightsql: guard against inconsistent schemas (#409)
• go/adbc/driver/driver/flightsql: use libc allocator (#407)
• ci: make sure Conda packages are properly noarch (#399)
• ci: don't fail Anaconda upload when packages already exist (#398)
• go/adbc/sqldriver: allow equals signs in DSN values (#382)
• c/driver/flightsql: set GOARCH appropriately on macOS (#374)
• ci: don't make jobs depend on each other (#372)
• go/adbc/driver/flightsql: bind ExecuteUpdate, BindStream (#367)
• go/adbc/driver/flightsql: heap-allocate Go handles (#369)
• go/adbc/driver/flightsql: implement RecordReader.Err (#363)
• go/adbc/flightsql: enable Prepare (#362)
• go/adbc/driver/flightsql: connect to URI specified in FlightEndpoint (#361)
• go/adbc/driver/flightsql: cnxn should implement PostInitOptions (#357)
• ci: revert GEM_HOME for RubyGems install test (#351)
• dev/release: Update install location for RubyGems and Bundler (#345)
• python: add driver -> driver manager dependency (#312)
• c/driver/postgresql: define ntohll etc for macOS 10.9 (#305)

Feat

• go/sqldriver: implement database/sql/driver.RowsColumnTypeDatabaseTypeName (#392)
• go/sqldriver: convert Arrow times and dates to Golang time.Time (#393)
• go/adbc/driver/flightsql: bump max incoming message size (#402)
• go/adbc/driver/flightsql: add timeout option handling (#390)
• go/adbc/driver/flightsql: implement GetObjects (#383)
• go/adbc/driver/flightsql: add auth and generic header options (#387)
• go/adbc/driver/flightsql: change parallelization of DoGet (#386)
• go/adbc/driver/flightsql,go/adbc/sqldriver: small improvements (#384)
• go/adbc/driver/flightsql: implement more connection options (#381)
• python/adbc_driver_manager: add more sanity checking (#370)
• go/adbc/driver/pkg/cmake: cmake build for Go shared library drivers (#356)
• python: add Flight SQL driver using Go library (#355)
• go/adbc/driver/flightsql: Build C shared lib for flightsql adbc driver (#347)
• c/driver/postgresql: expand type support (#352)
• c/driver/postgresql: add VARCHAR type support
• go/adbc/driver/flightsql: Native Golang ADBC Flight SQL driver (#322)

ADBC Libraries 0.3.0 (2023-03-16)

Fix

• ci: use conda git in verification (#518)
• python/adbc_driver_manager: properly map error codes (#510)
• go/adbc/driver/flightsql: properly map error codes (#509)
• python/adbc_driver_manager: expose set_options (#495)
• go/adbc/driver/flightsql: send headers in statement close (#494)
• go/adbc/driver/flightsql: fix stream timeout interceptor (#490)
• go/adbc/driver/flightsql: don't require GetSqlInfo support (#485)
• c/driver/sqlite: fix nullability of GetInfo schema (#457)
• python/adbc_driver_manager: fix Cursor.adbc_read_partition (#452)
• r/adbcdrivermanager: Check that bootstrap.R exists before trying to run it (#437)

Feat

• python: add enums for common options (#513)
• go/adbc/driver/flightsql: support domain sockets (#516)
• python/adbc_driver_manager: add del for resources (#498)
• go/adbc/driver/flightsql: add user-agent for driver (#497)
• go/adbc/sqldriver: add simple FlightSQL database/sql driver wrapper (#480)
• java/driver/jdbc: expose constraints in GetObjects (#474)
• r/adbcsqlite: Package SQLite driver for R (#463)
• go/adbc/driver/flightsql: add transaction and substrait support (#467)
• r: Add R Driver Manager (#365)

ADBC Libraries 0.4.0 (2023-05-08)

Fix

• ruby: Free an imported reader in Statement#execute explicitly (#665)
• go/adbc/driver/snowflake: Skip shared dbs that have no data or we can't access (#656)
• c/validation: correct indexing in TestMetadataGetObjectsTables (#649)
• c/driver: hide symbols when buildling Go Flight SQL and Snowflake drivers (#640)
• go/adbc/sqldriver: do not swallow array.RecordReader error (#641)
• go/adbc/driver/snowflake: some more cleanup (#637)
• c/driver/postgresql: properly handle NULLs (#626)
• java: require supplying BufferAllocator to create drivers (#622)
• go/adbc/driver/flightsql: use updated authorization header from server (#594)
• c/driver/sqlite,c/validation: Ensure float/double values are not truncated on bind or select (#585)
• java/driver/jdbc: check for existence when getting table schema (#567)
• java/driver/jdbc: clean up buffer leaks (#533)
• python/adbc_driver_manager: fix uncaught exception in del (#556)

Feat

• r/adbcsnowflake: Package Snowflake driver for R (#638)
• c/driver/postgresql: implement GetTableSchema (#577)
• python/adbc_driver_snowflake: package the Snowflake driver (#633)
• go/adbc/driver: Adbc Driver for Snowflake (#586)
• glib: add gadbc_connection_get_objects() (#617)
• java/driver/jdbc: support catalogPattern in getObjects (#613)
• java/driver/jdbc: create AdbcDatabase from javax.sql.DataSource (#607)
• glib: add support for no AdbcError error case (#604)
• ruby: add support for statement.ingest("table", table) (#601)
• glib: add gadbc_connection_set_isolation_level() (#590)
• glib: add gadbc_connection_set_read_only() (#589)
• java/driver/flight-sql: allow passing BufferAllocator (#564)
• glib: add transaction related connection bindings (#579)
• r/adbdpostgresql: Package postgresql driver for R (#511)
• glib: add gadbc_connection_get_table_schema() (#576)
• glib: add gadbc_connection_get_info() (#571)
• glib: add gadbc_connection_get_table_types() (#560)
• python/adbc_driver_manager: expose StatementGetParameterSchema (#555)
• glib: add gadbc_statement_bind_stream() (#536)
• docs: maintain relative URL when switching versions (#531)
• rpm: add adbc-driver-flightsql (#526)
• glib: add gadbc_statement_bind() and ingest related bindings (#528)
• deb: add libadbc-driver-flightsql (#521)

Refactor

• c: fix some build warnings (#654)
• c/driver/postgresql: Factor out COPY reader and test it independently (#636)
• c/driver/postgresql: Remove utils duplication (#628)
• c/driver/common: Variadic arguments for StringBuilderAppend (#587)
• c: merge CMake projects (#597)
• c/driver/postgresql: Factor out Postgres type abstraction and test it independently of the driver (#573)
• c/driver/shared: created shared util library for drivers (#582)

ADBC Libraries 0.5.0 (2023-06-15)

Feat

• c/driver/postgresql: Support INT16 Postgres Ingest (#800)
• python/adbc_driver_manager: add autocommit, executescript (#778)
• c/driver/postgresql,java: ensure time/date type support (#774)
• c/driver/postgresql: Implement Foreign Key information for GetObjects (#757)
• c/driver/postgresql: add timestamp types support (#758)
• c/driver/postgresql: Implement PRIMARY KEY in GetObjects ALL depth (#725)
• csharp: adding C# functionality (#697)
• go/adbc/pkg: catch panics at interface boundary (#730)
• java/driver/jdbc: add hooks for JDBC type system mapping (#722)
• c/driver/postgresql: Implement GetObjects for columns (#723)
• c/driver/postgresql: Implement GetObjects for tables (#712)
• rust: define the rust adbc api (#478)
• c/driver/postgresql: handle non-SELECT statements (#707)
• c/driver/postgresql: Implement GetObjectsDbSchemas for Postgres (#679)
• r: Add read_adbc(), write_adbc(), and execute_adbc() convenience functions (#706)
• r: Improve error communication (#703)
• r: Add scoping + lifecycle helpers (#693)
• r: Add driver logging utility (#694)
• c/driver/postgresql: implement GetObjectsSchema (#676)
• go/adbc/driver/snowflake: Update gosnowflake dep (#674)
• c/driver/postgresql: Implement Postgres Get table types (#668)
• dev/release: Retry on apt failure in the RC verification script (#672)
• c/driver/postgresql: Implement Postgres GetInfo (#658)

Fix

• go/adbc/pkg: allow ConnectionSetOptions before Init (#789)
• c/driver/sqlite: support PRIMARY KEY constraint in GetObjects (#777)
• c/driver/common: Prevent UB in GetObjects with NULL argument (#786)
• c: Fix destructor mem leaks (#785)
• java/driver/jdbc: return timestamps as MICROSECOND always (#771)
• go/adbc: don't crash on duplicate column names (#766)
• c/driver/postgresql: Fix ASAN detected leaks (#768)
• c/driver/sqlite: Fix parameter binding when inferring types and when retrieving (#742)
• python/adbc_driver_manager: fix fetching queries with empty results (#744)
• go/adbc/drivermgr: go doesn't package symbolic links (#709)
• r: Don't save database/connection/statement options at the R level (#708)
• go/adbc: Update snowflake dep (#705)
• c/driver/snowflake: fix validation test failures (#677)
• dev/release: Fix BINARY_DIR prepare condition in the verify RC script (#670)
• c/driver/postgresql: Prevent SQL Injection in GetTableSchema (#657)

Refactor

• c/driver/postgresql: More postgres test simplification (#784)
• c/driver/postgresql: Use AdbcGetInfoData structure (#769)
• csharp: Cleanup C API (#749)
• go/adbc/driver/flightsql: factor out server-based tests (#763)
• java/driver/jdbc: add JdbcQuirks for backend config (#748)
• r/adbcdrivermanager: Early exit (#740)
• c/driver/postgresql: Use Prepared Statement in Result Helper (#714)
• c/driver/postgresql: Postgres class helper for GetObjects (#711)
• c: Use ArrowArrayViewListChildOffset from nanoarrow (#696)
• c/driver/postgresql: implement InputIterator for ResultHelper (#683)
• c: Simplify CI testing for cpp (#610)

Perf

• go/adbc/driver/flightsql: filter by schema in getObjectsTables (#726)

ADBC Libraries 0.6.0 (2023-08-23)

Feat

• python/adbc_driver_manager: add fetch_record_batch (#989)
• c/driver: Date32 support (#948)
• c/driver/postgresql: Interval support (#908)
• go/adbc/driver/flightsql: add context to gRPC errors (#921)
• c/driver/sqlite: SQLite timestamp write support (#897)
• c/driver/postgresql: Handle NUMERIC type by converting to string (#883)
• python/adbc_driver_postgresql: add PostgreSQL options enum (#886)
• c/driver/postgresql: TimestampTz write (#868)
• c/driver/postgresql: Implement streaming/chunked output (#870)
• c/driver/postgresql: Timestamp write support (#861)
• c/driver_manager,go/adbc,python: trim down error messages (#866)
• c/driver/postgresql: Int8 support (#858)
• c/driver/postgresql: Better type error messages (#860)

Fix

• go/adbc/driver/flightsql: Have GetTableSchema check for table name match instead of the first schema it receives (#980)
• r: Ensure that info_codes are coerced to integer (#986)
• go/adbc/sqldriver: fix handling of decimal types (#970)
• c/driver/postgresql: Fix segfault associated with uninitialized copy_reader_ (#964)
• c/driver/sqlite: add table types by default from arrow types (#955)
• csharp: include GetTableTypes and GetTableSchema call for .NET 4.7.2 (#950)
• csharp: include GetInfo and GetObjects call for .NET 4.7.2 (#945)
• c/driver/sqlite: Wrap bulk ingests in a single begin/commit txn (#910)
• csharp: fix C api to work under .NET 4.7.2 (#931)
• python/adbc_driver_snowflake: allow connecting without URI (#923)
• go/adbc/pkg: export Adbc* symbols on Windows (#916)
• go/adbc/driver/snowflake: handle non-arrow result sets (#909)
• c/driver/sqlite: fix escaping of sqlite TABLE CREATE columns (#906)
• go/adbc/pkg: follow CGO rules properly (#902)
• go/adbc/driver/snowflake: Fix integration tests by fixing timestamp handling (#889)
• go/adbc/driver/snowflake: fix failing integration tests (#888)
• c/validation: Fix ASAN-detected leak (#879)
• go/adbc: fix crash on map type (#854)
• go/adbc/driver/snowflake: handle result sets without Arrow data (#864)

Perf

• go/adbc/driver/snowflake: Implement concurrency limit (#974)

Refactor

• c: Vendor portable-snippets for overflow checks (#951)
• c/driver/postgresql: Use ArrowArrayViewGetIntervalUnsafe from nanoarrow (#957)
• c/driver/postgresql: Simplify current database querying (#880)

ADBC Libraries 0.7.0 (2023-09-20)

Feat

• r: Add quoting/escaping generics (#1083)
• r: Implement temporary table option in R driver manager (#1084)
• python/adbc_driver_flightsql: add adbc.flight.sql.client_option.authority to DatabaseOptions (#1069)
• go/adbc/driver/snowflake: improve XDBC support (#1034)
• go/adbc/driver/flightsql: add adbc.flight.sql.client_option.authority (#1060)
• c/driver: support ingesting into temporary tables (#1057)
• c/driver: support target catalog/schema for ingestion (#1056)
• go: add basic driver logging (#1048)
• c/driver/postgresql: Support ingesting LARGE_STRING types (#1050)
• c/driver/postgresql: Duration support (#907)
• ADBC API revision 1.1.0 (#971)

Fix

• java/driver/flight-sql: fix leak in InfoMetadataBuilder (#1070)
• c/driver/postgresql: Fix overflow in statement.cc (#1072)
• r/adbcdrivermanager: Ensure nullable arguments adbc_connection_get_objects() can be specified (#1032)
• c/driver/sqlite: Escape table name in sqlite GetTableSchema (#1036)
• c/driver: return NOT_FOUND for GetTableSchema (#1026)
• c/driver_manager: fix crash when error is null (#1029)
• c/driver/postgresql: suppress console spam (#1027)
• c/driver/sqlite: escape table names in INSERT, too (#1003)
• go/adbc/driver/snowflake: properly handle time fields (#1021)
• r/adbcdrivermanager: Make adbc_xptr_is_valid() return FALSE for external pointer to NULL (#1007)
• go/adbc: don't include NUL in error messages (#998)

Refactor

• c/driver/postgresql: hardcode overflow checks (#1051)

ADBC Libraries 0.8.0 (2023-11-03)

Feat

• c/driver/sqlite: enable extension loading (#1162)
• csharp: Add support for SqlDecimal (#1241)
• go/adbc/driver/snowflake: enable passing private key for JWT via string and not file (#1207)
• c/driver/sqlite: Support binding dictionary-encoded string and binary types (#1224)
• c/driver/sqlite: Support BLOB in result sets for SQLite (#1223)
• csharp/drivers/bigquery: add BigQuery ADBC driver (#1192)
• go/adbc/driver/snowflake: support PEM decoding JWT private keys (#1199)
• r/adbcdrivermanager: Implement missing function mappings (#1206)
• c/driver/postgresql: Use COPY for writes (#1093)
• c/driver/postgresql: INSERT benchmark for postgres (#1189)
• c/driver/postgresql: Binary COPY Writer (#1181)
• c/driver/postgresql: INTERVAL COPY Writer (#1184)
• c/driver/postgresql: TIMESTAMP COPY Writer (#1185)
• c/driver/postgresql: DATE32 Support for COPY Writer (#1182)
• c/driver/postgresql: INT8 Support in COPY Writer (#1176)
• c/driver/postgresql: Floating point types for Copy Writer (#1170)
• c/driver/postgresql: String/Large String COPY Writers (#1172)
• csharp: Add ADO.NET client; tests for C# to interop with the Snowflake Go driver (#1031)
• c/driver/postgresql,c/driver/sqlite: Implement FOREIGN KEY constraints (#1099)
• go/adbc/driver/flightsql: log new connections (#1146)
• c/driver/postgresql: add integral COPY writers (#1130)
• c/driver/postgresql: Inital COPY Writer design (#1110)
• c/driver/postgresql,c/driver/sqlite: implement BOOL support in drivers (#1091)

Fix

• c/driver: be explicit about columns in ingestion (#1238)
• go/adbc/driver/flightsql: take metadata lock for safety (#1228)
• c/driver/sqlite: Provide # of rows affected for non-SELECT statements instead of 0 (#1179)
• r/adbcpostgresql: Use libpq provided by Rtools for R 4.2 and R 4.3 (#1218)
• r/adbcsqlite: Fix incomplete cleanup in adbcsqlite tests (#1219)
• c/driver/postgresql: Allow ctest to run benchmark (#1203)
• r/adbcsnowflake: Add arrow as check dependency for adbcsnowflake (#1208)
• r/adbcdrivermanager: Improve handling of integer and character list inputs (#1205)
• r: Build with __USE_MINGW_ANSI_STDIO to enable use of lld in format strings (#1180)
• c/driver/postgresql: only clear schema option if needed (#1174)
• c/driver/postgresql: Support trailing semicolon(s) for queries inside COPY statements (#1171)
• c/driver/common: Object name matching handles shared prefix case correctly (#1168)
• r/adbcdrivermanager: Fix tests to avoid moving an external pointer with dependents (#1167)
• r/adbcsnowflake: Don't use test snowflake query that returns a decimal type (#1164)
• r/adbcdrivermanager: Add format method for adbc_xptr (#1165)
• r/adbcdrivermanager: Use ADBC_VERSION_1_1_0 to initialize drivers internally (#1163)
• go/adbc/driver/snowflake: add useHighPrecision option for decimal vs int64 (#1160)
• c/driver/postgresql: reset transaction after rollback (#1159)
• go/adbc/driver/snowflake: proper timezone for timestamp_ltz (#1155)
• c/driver_manager: Include cerrno in driver manager (#1137)
• r/adbcdrivermanager: Fix valgrind errors identified by CRAN 0.7.0 submission (#1136)
• go/adbc/driver/snowflake: default SetOption to StatusNotImplemented (#1120)
• go/adbc/pkg: support Windows in Makefile (#1114)
• go/adbc/driver/snowflake: prevent database options from getting overwritten (#1097)
• python/adbc_driver_manager: allow non-indexable sequences in executemany (#1094)

Refactor

• r: Improve testing for ADBC 1.1 features in R bindings (#1214)
• c/driver/postgresql: Macro for benchmark return (#1202)
• c/driver/postgresql: Refactor COPY Writer NULL handling (#1175)
• c/driver/postgresql: Have Copy Writer manage its own buffer (#1148)
• go/adbc/driver: add driver framework (#1081)
• c/driver/postgresql: remove unnecessary destructor (#1134)
• c/driver/postgresql: refactor Handle class (#1132)

ADBC Libraries 0.9.0 (2024-01-03)

Fix

• go/adbc/driver/snowflake: Removing SQL injection to get table name with special character for getObjectsTables (#1338)
• dev/release: install openssl explicitly for R CMD check (#1427)
• java/driver/jdbc: fix connection leak in JdbcDataSourceDatabase constructor (#1418)
• c/driver/postgresql: fix ingest with multiple batches (#1393)
• c/driver/postgresql: check for underflow (#1389)
• c/driver/postgresql: support catalog arg of GetTableSchema (#1387)
• go/adbc/sqldriver: Fix nil pointer panics for query parameters (#1342)
• go/adbc/driver/snowflake: Made GetObjects case insensitive (#1328)
• csharp/src/Drivers/BigQuery: Fix failure when returning multiple table schemas from BigQuery (#1336)
• csharp/src/Drivers/BigQuery: Fix failure when returning empty schema data from BigQuery (#1330)
• go/adbc/driver/snowflake: Fix race condition in record reader (#1297)
• go/adbc/driver/snowflake: fix XDBC support when using high precision (#1311)
• csharp/src/Drivers/BigQuery: Add JSON support (#1308)
• glib: Vala's vapi's name should be same as pkg-config package (#1298)
• csharp/adbc: Remove xunit as a dependency from Apache.Arrow.Adbc.dll (#1295)
• csharp/client/adbcconnection: reset AdbcStatement on dispose (#1289)
• csharp/drivers/bigquery: add back support for Struct and List arrays (#1282)
• csharp: fix timestamp case in AdbcStatement.GetValue (#1279)
• go/adbc/driver/snowflake: handling of integer values sent for NUMBER columns (#1267)
• glib: add missing "pkg-config --modversion arrow-glib" result check (#1266)
• dev/release: install missing protobuf for Python test (#1264)
• r/adbcdrivermanager: Ensure test driver includes null terminator when fetching string option (#1258)
• r/adbcsqlite: Allow sqlite driver to link against sqlite3 that does not contain sqlite3_load_extension() (#1259)

Feat

• c/driver/postgresql: Support for writing DECIMAL types (#1288)
• c/driver/postgresql: set rows_affected appropriately (#1384)
• r: Reference count child objects (#1334)
• python/adbc_driver_manager: export handles through python Arrow Capsule interface (#1346)
• csharp/Client: Implement support for primary schema collections (#1317)
• go/adbc/drivermgr: Implement Remaining CGO Wrapper Methods that are Supported by SQLite Driver (#1304)
• go/adbc/drivermgr: Implement GetObjects for CGO Wrapper (#1290)
• csharp: Translate time to either TimeSpan or TimeOnly (#1293)
• glib: add Vala VAPI for GADBC (#1152)
• csharp/test: Add support for data without need for tables (#1287)
• c/driver/postgresql: Accept bulk ingest of dictionary-encoded strings/binary (#1275)
• r/adbcdrivermanager: Add support for setting option as logical (#1270)
• go/adbc/driver/snowflake: add support for ExecuteSchema (#1262)

Perf

• go/adbc/driver/snowflake: GetObjects call is slow even when filters are provided (#1285)

Refactor

• r/adbcdrivermanager: Use C++ base driver to implement test drivers (#1269)