[motiejus]

One thing that bit and puzzled me was autoloading of the extensions.

If you are compiling applications with clang (or zig), some (all?) extensions will not work, because C++ does not have a stable ABI. And thus an application linked with lld/zig cc will fail to load an extension linked with ld/gcc (aka the official duckdb extensions).

We found this the hard way after enabling zig-c++ as the C++ compiler in prod. Took some time to recompile (and statically link) the extensions we actually use, but now the system is much better off.

I would prefer a default that does not download anything from the internet (especially .so files), but that's quite easy to change when you know it.

Still wip to actually poke with duckdb for myself. :)