Hi, I've also written a similar script to convert csv to sql (SQLite and PostgreSQL compatible). This script doesn't require fancy external libraries, and will correctly identify data types.
<https://github.com/The-Orizon/nlputils/blob/master/csvsql.py> 2018-01-18 15:33, Simon Slavin: > csvs-to-sqlite > > <https://github.com/simonw/csvs-to-sqlite> > > Simple command line makes simple SQLite table definitions. Or you can get > fancy with the command line and it will create tables linked with foreign > keys, or add a column with the filename to a table, or do other things. > > I have not tried this program myself, I just thought it might be useful for > other people. > > For those not familiar with GitHub, there’s a "clone or download" button > which lets you just download the project (source code) without having to > install any special client on your computer. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users