Skip to content

Releases: simonw/csvs-to-sqlite

1.3

18 Nov 16:35
1a7a9df
Compare
Choose a tag to compare
  • New options for populating a fixed column - so every inserted row will have the same column with the same value. Options are --fixed-column column-name string-value, --fixed-column-int column-name integer-value and --fixed-column-float column-name float-value. Thanks, William Rowell. #81

1.2

03 Nov 23:27
a8a37a0
Compare
Choose a tag to compare
1.2
  • Upgraded dependencies, including Pandas. #73

1.1

09 Aug 18:46
2311663
Compare
Choose a tag to compare
1.1
  • --just-strings feature to disable type detection and import columns as strings by default. Thanks, Dan Nguyen!. #58

csvs-to-sqlite 1.0

03 Aug 10:58
Compare
Choose a tag to compare

This release drops support for Python 2.x #55

csvs-to-sqlite 0.9.2

03 Jul 04:37
Compare
Choose a tag to compare

Bumped dependencies and pinned pytest to version 4 (5 is incompatible with Python 2.7).

csvs-to-sqlite 0.9.1

24 Jun 15:21
Compare
Choose a tag to compare
  • Fixed bug where -f option used FTS4 even when FTS5 was available (#41)

csvs-to-sqlite 0.9

17 Jan 05:20
Compare
Choose a tag to compare
  • Support for loading CSVs directly from URLs, thanks @betatim - #38
  • New -pk/--primary-key options, closes #22
  • Create FTS index for extracted column values
  • Added --no-fulltext-fks option, closes #32
  • Now using black for code formatting
  • Bumped versions of dependencies

csvs-to-sqlite 0.8

24 Apr 15:35
Compare
Choose a tag to compare
  • -d and -df options for specifying date/datetime columns, closes #33

  • Maintain lookup tables in SQLite, refs #17

  • --index option to specify which columns to index, closes #24

  • Test confirming --shape and --filename-column and -c work together #25

  • Use usecols when loading CSV if shape specified

  • --filename-column is now compatible with --shape, closes #10

  • --no-index-fks option

    By default, csvs-to-sqlite creates an index for every foreign key column that is
    added using the --extract-column option.

    For large tables, this can dramatically increase the size of the resulting
    database file on disk. The new --no-index-fks option allows you to disable
    this feature to save on file size.

    Refs #24 which will allow you to explicitly list which columns SHOULD have
    an index created.

  • Added --filename-column option, refs #10

  • Fixes for Python 2, refs #25

  • Implemented new --shape option - refs #25

  • --table option for specifying table to write to, refs #10

  • Updated README to cover --skip-errors, refs #20

  • Add --skip-errors option (#20) [Jani Monoses]

  • Less verbosity (#19) [Jani Monoses]

    Only log extract_columns info when that option is passed.

  • Add option for field quoting behaviour (#15) [Jani Monoses]

csvs-to-sqlite 0.7

26 Nov 03:14
Compare
Choose a tag to compare
  • Add -s option to specify input field separator (#13) [Jani Monoses]

csvs-to-sqlite 0.6.1

25 Nov 02:58
Compare
Choose a tag to compare
  • -f and -c now work for single table multiple columns.

    Fixes #12