Appropriate Uses for SQLite
fossil scm is a dvcs built around sqlite.  one executable, very few dependencies and atomic transactional safety.  workflow wise its more like cvs or svn properly converted into a dvcs.  great for small teams, integrated web server, wiki issue tracking.  http://fossil-scm.org