SQLite Forum

feature request for CSV extension...
just a reply to confirm that the OOM error is coming from sqlite when I tried to access the virtual table.

sqlite> CREATE VIRTUAL TABLE temp.zipcode 
  USING vsv(filename='files/US.tsv', 
  schema='create table x(country_code,postal_code,place_name,admin_name1,admin_code1,admin_name2,admin_code2,admin_name3,admin_code3,latitude,longitude,accuracy)');

sqlite> select count(*) cnt from temp.zipcode;
Error: out of memory

sqlite> select count(*) cnt from zipcode;
Error: out of memory