csvs-to-sqlite 0.6

SQLite full-text search support

• Added --fts option for setting up SQLite full-text search.

  The --fts option will create a corresponding SQLite FTS virtual table, using
  the best available version of the FTS module.

  https://sqlite.org/fts5.html
  https://www.sqlite.org/fts3.html

  Usage:

  csvs-to-sqlite my-csv.csv output.db -f column1 -f column2
  

  Example generated with this option: https://sf-trees-search.now.sh/

  Example search: https://sf-trees-search.now.sh/sf-trees-search-a899b92?sql=select+*+from+Street_Tree_List+where+rowid+in+%28select+rowid+from+Street_Tree_List_fts+where+Street_Tree_List_fts+match+%27grove+london+dpw%27%29%0D%0A

  Will be used in simonw/datasette#131

• --fts and --extract-column now cooperate.

  If you extract a column and then specify that same column in the --fts list,
  csvs-to-sqlite now uses the original value of that column in the index.

  Example using CSV from https://data.sfgov.org/City-Infrastructure/Street-Tree-List/tkzw-k3nq

  csvs-to-sqlite Street_Tree_List.csv trees-fts.db \
      -c qLegalStatus -c qSpecies -c qSiteInfo \
      -c PlantType -c qCaretaker -c qCareAssistant \
      -f qLegalStatus -f qSpecies -f qAddress \
      -f qSiteInfo -f PlantType -f qCaretaker \
      -f qCareAssistant -f PermitNotes
  

  Closes #9

• Handle column names with spaces in them.

• Added csvs-to-sqlite --version option.

  Using http://click.pocoo.org/5/api/#click.version_option