OmniDB 2.6.0
Release Notes
New features:
Psql like console tab allowing users to run commands and keep track of past executions
Export query results to CSV or XLSX
Interface allowing users to define shortcuts for several actions, such as run query, cancel query, explain, tab management and others
Execute selected query in query tab
Improvements:
Separation between server hosting OmniDB and websocket server (to handle query, console and debugging tabs), enhancing performance for multiple users (deployment tutorial)
JSON and JSONB types fetched with single-quotes, following the JSON standard
Enhanced performance of database tree when rendering thousands of nodes
OmniDB sets application_name for all PostgreSQL connections
New login screen
Welcome tab with details about current version
1- Installation
1.1- Installation packages
Just go to omnidb.org, download the appropriate file for your
operating system and architecture and install it.
1.2- From source
1.2.1- On Debian >= 9 with pip
sudo apt install python3-pip
pip3 install pip --upgrade
pip3 install -r requirements.txt
1.2.2- On Debian/Ubuntu using PyEnv
sudo apt install git make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev wget curl llvm libncurses5-dev libncursesw5-dev xz-utils
git clone https://github.com/pyenv/pyenv.git ~/.pyenv