[pstadler]

  "The SQLite website (https://www.sqlite.org/) uses SQLite itself, of course,
  and as of this writing (2015) it handles about 400K to 500K HTTP requests
  per day, about 15-20% of which are dynamic pages touching the database.
  Each dynamic page does roughly 200 SQL statements. [...]"

Wait... What? They're saying that their dynamic pages are executing 200 SQL statements per request?

Off-topic: I enjoyed reading this article which was posted here a while ago http://www.sqlite.org/testing.html

[mutagen]

200+ queries for a simple dynamic page doesn't surprise me. Once you add some dynamic features it's easy to start sticking all kinds of stuff in the database. Let me check some sites I run:

  Medium complexity Drupal 6 site: 200-300 queries
  Wordpress site with accretion of plugins over the years: 100+ queries
  Drupal 7 site: 100+ queries

Those totals might be inflated due to having administrative menus active.

Many of these are key/value lookups which can be accelerated by serving from Memcached or Redis, although I imagine SQLite dishes them out pretty quickly as well.