Regardless of current or past, a clarification must be made. SQLite and MySQL are good in different situations.
SQLite does not support concurrent actions (true ones at least, it still locks for one writer) on a database, meanwhile MySQL does have high concurrency support. A major lack in high concurrency in SQLite is a turn off for many design reasons.
I use SQLite for data storage on a game I developed for a hobby, but for my distributed computing the company I work at uses a custom built RDBMS. SQLite would block way too often to be even considered in this case.