-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Simon Slavin wrote: > It might be worth writing a separate sqlite3 import facility which just reads > a .csv into a table.
I betcha did not know there are at least 4 different implementations of CSV as a virtual table (2 in the wiki, one in the SQLite source, and one by our prolific extension writer friend in Russia!) They all have problems. They also all work correctly on the data set the authors wanted them to. There are a huge number of issues with trying to do this that will work in all cases for everyone. (Encodings, locales, quoting, delimiter merging, column affinity, value affinity etc). Beyond simple needs the importer really needs to write some code. Sometimes they can do it with SQL (eg converting strings to null) but in other cases it requires real code. Every popular scripting language out there has SQLite bindings so it is not that hard and it will at least ensure the resulting data is as expected by the author. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAksl4qIACgkQmOOfHg372QSlLQCgppsDLOx2Zv2bVufHvycLLrci NL8AmwSrtn13Iokg3G22sNyiBIMyrgiw =TtuA -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
