SQlite Import from commandline
Sqlite is an amazingly powerful cute little database, which comes in handy when processing standalone jobs.
The feature I use the most is importing csv into table on the fly and use the table in my scripting.
Let see how to import csv into sqlite database from command line. This example was tested on linux (centos) but it should be the same in windows / mac.
Lets create a load.sql with following lines.
delete from yourtablename; .import /yourpath/input.csv yourtablename
First line deletes the existing contents of the table, if you to append the data then remove or comment that line.
Second line is dot (.) import command. Given path of your csv file followed by tablename. As this is a dot command it has no semi colon (;).
Now from $ command prompt lets execute the following
$ sqlite3 yourdatabase.db < load.sql
In my testing I found, it takes 2 seconds to load 500,000 rows with handful of columns.
Boom !! you can login to your database to verify the result
$ sqlite3 yourdatabase.db
sql>select * from yourtable limit 5;