Comment by hermitcrab
3 hours ago
I'm looking for a lightweight client-server database where I can connect 3 or 4 GUI clients to a single database and concurrently edit the database. Low transaction volumes (probably a few edits per minute). Would DuckDb + Quack be suitable?
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.