duckdb is up there alongside redis in my top list of amazing open source technologies. the aws extensions will help w/ ec2 boxes operating on iam roles, and it looks like there are a lot of other quality of life improvements around performance and size of data. stoked for this release!

i'm excited about duckdb and have used it for a few "what-if?" projects here and there but keep getting bitten by the file version breaking changes. i appreciate that it's under rapid development and that there's a way to export and import to mitigate it. excited for when that portion stabilizes a bit so that i can roll out some of those prototypes in a more formal and meaningful way for my team

I recommend using ClickHouse instead of DuckDB.

It has been around since 2016, and it covers and extends the feature set of DuckDB with a huge margin. Worth noting that it never has breaking changes in its table format MergeTree.

I'm tracking the progress of DuckDB and see that it is modeled after ClickHouse, but does not approach it in terms of feature completeness, stability, or performance.

The closest to DuckDB option is to use its self-contained version, clickhouse-local: https://clickhouse.com/blog/extracting-converting-querying-l... or an embedded version, chdb: https://github.com/chdb-io/chdb