Package: sqlite3
Version: 3.23.1-1
Severity: wishlist
Per /usr/share/doc/sqlite3-doc/csv.html, upstream sqlite3 includes a CSV
loadable extension.
AFAICT it's not available in Debian, where e.g. the json1 module already works
with no .load required:
(BUILDROOT:BUSTER)root@zygon:/# sqlite3
SQLite version 3.23.1 2018-04-10 17:39:29
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select json_array(1, 2, 3);
[1,2,3]
sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv');
Error: no such module: csv
(BUILDROOT:BUSTER)root@zygon:/# apt-file search sqlite | grep csv
libsqlite3-mod-csvtable:
/usr/lib/x86_64-linux-gnu/libsqlite3_mod_csvtable-0.9995.so
libsqlite3-mod-csvtable:
/usr/lib/x86_64-linux-gnu/libsqlite3_mod_csvtable.so
libsqlite3-mod-csvtable:
/usr/share/doc/libsqlite3-mod-csvtable/changelog.Debian.gz
libsqlite3-mod-csvtable: /usr/share/doc/libsqlite3-mod-csvtable/changelog.gz
libsqlite3-mod-csvtable: /usr/share/doc/libsqlite3-mod-csvtable/copyright
libsqlite3-mod-csvtable:
/usr/share/lintian/overrides/libsqlite3-mod-csvtable
pythoncard-doc:
/usr/share/doc/pythoncard-doc/samples/dbBrowser/scripts/pysqlite2_from_csv.py
sqlite3-doc: /usr/share/doc/sqlite3-doc/csv.html
wfrog: /usr/lib/wfrog/database/csv2sqlite3
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.
(I don't currently know if one is better than the other.)
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.
