3 ms·
Have you had any success or failures with the single-threadedness of sqlite and multiple simultaneous users? Does buffering interactions using gunicorn help sol
by llccbb 9y ago
Have you had any success or failures with the single-threadedness of sqlite and multiple simultaneous users? Does buffering interactions using gunicorn help solve this? I ask because I love using sqlite for some localhost programs but always transfer away to postgres once I push the app to a server/VM. Thankfully sqlalchemy makes the transition possible with just a config change and no real retooling of the codebase.
- ioddly 9y agoI mostly use it on low traffic applications, but it depends on what those simultaneous users are doing and how many of them there are. Multiple processes can access a single sqlite DB, they just can't write to it at the same time. So yeah, gunicorn (or any forking server) should help. See: https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html