Re: [sqlite] Python program to convert CSV to sqlite

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. 2018-01-18 15:33, Simon Slavin: >

[sqlite] Python program to convert CSV to sqlite

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