Control: tags -1 +moreinfo
Hi Trent,
On Mon, May 28, 2018 at 1:33 PM Trent W. Buck <trentb...@gmail.com> wrote:
> Per /usr/share/doc/sqlite3-doc/csv.html, upstream sqlite3 includes a CSV
loadable extension.
The documentation needs update. What you read is the external CSV loadable
module (IMHO).
> AFAICT it's not available in Debian, where e.g. the json1 module already
works with no .load required:
[...]
> sqlite> CREATE VIRTUAL TABLE temp.t1 USING
csv(filename='thefile.csv');
> Error: no such module: csv
Now you talk about the CSV import that is part of SQLite3 and developed by
D. Richard Hipp. That don't need module import.
> libsqlite3-mod-csvtable: /usr/lib/x86_64-linux-gnu/
libsqlite3_mod_csvtable-0.9995.so
[...]
> Debian DOES include libsqlite3-mod-csvtable, but it's a third-party
> module by C. Werner, whereas the one documented on sqlite.org and
> bundled in the sqlite3 source tarball is by Dr. Hipp.
Indeed and the cvstable package is _not_ maintained by me - it's outdated
in Debian, still didn't reach its first stable (1.0) version and probably
not compatible with the current SQLite3 release in Debian.
Offtopic, I don't know if Mr. Hipp is Dr or not, I think the confusion is
his
whole name: D. R. (= Richard) Hipp.
> (I don't currently know if one is better than the other.)
I would say use the one which is part of SQLite3.
> If it's easy to do, can you please build the CSV module (and any other
similar first-party extensions)?
> I don't mind if they're separate (new) binary packages, so they don't
"pollute" the main sqlite3 binary package.
> Just so long as I can try them out without having compile sqlite3 myself.
Again, don't need to load any module. What's wrong with the following?
$ cat test.csv
a,b
1,2
3,4
5,6
7,8
$ sqlite3
SQLite version 3.23.1
sqlite> .mode csv
sqlite> .import test.csv test_table
sqlite> .schema test_table
CREATE TABLE test_table(
"a" TEXT,
"b" TEXT
);
sqlite> select * from test_table;
1,2
3,4
5,6
7,8
Regards,
Laszlo/GCS
