search

simonw / csvs-to-sqlite

Convert CSV files into a SQLite database
Apache License 2.0
878 stars 69 forks source link

Specify unique column? #79

Open jungle-boogie opened 3 years ago

jungle-boogie commented 3 years ago

Hi Simon,

Is there currently a way to specify a column(s) to be unique and prevent duplicate data?

If I have a csv file, I could parse it with awk and remove duplicate data before putting it into a database, but I'd like to request csvs-to-sqlite allow an option to specify a column that needs to be unique.

My idea is to use csvs-to-sqlite and datasette together to display some data.

Thanks!