Hello! I was wondering if anyone is using DuckDB with Racket. I know the db library works with SQLite, but I was interesting in trying out testing out DuckDB instead, and I haven't been able to find any references online to anyone using DuckDB with Racket. If someone out there is using it, would it be possible to give an overview of how you were able to set that up, please?
Thanks!
It looks like DuckDB supports access through ODBC: ODBC API Overview – DuckDB If you install and configure the necessary DuckDB ODBC components, you should be able to use odbc-connect and related functions from the db library. You may find the ODBC-related notes for the db library helpful if you have problems.
If you want more direct integration, you would ultimately implement a duckdb-connect function for db. If it's correct that DuckDB provides an SQLite-compatible C API (but the link at Overview – DuckDB seems to be broken), the fact that db internally uses an object-oriented design may make that relatively easy to define as a variant of the existing SQLite support.
Thank you! That's great information.