Scripting SQLite with dot commands
I searched the Internet for an answer last night and found nothing. Of course, today after posting this question I try again--and find an adequate response almost immediately.
The gist of it? Put your commands in a text file and direct it to SQLite using the input file descriptor, or just script everything in a bash script.
First Method:
sqlite3 database.db &lt; commands.txt
Second Method:
#!/bin/bash --
sqlite3 -batch $1 &lt;&lt;&quot;EOF&quot;
CREATE TABLE log_entry ( &lt;snip&gt; );
.separator &quot;\t&quot;
.import logfile.log log_entry
EOF

And then on the command line:
import.sh database.db