> ... feeding sql commands to sqlite3 (the command) The SQLite shell is not really designed for production work. It can be used as you suggest for routine queries, but for anything more complicated, you'll have fewer headaches if you use a scripting language that you're already familiar with (tcl, python, ruby, etc). Tcl seems to have the cleanest interface.
Regards
