3 ms·
Quite right it’s not one size fits all but for any site that’s mostly read only it’s a brilliant solution. Simon Willison has written about it and coined the t
by samwillis 5y ago
Quite right it’s not one size fits all but for any site that’s mostly read only it’s a brilliant solution.
Simon Willison has written about it and coined the term “baked data”: https://simonwillison.net/2021/Jul/28/baked-data/ https://simonwillison.net/2021/Jul/28/baked-data/
Mozilla.org uses this architecture, Django app running off SQLite with the db rsync’ed to each application server.
- quickthrower2 5y agoThe confusion is probably a lot of us work at smaller companies that serve a wide solution to a niche customer, and that kind of app has a lot of reads and writes but doesn't need to scale. This app might be doing the invoicing/shipments/specialist parts of a business for example. Whereas there is another different kind of Engineering which I probably will never be a part of (simply due to mathematics of available positions doing it) where you are scaling something up for millions of users but the app is much simpler like a Twitter or Reddit, and the challenge is in the scaling.
- samwillis 5y agoEven for those small niche apps for businesses there are a huge number that are unlikely to be doing more than the 10-20 write transactions / second that SQLite can support.
- quickthrower2 5y agoProbably on average correct, but there can be bursts.