rokoder

Tag: csv

csv to sqlite conversion [csv2sqlite sqliteloader]

by on Jul.01, 2015, under Programming

During one of my personal projects, I had to use ‘.import’ command of the sqlite3 shell. The .import command is very limited in functionality. It also always binds column data as text. This has performance hit as well as disk usage hit. I also need some very basic conversion support like store numbers as numbers in db files as well as some way to parse date related data.

All these needs leads for the development of sqliteloader which csv files to sqlite easy.

Leave a Comment :, , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Blogroll

A few highly recommended websites...

Archives

All entries, chronologically...