News for hackers. Stuff that matters.
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.
Re:Appropriate Uses for SQLite by neuland on Monday February 12, 2018 @01:04PM (#16360466)
Like the other commenter mentioned, I'd love to hear more about this too. How are you doing backups and deployment?
Re:Appropriate Uses for SQLite by simplify on Monday February 12, 2018 @12:29PM (#16360196)
Tell us more! How many transactions per second do you process? Do you use multiple databases?
Re:Appropriate Uses for SQLite by pvg on Monday February 12, 2018 @01:27PM (#16360679)
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?