Installation

Windows

Download and launch the latest setup.

Linux/Mac/other

snap

• install Snap if not installed: sudo apt-get install snap
• install SQLitely from the Snap Store, or run snap install sqlitely
• launch SQLitely from OS menu, or run sqlitely

source

Install Python and pip, run pip install sqlitely.

The pip installation will add the sqlitely command to path.

General remarks

Windows installers have been provided for convenience. The program itself is stand-alone, can work from any directory, and does not need additional installation. The installed program can be copied to a USB stick and used elsewhere, same goes for the source code.

Source Dependencies

If running from source code, SQLitely needs Python 3.5+ or 2.7, and the following 3rd-party Python packages:

• ANTLR Python runtime (https://antlr.org)
• appdirs (pypi.org/project/appdirs)
• chardet (pypi.org/project/chardet)
• openpyxl (pypi.org/project/openpyxl)
• Pillow (pypi.org/project/Pillow)
• pyparsing (pypi.org/project/pyparsing)
• pytz (pythonhosted.org/pytz/)
• PyYAML (pypi.org/project/PyYAML)
• six (pypi.org/project/six)
• step (pypi.org/project/step-template)
• wxPython 4.0+ (wxpython.org)
• xlrd (pypi.org/project/xlrd)
• XlsxWriter (pypi.org/project/XlsxWriter)

All dependencies can be installed by running pip install -r requirements.txt in SQLitely source distribution folder.

Installing the required wxPython on Linux can be faster via one of their prepared Python wheels. Example for Ubuntu 20:

• run sudo apt-get install libgtk-3-0 libsdl2-2.0 libwebkit2gtk-4.0
• run pip install wxPython --find-links https://extras.wxpython.org/wxPython4/extras/linux/gtk3/ubuntu-20.04

If chardet or openpyxl or pyparsing or PyYAML or xlrd or XlsxWriter are not available, the program will function regardless, only with lesser service - like lacking Excel import-export or full search syntax.

Docker

Pre-requisites:

• Docker

Download the Dockerfile for SQLitely, build and run the Docker image:

wget https://raw.githubusercontent.com/suurjaak/SQLitely/master/build/Dockerfile
docker build . -t sqlitely

xhost +

docker run -it --rm --mount src=/,target=/mnt/host,type=bind -e \
       DISPLAY -v /tmp/.X11-unix/:/tmp/.X11-unix/ sqlitely
        

docker build . -t sqlitely will prepare an Ubuntu 20.04 Docker image and install SQLitely and its dependencies within the container.

xhost + will allow the container to access the X Window System display.

Add sudo before docker commands if current user does not have rights for Docker.

Add --mount src="path to host directory",target=/etc/sqlitely after docker run to retain SQLitely configuration in a host directory between runs.

Host filesystem is made available under /mnt/host.