As a guy running a few Debian web servers for some small client projects and a few personal projects (some of which are medium sized, e.g. a website that gets 10 million pageviews / month) I actually tried to move from MariaDB to SQLite. The idea seemed great, at least in theory. Mainly to get away from mysqld, which actually crashed on me and corrupted some data once or twice in a timespan of 15 years.. think it was due to package updates every time.
Anyway, query and app logic modifications aside, I quickly ran into two unsolvable issues for me.
1. The lack of a robust web based admin tool comparable to phpmyadmin (no, phpliteadmin doesn't even come close)
2. No alter table. This hit pretty hard.
Plus lots of other idiosyncrasies - no enums, no type for dates, etc.
In the end I decided it's not worth the extra work, trouble and risks and stayed on Maria.
Anyway, query and app logic modifications aside, I quickly ran into two unsolvable issues for me.
1. The lack of a robust web based admin tool comparable to phpmyadmin (no, phpliteadmin doesn't even come close) 2. No alter table. This hit pretty hard.
Plus lots of other idiosyncrasies - no enums, no type for dates, etc. In the end I decided it's not worth the extra work, trouble and risks and stayed on Maria.