SQLite is used in WordPress for the Playground feature. There have been requests for it to be an alternative to MySQL / MariaDB. It seems to me that it might be an option in the future for faux static sites. Here are some interesting facts about SQLite.