Re:Appropriate Uses for SQLite
by michaelmcmillan on Monday February 12, 2018 @11:00AM
(#16359465)
I run a complex CRM that handles 1.2 million USD in transactions every year. It is running sqlite with a simple in-memory cache (just a dict) that gets purged when a mutating query (INSERT, UPDATE or DELETE) is executed. It is simple and fast enough.
[ Parent
| on HN ]
Like the other commenter mentioned, I'd love to hear more about this too. How are you doing backups and deployment?
Tell us more! How many transactions per second do you process? Do you use multiple databases?
If you assume each of these transactions is a dollar, you get a bit under 0.04 transactions/sec on average. If peak load is 25x average, that would come out to 1/sec.
Re:Appropriate Uses for SQLite
by nerfhammer on Monday February 12, 2018 @03:58PM
(#16362054)
is this single threaded? single client?