marcboeker / go-duckdb

go-duckdb provides a database/sql driver for the DuckDB database engine.
MIT License
714 stars 106 forks source link

Exposing filesystem interface #200

Open thomascoquet opened 6 months ago

thomascoquet commented 6 months ago

Hello,

First, thank you a lot for your work in building this DuckDB integration! I noticed that DuckDB exposes the filesystem interface in the python integration.

I was wondering if you were thinking of providing a similar feature in the short term? Obvious benefits are the capability to delegate to golang the I/O layer (to implement a LRU block cache for example, or more sophisticated heuristics, or complex authentication schemes).

If not, would you be supportive of a PR about this topic?

Thanks, Thomas

JAicewizard commented 4 months ago

I think you are referring to https://duckdb.org/docs/guides/python/filesystems.html?

go-duckdb is limited to the C api specified in https://duckdb.org/docs/api/c/api, which doesn't expose this as of yet. The python API can do this because they utilize the c++ API under the hood. Lets leave this open for when the C api exposes this feature as well.