sqlitebiter

A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.

MIT License

Downloads
1.4K
Stars
831
Committers
5
View Code on GitHub Visit Website
Ecosystems: Jupyter Notebook, JSON, SQLite

Bot releases are visible (Hide)

sqlitebiter -

Published by thombashi about 6 years ago

  • Add a feature to find files to converting within directories recursively
    • Add options to the file subcommand: --recursive/--follow-symlinks
  • Add file matching options to filter converting files when using the --recursive option.
  • Bug fixes
sqlitebiter -

Published by thombashi about 6 years ago

  • Add --replace-symbol option that replaces symbols included in converted table attribute
  • Add a shortening option for the --quiet option
  • Add colors to the outputs
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

sqlitebiter - v0.19.0

Published by thombashi over 6 years ago

  • Add _source_info_ table to the output database to store source-name/source-ID/destination-tables/etc.
  • Improve table conversion:
    • Count table conversion results properly
    • Create tables only when the sources that include tabular data.
  • Bug fixes
sqlitebiter - v0.18.1

Published by thombashi over 6 years ago

  • Improve multibyte character support
  • Introduce colorized logging
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

  • Change to allow duplicate columns: #55 (Thanks to @thomasleveil)
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

sqlitebiter -

Published by thombashi over 6 years ago

  • Fix gs subcommand: #54 (Thanks to @antialias )
  • Add support for Line-delimited JSON
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

  • Improve processing efficiency
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

  • Add support for Jupyter Notebook: #51 (Thanks to @psychemedia)
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

  • Fix execution build binary for Windows: #52 (Thanks to @chaffinched)
  • Fix to accept symbols as the part of SQLite names: #53 (Thanks to @chaffinched)
sqlitebiter -

Published by thombashi over 6 years ago

  • Improve JSON support: Add loadable JSON schema/Add boolean support
  • Add support for space-separated values data
sqlitebiter -

Published by thombashi over 6 years ago

  • Add --format option to the file sub command: #49 (Thanks to @wingsuitist)
  • Modify to properly handle Unicode decode error
  • Support Homebrew installation for macOS: #48 (Thanks to @wingsuitist)
sqlitebiter -

Published by thombashi over 6 years ago

  • Fix package dependencies
  • Modify log messages
  • Bug fixes
sqlitebiter -

Published by thombashi over 6 years ago

  • Add auto file encoding detection
  • Loosen external package dependencies
  • Bug fixes
sqlitebiter -

Published by thombashi almost 7 years ago

  • Performance improvement
  • Drop support for Python 3.3
  • Bug fixes
sqlitebiter -

Published by thombashi about 7 years ago

  • Modify to accept underscore-character for attribute names (Thanks to Alex Kobzar)
sqlitebiter -

Published by thombashi about 7 years ago

  • Add encoding option to the file sub-command
  • Add default encoding parameter to configure sub-command
  • Fix conversion failed for some of the file types with utf8 encoding: #41 (Thanks to @wby238)
sqlitebiter -

Published by thombashi about 7 years ago

  • Change to accept underscore character as attribute names
sqlitebiter -

Published by thombashi over 7 years ago

Package Rankings
Top 5.51% on Pypi.org
Related Projects
pytablewriter

pytablewriter is a Python library to write a table in various formats: AsciiDoc / CSV / Elasticse...

23 May 2016 593