in reply to Re: Loading bulk data into SQLite
in thread Loading bulk data into SQLite

Thanks L~R. For some reason I was fixated on "loading" and missed the ".import" command. I installed a standalone version of SQLite to try out its command shell. Still had to process the file through Perl to get it into a suitable format, but afterwards loading it using .import was extremely fast.

Replies are listed 'Best First'.
Re^3: Loading bulk data into SQLite
by Limbic~Region (Chancellor) on Nov 30, 2008 at 16:37 UTC
    hangon,
    Still had to process the file through Perl to get it into a suitable format

    I forgot to mention that the .mode command can switch to various different formats such as tabs a la 

    .mode tabs;
.import <file> <table>;

    [download]

    Cheers - L~R

[reply]
[d/l]

In Section Meditations