Wal mode allows for concurrent readers and one writer. I’ve been use a similar architecture for a Flask app using SQLite and Redis. So far I haven’t had any iss

Wal mode allows for concurrent readers and one writer. I’ve been use a similar architecture for a Flask app using SQLite and Redis. So far I haven’t had any issues sending thousands of events. The write process is a few milliseconds and from the docs iirc writes will get queued if there’s a lock. If it works for your case the simplicity of it is awesome. Unfortunately you don’t get things like RBAC so you need to use views and make sure your routes don’t allow access. Pushing security that I would probably prefer in the db to the app isn’t ideal imo.