This is great for analytical workloads. I work with financial time series data (Japanese company filings) and have been using BigQuery with in-memory caching for the hot path. Curious whether DuckDB extensions like this could replace the BQ dependency for smaller datasets — the cold start + query cost model of serverless warehouses can be painful for API-serving use cases.
As an aside, there's now Lance data format support in DuckDB through their extension. It has Lance's vector search support available among other things:
I just noticed this, and your post, and haven't yet checked neither (sorry). I'm however doing some vector search benchmarking soon, with DuckDB's options alongside others. So your work caught my attention here.
https://github.com/lance-format/lance-duckdb/tree/main?tab=r...
I just noticed this, and your post, and haven't yet checked neither (sorry). I'm however doing some vector search benchmarking soon, with DuckDB's options alongside others. So your work caught my attention here.
[1] https://arxiv.org/abs/2405.12497