One notable site which runs on SQLite is SQLite's own source code version tracking system called Fossil.

See https://sqlite.org/src/doc/trunk/README.md and https://www.fossil-scm.org