Python app Installation

Step-by-step guide to installation with Python.

Integrate our Jet Bridge plugin with Python installation. You can place it behind your VPN, in your own VPC, and works locally. We won’t get access to your data, however, you will still receive updates normally.

Requirements:

• Python 2.7 or 3.4+

• pip - package manager for Python

• Any of the following SQL Databases:

  • PostgreSQL

  • MySQL

  • SQLite

  • Oracle

  • Microsoft SQL Server

  • Firebird

  • Sybase

• localhost or web server with an external IP

Installation

1. Install Python 2.7 or 3.4+ (comes with pip).

2. Install jet_bridge package using pip or update it from the command line as follows:

pip install jet_bridge -U
# or for Python 3
pip3 install jet_bridge -U

3. Install an appropriate database adapter and libraries:

# for PostgreSQL
pip install psycopg2

# for PostgreSQL + PosGIS
pip install GeoAlchemy2==0.6.2
pip install Shapely==1.6.4

# for MySQL
pip install mysqlclient

# for MSSQL
pip install pyodbc

4. Run Jet Bridge from the command line as shown below:

# for Ubuntu/MacOS/Linux/etc (UNIX systems)
PROJECT={{project_name}} TOKEN={{token}} jet_bridge

# for Windows
set PROJECT={{Project Name}} && set TOKEN={{Token}} && jet_bridge

{Project Name} and {Token} is automatically generated when you connect resource.

If you are using Jet Bridge just for HTTP requests (and not SQL) you can use Project Token as value for {Token}.

Go to the API key and below the API keys

Copy UNIQUE APP NAME and JET BRIDGE TOKEN.

This command creates a config if you run it for the first time.

After filling all required options you can now run Jet Bridge by executing the command once again:

jet_bridge

5. Finish your project installation by opening this link in your browser (usually, it opens automatically):

http://localhost:8888/api/register/

localhost is your Jet Bridge HOST and 8888 is its PORT.

If you want to run Jet Bridge on a different host or port, read the instructions on the Configuration page.

🧮Data Editor