Does ADBC DuckDB allow persistence? If not what is the recommended workflow for streaming data?

Questions / Help
,
1

I note that ADBC’s DuckDB driver seems only to support in memory databases. Is this correct?

What are recommended workflows for working with decent-sized timeseries data (say a billion points), with about 100k new points added every day? I prefer a lightweight workflow that does not require postgres with columnar addin or clickhouse, but that still gives columnar like performance.

2

Use ADBC to connect to in memory database. Then ask duckdb to attach to a database file.

This article will give you more info.