coderhs / csvsqlweb Goto Github PK

When the CSV file has column names that are keywords in SQLite the CSV silently fails to load.

In my case, the CSV had a column named index. When I changed it to idx the file loaded correctly. Perhaps you could add a tail to column names that are keywords so, for instance, a column name of index would be imported as index_. That would avoid the collision and stop the error that blocks loading the data. If you need test data, I was using the organizations-10000.csv file from here.

There's no license in this repo. If you intend it to be open source, please add a license. If it's not intended to be open source, you should probably state that in the README.