SQLite vs MySQL

Here is a list of well-known Users of SQLite:

Link

Here is a debate regarding SQLite vs MySQL

Link

It seems to me, in 99% case, SQLite is good for production use.