jet-bridge

Jet Bridge  

for Jet Admin – Admin panel framework for your application

Description

• About Jet Admin: https://www.jetadmin.io
• Live Demo: https://app.jetadmin.io/demo
• Documentation: https://docs.jetadmin.io/
• Support: [e-mail]

Jet Admin is a SaaS service that automatically generates extendable back office for your application.
Jet Bridge is a standalone app which generates REST API thought which your SQL database is connected to Jet Admin.
This project has been designed to fit requirements of small startups and mature companies.

• Data Privacy. Jet does not access your data: its transferred directly from browser to your application.
• Customizable Interface. With WYSIWYG interface customization your can change almost every part of interface.
• Extendable. Flex Features allows you to create your custom Actions, Views, Fields and other.
• Works with any technology. The interface is generated automatically based on an analysis of the data and data structure of your database.
• Quick installation. All you need is to install Jet Bridge and connect it to your database.

This is a complete remake of our popular Django Jet admin interface.

Features

• CRUD (create, read, update, delete)

  All common operations to view, create, update or delete data.

  

• Search and Filter

  Filter data easily by any field with most common lookups and search them by text occurrence. For some specific cases you can create SQL Segment to filter with.

  

• Segments

  Segments allow you to save applied set of filters as a Segment or create it from SQL query for quick use in future.

  

• WYSIWYG Interface Customization

  You can customize almost every part of interface visually – navigation menu, collection list views, record create/update forms.

  

• List View layout

  A number of out-of-the-box list layouts except default Table View like Kanban Board and Map with markers.

  

• Dashboards

  Create different types of charts, tables and other widgets to visualize your KPIs or monitor data without programming – inside your visual interface. Complex data queries can be created with SQL.

  

• Teams and Permissions

  Invite users to collaborate on a project and assign access rights based on their team.

  

• Export

  You can export all collection data or part of it into the most common formats like CSV or Excel.

  

• Responsive Layout

  The interface is optimized for any device from phones to tablets to desktops.

Extendability

While we are trying to include most of important features out of the box sometimes its not enough. For any specific cases we offer Flex features to implement functionality not available with standard features:

• Custom Views

  For very specific pages you can create your own custom FlexView based on React, Angular or any other framework and integrate it in Jet Admin interface. Writing your own custom JS/CSS/HTML has no limits in implementing any page you need.

• Custom Actions

  If need to run some operations on records or any other business logic inside your Backend you can create FlexActions and run them directly from Jet Admin interface. Passing some additional parameters to your Backend is supported.

• Custom Fields

  Sometimes using existing fields is not enough and you need to create custom which can be a combination of multiple fields, use fields from related collections and be result of some calculation. In this case you can use FlexField and write your custom JavaScript function which can format fields data any way you want.

How It Works

Jet Admin is a SaaS frontend application hosted on Jet Admin side that works in your browser. It connects to your project SQL database through open source Jet Bridge backend application which you install on your side. So Integrating Jet Admin with your project requires installing only one component - Jet Bridge. Here how it should look like after installation:

Your App

Any of your applications which works with your Database. Jet Admin does not interact with it directly.

Database

Your database Jet Admin has no direct access to.

Jet Bridge

An open source application installed on your server's side and connected to your database. It automatically generates REST API based on your database structure. Jet Interface works with Database through Jet Bridge.

Jet Interface

Web application accessible from any browser. Maintaining and updating of this web application is on Jet Admin team side. Your application data is transmitted directly from Jet Bridge to Jet Interface in your browser and remain invisible for the Jet Admin service.

Requirements

• Python 2.7 or 3.4+

• Any of the following SQL Databases:

  • PostgreSQL
  • MySQL
  • SQLite
  • Oracle
  • Microsoft SQL Server
  • Firebird
  • Sybase

Installation

Method 1. Using standalone Jet Bridge

1. Install jet_bridge package using pip or update if you did it before

pip install jet_bridge -U

1. Install appropriate database adapter

# for PostgreSQL
pip install psycopg2
# for MySQL
pip install mysqlclient

1. Run Jet Bridge for your configuration. You can read about all possible settings at Configuration page.

DATABASE_ENGINE=postgresql \
    DATABASE_HOST=host.docker.internal \
    DATABASE_PORT=5432 \
    DATABASE_NAME=database \
    DATABASE_USER=postgres \
    DATABASE_PASSWORD=password \
    jet_bridge

1. Register your project by opening in your browser: http://localhost:8888/ where localhost is your Jet Bridge HOST and 8888 is its PORT. If you want to run Jet Bridge on different host/port you can configure it (read more at Configuration page).

If you don't have Jet account yet you will be asked to create one and sign in with the existing account.

After registering your project you will be redirected to your project and can start working with Jet

After registering your project you will be redirected to your project and can start working with Jet

Method 2. Using Jet Bridge inside Docker

Jet Bridge has Docker image available on Docker Hub. In order start it inside Docker for your configuration run the following command. You can read about all possible settings at Configuration page.

1. Install Docker if you don't have it https://docs.docker.com/install/
2. Make sure Docker is running
3. Update Jet Bridge image if downloaded it before

docker pull jetadmin/jetbridge

1. Run Docker container. This will run Jet Bridge on http://localhost:8888/.

If you want to run on different port change it here: ****... -p 9000:8888 ... – this will run on 9000

docker run -p 8888:8888 \
    -e DATABASE_ENGINE=postgresql \
    -e DATABASE_HOST=host.docker.internal \
    -e DATABASE_PORT=5432 \
    -e DATABASE_NAME=database \
    -e DATABASE_USER=postgres \
    -e DATABASE_PASSWORD=password \
    jetadmin/jetbridge

If you are using Docker before 18.03 you can't use host.docker.internal for DATABASE_HOST Docker 17.12 – 18.02 use docker.for.mac.host.internal Docker 17.06 – 17.11 use docker.for.mac.localhost Docker 17.05 and below your local host IP address (can be found using ifconfig command)

1. Register your project by opening in your browser: http://localhost:8888/ where localhost is your Jet Bridge HOST and 8888 is its PORT. If you want to run Jet Bridge on different host/port you can configure it by changing Docker container port in this command.

If you don't have Jet account yet you will be asked to create one and sign in with the existing account.

After registering your project you will be redirected to your project and can start working with Jet

Support

Feel free to Email us – [e-mail]

License

This project (Jet Bridge) is MIT licensed - see the LICENCE file for details.