A variation of this page is now an official part of the SQLite documentation. See
whentouse.html