5 ms·
How are you handling writes to the data? SQLite isn't known for handling concurrent writes which you need in most basic web applications.
by PretzelFisch 8y ago
How are you handling writes to the data? SQLite isn't known for handling concurrent writes which you need in most basic web applications.
- hellofunk 8y agoThat would be a good question for the author of this article’s web stack. There is some explanation here: https://learnbchs.org/ksql.html https://learnbchs.org/ksql.html
- hellofunk 8y agoI think the web library, if it supports SQLite, must manage the writes to that database. Django uses SQLite by default, but if you have it running on just one server, I would expect that Django coordinates the needed writes from all its simultaneous users in a queue or something, one at a time.
- marktangotango 8y agoHas anyone verified this is the case? I tend to doubt django does it. Using a few tricks SQLite easily beats postgres insert performance, just a little obscure.