News for hackers. Stuff that matters.
Re:The Winamp Skin Museum is powered by a SQLite3 database w... by hedora on Saturday June 11, 2022 @05:53PM (#31708810)
Define large. I'd guess sqlite can do 10-100K TPS, no problem.

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.)

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.

Re:The Winamp Skin Museum is powered by a SQLite3 database w... by hedora on Sunday June 12, 2022 @12:21AM (#31711407)
This. Like I said, postgres or mysql are probably better choices. However, modern hardware (especially small sync disk writes) is really fast,and sqlite has its own strong points.