Hacker News Reader

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.

View on HN

SQLite 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#transfo...

Back 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?

Separate prcoesses because php was not thread safe back then.

SQLite can handle multiple processes: https://www.sqlite.org/faq.html#q5

I am not sure it could back then

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

Benchmark it with WAL mode turned on. You may be pleasantly surprised.

Reply on news.ycombinator.com