There is an unfinished {link: http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html SQLite Optimization FAQ} which concentrates on optimizing for speed when using the sqlite library in a C application. There is a rough (but pretty functional) {link:http://perlmonks.org/index.pl?node_id=150476 MySQL 2 SQLite} [ {link:http://perlmonks.thepen.com/150476.html mirror} ] converter written in perl, which will take a MySQL specific create table statement, and turn it into a SQLite compatible one. Improvements are welcome.