Comment by piokoch
2 hours ago
Why not MySQL/MariaDB? DuckDB and Quack might be new and flashy, but sooner or later you will need things like connection pooling, data retention, backups, replication. In a real setup there is nothing lightweight about DuckDB as it will have to answer the same issues other DB-s do.
If you want to go with something less mainstream, why not trying Firebird DB, a very solid solution.
I hadn't heard of MariaDB. IIRC Firebird is declining in popularity and I really want something that is still going to be supported in 10 years time.