[sqlite] CLI feature request: .import option -h

2018-09-30 Thread Christof Böckler
Hi all, I'm sorry if I'm wrong on this list, but I have a small feature request for the CLI. I regularly import CSV data with a first line of headers into a SQLite database by using the .import command. On the first run the destination table gets automatically created. Later I get more data from

[sqlite] CSV import using CLI (header, NULL)

2020-02-29 Thread Christof Böckler
Hi, I want to share some thoughts and make some suggestions about the SQLite 3 command line interface (CLI) tool, especially its behaviour when importing CSV files. CSV files are probably even more common for data exchange than SQLite database files. I consider it to be good practice to incl