Connect ODBC Databases to DuckDB(github.com)
github.com
Connect ODBC Databases to DuckDB
https://github.com/rupurt/odbc-scanner-duckdb-extension
8 comments
I recommend to model after ClickHouse ODBC integration: https://clickhouse.com/docs/en/sql-reference/table-functions...
It already has the items from your list, like the predicate push-down. Plus, it is memory-safe, thanks to clickhouse-odbc-bridge which runs as a separate process and does not poison the main server process's address space.
PS. I'm one of developers of the ODBC integration.
It already has the items from your list, like the predicate push-down. Plus, it is memory-safe, thanks to clickhouse-odbc-bridge which runs as a separate process and does not poison the main server process's address space.
PS. I'm one of developers of the ODBC integration.
Can you do ADBC next? ;)
https://arrow.apache.org/docs/format/ADBC.html
https://arrow.apache.org/docs/format/ADBC.html
Dependency on unixODBC? Wondering if this could used on Windows.
Definitely. I will need to link against the ODBC library Windows ships with. I don't have a Windows machine so wasn't testing against it.
It's now on the list of improvements!
It's now on the list of improvements!
It supports fetching rowsets in batches to minimize network overhead and defaults to the default DuckDB vector size of 2048.
I've tested it against the IBM DB2 & Postgres ODBC drivers and will continue to test and add support for all major databases. If you've got one you'd like to see let me know in the comments.
I've got plenty of improvements in the pipeline including: