“SQLite should be named AwesomeSQL, because that is what it is.”
Most websites run on one machine and will never need a second. They still get a database server, a connection pool and a separate backup job. SQLite is one file. The catch is one writer at a time, which most sites will never notice.