2. Installation

2.2. Installation for Debian/Ubuntu from a deb package

  1. wget https://github.com/thombashi/sqlitebiter/releases/download/<version>/sqlitebiter_<version>_amd64.deb
  2. dpkg -iv sqlitebiter_<version>_amd64.deb
Example:
$ wget https://github.com/thombashi/sqlitebiter/releases/download/v0.20.0/sqlitebiter_0.20.0_amd64.deb
$ sudo dpkg -i sqlitebiter_0.20.0_amd64.deb

2.3. Installing executable files in Windows

sqlitebiter can be used in Windows environments without Python installation as follows:

  1. Navigate to https://github.com/thombashi/sqlitebiter/releases
  2. Download the latest version of the sqlitebiter_win_x64.zip
  3. Unzip the file
  4. Execute sqlitebiter.exe in either Command Prompt or PowerShell
>cd sqlitebiter_win_x64
>sqlitebiter.exe -h
Usage: sqlitebiter [OPTIONS] COMMAND [ARGS]...

Options:
  --version               Show the version and exit.
  -o, --output-path PATH  Output path of the SQLite database file. Defaults to
                          'out.sqlite'.
  -a, --append            append table(s) to existing database.
  -i, --index TEXT        comma separated attribute names to create indices.
  --replace-symbol TEXT   Replace symbols in attributes.
  -v, --verbose
  --debug                 for debug print.
  -q, --quiet             suppress execution log messages.
  -h, --help              Show this message and exit.

Commands:
  completion  A helper command to setup command completion.
  configure   Configure the following application settings: (1) Default...
  file        Convert tabular data within CSV/Excel/HTML/JSON/Jupyter...
  gs          Convert a spreadsheet in Google Sheets to a SQLite database...
  url         Scrape tabular data from a URL and convert data to a SQLite...

2.4. Installation for macOS via Homebrew

$ brew tap thombashi/sqlitebiter
$ brew install sqlitebiter

2.5. Command Completion

To setup for bash:

    sqlitebiter completion bash >> ~/.bashrc

To setup for zsh:

    sqlitebiter completion zsh >> ~/.zshrc

3. Dependencies

Python 2.7+ or 3.4+

Python package dependencies are as follows.

3.1. Python package dependencies

3.1.1. Mandatory dependencies

Following mandatory Python packages are automatically installed during sqlitebiter installation process:

3.1.2. Google Sheets dependencies (Optional)

Following Python packages are required to manual installation when you use Google Sheets feature:

The above packages can be installed with the following pip command;

$ pip install sqlitebiter[gs]

3.1.3. Test dependencies

3.1.4. Misc dependencies (Optional)

3.2. Dependencies other than Python packages (Optional)

  • libxml2 (faster HTML/Markdown conversion)
  • pandoc (required when converting MediaWiki files)