sqlitebiter 0.35.2

A CLI tool to convert CSV/Excel/HTML/JSON/LTSV/Markdown/TSV/Google-Sheets to a SQLite database file. - Create a SQLite database file from: - File(s): - CSV - Microsoft Excel :superscript:`TM` - HTML - JSON - Labeled Tab-separated Values (LTSV) - Markdown - Tab separated values (TSV) - Google Sheets - URL (scrape data from web pages) - Multi-byte character support

Tags database console
License MITL
State beta

Recent Releases

0.35.218 Jun 2021 06:25 minor feature: Improve version subcommand output. Build CI of Windows execution binary.
0.35.014 Jun 2021 10:45 minor feature: Retain leading zeros when converting text: #83. Add support for Python 3.9 / Python 3.10. Drop support for Python 3.5. Improve type detection. Modify output format of version subcommand. Update requirements.
0.34.113 Sep 2020 17:25 minor feature: Parse error when an ipynb file does not include language_info. Modify version subcommand output.
0.34.017 Aug 2020 03:25 minor feature: Add version subcommand.
0.33.006 Aug 2020 06:05 minor feature: Add --max-workers option. Replace a package dependency from colorama to tcolorpy. Update requirements.
0.32.120 Apr 2020 03:15 minor feature: Make simplejson to an optional dependency and replace to ujson. Add all extras_require. Update requirements.
0.32.006 Apr 2020 16:45 minor feature: Add stdin sub command: #75. Make it possible to execute the command with python -m sqlitebiter. type annotations. Update requirements.
0.31.102 Apr 2020 09:25 minor feature: to accept table names that start with numbers: #76. Update requirements. Modify log messages.
0.31.012 Mar 2020 03:16 minor feature: Improve JSON support: #74. Modify log messages when skip file conversion.
0.30.009 Mar 2020 03:15 minor feature: Add detailed information for the cause of the errors while data conversion: #73. Add type annotations. Update requirements.
0.29.217 Feb 2020 10:05 minor feature: Remove six completely . Modify imports for simplejson. . Bump version.
0.29.010 Feb 2020 03:15 minor feature: Add support for platforms that lacks support sem_open such as Android Termux: #71. Modify log formats. Drop Python 2 support. Remove dev extras_require.
0.28.319 Jan 2020 03:15 minor feature: Binary packages.
0.28.106 Jan 2020 06:45 minor feature: Update docs . Update README. . Modify toxenv. . Remove unnecessary sudo configs from Travis CI. . Remove build alias. . Add support for Python 3.8. . Update docs. . Update README. . a TOXENV. . Update Makefile. . Update docs. . Update README. . Update CI. . Add lint for.travis.yml. . Improve scientific notation detection: Update tool.black. . Apply formatter. . Add tool.isort. . Update requirements. . Integrate release/docs extras to dev extras. . Apply formatter. . Update docs. . Update README. . requirements. . Bump version.
0.28.007 May 2019 10:25 minor feature: Drop support for Python 3.4. Loosen some of the external dependencies version restriction. .
0.27.321 Apr 2019 11:25 minor feature: Modify a deprecated section for setup.cfg . Update requirements. . Bump version.
0.27.215 Apr 2019 10:45 minor feature:
0.27.130 Mar 2019 11:05 minor feature: Executable binary packaging: #65.
0.27.026 Mar 2019 09:45 minor feature: Add --no-type-inference option: #64.
0.26.022 Mar 2019 14:05 minor feature: Add --convert-config (experimental). Add retries for HTTP requests. .
0.25.116 Mar 2019 04:25 minor feature:
0.25.024 Feb 2019 03:17 minor feature: Add --add-primary-key option: #60. .
0.24.019 Feb 2019 03:45 minor feature: Add --type-hint-header option: #59.
0.23.814 Feb 2019 09:45 minor feature: Improve processing performance. Improve logging. execution binary packaging.
0.23.704 Feb 2019 13:25 minor feature: Pin pip version to 18.1 to avoid packaging failure: pypa/pip#6163. .
0.23.628 Jan 2019 06:25 minor feature: Improve logging.
0.23.515 Jan 2019 03:16 minor feature: Refactor loading the config file . Add a project URL. . Update requirements. . Add a project URL. . Refactor application configurations. . Rename a variable. . a test case. . Remove an import that no longer used. . Update pylama.ini. . Update badges. . Update summary. . Update README. . Bump version.
0.23.404 Jan 2019 03:16 minor feature: Add napoleon extension . Update Makefile. . Update requirements. . a test case. . Remove a test depenency. . Bump version.
0.23.326 Dec 2018 01:25 minor feature: Suppress a warning by click . Add retries to package installation for Travis CI. . a skip directory path. . Improve FIFO detection precision. . Modify Python package installation for Travis CI. . Add missing imports. . Add build tox env. . Update requirements. . Add Makefile. . Update docs. . Update README. . Add a missing script to running test cases. . Bump version.
0.23.213 Oct 2018 13:25 minor feature: avoid error exit when specified file not found. Suppress Unicode warnings in Python 2.
0.23.109 Oct 2018 06:45 minor feature: Execution binaries.
0.22.022 Sep 2018 03:16 minor feature: Add support for named pipe: #56 File subcommand accept named pipe as an input . File subcommand accept named pipe as an input. Add completion subcommand for command completion.
0.21.010 Sep 2018 06:05 minor feature: Add a feature to find files to converting within directories recursively Add options to the file subcommand: --recursive/--follow-symlinks . Add options to the file subcommand: --recursive/--follow-symlinks. Add file matching options to filter converting files when using the --recursive option. .
0.20.029 Jul 2018 08:25 minor feature: 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. .
0.19.116 Jul 2018 03:16 minor feature: Travis CI deploy credentials . Add an error handling for execution binaries. . Remove unreachable code. . Additional error handlings for execution binaries. . for Python 2 compatibility. . Bump version to 0.19.1.
0.18.109 Jul 2018 03:16 minor feature: Change to allow duplicate columns: #55. .
0.18.002 Jul 2018 06:25 minor feature: Change to allow duplicate columns: #55. .
0.17.126 Jun 2018 05:45 minor feature: Update summary . deployment files for CI. . Refactoring: extract subcommands to independent files. . Remove shebang. . Refactoring: simplify logging. . for Python 2 compatibility. . Bump version to 0.17.1.
0.17.018 Jun 2018 06:05 minor feature: gs subcommand: #54. Add support for Line-delimited JSON.
0.16.111 Jun 2018 09:45 minor feature: Improve processing efficiency. .
0.16.004 Jun 2018 09:45 minor feature: Add support for Jupyter Notebook: #51. .
0.15.128 May 2018 06:05 minor feature: Execution build binary for Windows: #52. to accept symbols as the part of SQLite names: #53.
0.15.014 May 2018 07:05 minor feature: Improve JSON support: Add loadable JSON schema/Add boolean support. Add support for space-separated values data.
0.14.005 May 2018 12:45 minor feature: Add --format option to the file sub command: #49. Modify to properly handle Unicode decode error. Support Homebrew installation for macOS: #48.
0.13.001 May 2018 13:25 minor feature: Add auto file encoding detection. Loosen external package dependencies. .
0.12.020 Nov 2017 19:45 minor feature: Performance improvement. Drop support for Python 3.3. .
0.11.102 Oct 2017 17:45 minor feature: Modify to accept underscore-character for attribute names (Thanks to Alex Kobzar).
0.11.020 Aug 2017 07:25 minor feature: Add encoding option to the file sub-command. Add default encoding parameter to configure sub-command. conversion failed for some of the file types with utf8 encoding: #41.
0.10.201 Aug 2017 03:16 minor feature: Change to accept underscore character as attribute names.
0.10.118 Jul 2017 08:05 minor feature: pylint cleanup. Update a help message. Update requirements. Update docs. Update README. Bump version to 0.10.1.
0.10.003 Jul 2017 03:17 minor feature: Add --index option to create indices in created database. Add short options. Add log messages.
0.9.029 May 2017 06:45 minor feature: Improve --append option functionality: #35. Improve automated table naming. JSON file error handling.
0.8.109 May 2017 03:15 minor feature: Right quotes missing when converting values that include quotes: #33.
0.8.005 May 2017 03:15 minor feature: Add configure sub-command. Improve processing performance.
0.7.001 May 2017 03:15 minor feature: Add support for SQLite database files as input data. Improve log messages. .
0.6.208 Apr 2017 00:30 minor feature: - Add Python 3.6 support - Improve logging - Improve error handling