Skip to content

Latest commit

 

History

History
35 lines (30 loc) · 1.41 KB

Readme.md

File metadata and controls

35 lines (30 loc) · 1.41 KB
Raw

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