To save you a click, the actual headline is "Help us test the SQLite implementation", and the news is that WordPress developers are asking (urging!) hosts, plugin authors, and theme developers to test the implementation and report bugs.<p>The most interesting bit for me: <i>"The SQLite code used has been in use for many years and has been battle-tested. We opted to start with a tried solution instead of starting from scratch because many of the problems we would have encountered have already been addressed and solved in the pre-existing implementation."</i>
Hopefully this will entice more people into supporting SQLite as their backend DB. There's been more than a few things I've purposefully not installed because they require MySQL (it is forbidden on my servers.)
Nice. That will simplify my installs and my backups and their reliability. There are not many writes, very few concurrent ones, accesses are mostly cached using a WP cache extension. I have a lot of trust in SQLite's reliability. It should fit right in. WordPress is the only reason MariaDB is installed on my servers. Nextcloud too, actually, and SQLite might not be a good idea for this.
I will be testing it with Marmot (<a href="https://github.com/maxpert/marmot">https://github.com/maxpert/marmot</a>) to help scale Wordpress when needed! IMO Wordpress + SQLite is a no brainer for 95% of its sites. Hopefully do a demo video. Marmot will help folks scale their sites without central MySQLs.
This was posted a few days ago[1], I have to say I am interested, as Ghost lost support for SQLite (and I have used that combo happily for years).<p>1: <a href="https://news.ycombinator.com/item?id=34020786" rel="nofollow">https://news.ycombinator.com/item?id=34020786</a>
At this point I’d just go with a flat file CMS, there are so many good systems nowadays <a href="https://github.com/ahadb/flat-file-cms">https://github.com/ahadb/flat-file-cms</a>
The embedded nature of SQLite is somewhat offset by the stack still requiring PHP + Apache installed, what's one more dependency (MySQL)? All WordPress hosts already have MySQL installed, while installing WordPress from scratch is still a pain (or requires programs that manage that complexity for you e.g. XAMPP).