3 ms·
This is good news. It will allow me to drop MariaDB, only used for a few low traffic websites I manage, making my things more robust, more lightweight and easie
by jraph 3y ago
This is good news. It will allow me to drop MariaDB, only used for a few low traffic websites I manage, making my things more robust, more lightweight and easier to maintain.
I don't care for managing ports / sockets, migrating configurations, doing the creating database (careful not to use the not-really-utf-8 charset), user and granting privileges dance. Overkill for my use case.
Backups will also be easier: a simple rsync call will do, no need to call the specific mysql backup command anymore (of course it's automated but that's one less thing that can fail, less moving parts)
I bet we are many people in this case.
- ilyt 3y ago> Backups will also be easier: a simple rsync call will do, no need to call the specific mysql command anymore (of course it's automated but that's one less thing that can fail, less moving parts) Technically, that's incorrect way of doing it; practically it rarely fails (as writes are usually much rarer in many cases SQLite is used, especially if you backup in the middle of the night, and format itself is pretty resilient), but you should be doing one of methods here: https://www.sqlite.org/backup.html https://www.sqlite.org/backup.html
- fmajid 3y agoI used Wordpress with PostgreSQL in production for a few years, but that was not officially supported by Automattic like this is.
- tommy_axle 3y agosqlite3 <dbfile> '.backup path/to/backup' && rsync ...