3 ms·
I think the excitement about SQLite comes from LAMP stack fatigue Every Wordpress site could have been built on sqlite just fine, with better security too. But
by starcraft2wol 3y ago
I think the excitement about SQLite comes from LAMP stack fatigue
Every Wordpress site could have been built on sqlite just fine, with better security too. But beyond that, you probably want a real RDMS with auth and alter table.
- zdragnar 3y agoBack in the day, WordPress always ran on Apache with mod_php, correct? Wouldn't that be unsafe to use sqlite, since every request ran in a separate thread?
- graemep 3y agoSeparate prcoesses because php was not thread safe back then. SQLite can handle multiple processes: https://www.sqlite.org/faq.html#q5 https://www.sqlite.org/faq.html#q5 I am not sure it could back then
- zdragnar 3y agoWrites and changes to the database itself are locked to a single process at a time, per your link. If the load is very read heavy the write locks aren't an issue, but if you're tracking page views, comments or any other write-heavy feature, it'll be harder to get good performance.
- simonw 3y agoBenchmark it with WAL mode turned on. You may be pleasantly surprised.
- simonw 3y agoSQLite has a pretty interesting auth story using the auth callback hook. Alter table is solvable too. I built tooling for that here: https://sqlite-utils.datasette.io/en/stable/cli.html#transforming-tables https://sqlite-utils.datasette.io/en/stable/cli.html#transfo...