Skip to content

piekill/piepresto

Folders and files

NameName
Last commit message
Last commit date

Latest commit

6ef87f9 · May 7, 2019

History

18 Commits
May 3, 2019
May 3, 2019
May 7, 2019
May 5, 2019
May 5, 2019
May 6, 2019
May 6, 2019
May 5, 2019
May 3, 2019
May 5, 2019
May 5, 2019
May 5, 2019
May 5, 2019
May 5, 2019
May 7, 2019
May 3, 2019
May 3, 2019
May 3, 2019
May 5, 2019
May 6, 2019

Repository files navigation

PiePresto is a desktop client for PrestoDB based on PyHive and PyQt5.

  • Works on Mac and Linux.
  • Supports ssh tunnel.
  • Displays schema including nested structure.
  • Syntax highlight and auto completion.
  • Query history and result cache.

How to build

  • Python3 (conda env preferred)
  • Install dependencies in requirements.txt
  • Build with pyinstaller
  • To conclude, run the following and check ./dist for binaries:
git clone https://github.com/piekill/piepresto.git
cd piepresto
# conda create -n piepresto python=3.7.3 pip; conda activate piepresto
pip install -r requirements.txt
pyinstaller piepresto.spec
# Note that on Linux you might need: 
# LD_LIBRARY_PATH=your_path_to_python_lib pyinstaller piepresto.spec
  • Alternatively, go to release for pre-built binaries.

Tunnel config

Refer to the following figure for configuration of ssh tunnel:

+-----+         |     +---------+         +--------------+
| URL | <==ssh==|==>  | Gateway |  <===>  | PrestoServer |
+-----+         |     +---------+         +--------------+

Screenshot

screenshot