2. Installation

2.2. Installation for Debian/Ubuntu

2.2.1. Install from PPA (for Ubuntu)

sudo add-apt-repository ppa:thombashi/ppa
sudo apt update
sudo apt install sqlitebiter

2.2.2. Install from a deb package

ARCHIVE_URL=$(curl -sL https://api.github.com/repos/thombashi/sqlitebiter/releases/latest | jq -r '.assets[].browser_download_url' | \grep deb) &&
TEMP_DEB="$(mktemp)" &&
wget -O "${TEMP_DEB}" "${ARCHIVE_URL}" &&
sudo dpkg -i "${TEMP_DEB}"
rm -f "${TEMP_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

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.5+

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)

Extra Python packages are required to install to use Google Sheets feature (gs subcommand):

The extra 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)