I have spun up vw for testing purposes and now I’m ready to set up a production system for my extended family maybe about a dozen at most 2 dozen users. I figure on 80 max records each. With the client apps doing local caching r/w activity to the db should be pretty light. Blobs (i.e. files) are stored separately outside the database so we aren’t talking about that many MB of data.
That leads me to think that continuing to use sqlite would be ok and I definitely like the simplicity of this single file without a server. I’ve been running gitea git server with just sqlite for awhile now and that has worked out.
That said I run nextcloud using mysql with about the same number of users and spinning up mysql server as a container is easy. Backup is a little pain (mysqldump) but not horrible.
So if you are have a similar use case what production db route did you go with and are you happy with your choice?