I know Pieter[1] uses SQLite for Nomad List[2] and Remote OK[3], both high-traffic sites. Maybe you can tweet him to learn more.

[1] https://twitter.com/levelsio [2] https://nomadlist.com [3] https://remoteok.io