Re:The Winamp Skin Museum is powered by a SQLite3 database w...
by Closi on Saturday June 11, 2022 @08:08PM
(#31709791)
Just because you can use something doesn’t mean you should use it.
If you have 10k writes a second and 90k reads a second then SQLite is an awful choice.
Re:The Winamp Skin Museum is powered by a SQLite3 database w...
by kasey_junk on Saturday June 11, 2022 @08:38PM
(#31710022)
Have you benchmarked it?
Given modern commodity servers and no network overhead I’d buy it not being a problem.
My intuition is you are right but given the operational simplicity improvements it would be worth exploring.
You'll want a read cache to avoid repeatedly rendering the same HTML, etc in the frontend, where most CPU is spent. That'll accidentally reduce database load.
Assuming 10% writes (which is really, really write heavy), that'll get you to 1M page views per second. After that, you'll need to rearchitect.
(MySQL and Postgres are probably better choices, but I'd evaluate all three if I was setting this up for real.)