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
echo 'export PYENV_ROOT="$HOME/.pyenv"' >> ~/.bashrc
echo 'export PATH="$PYENV_ROOT/bin:$PATH"' >> ~/.bashrc
echo 'eval "$(pyenv init -)"' >> ~/.bashrc
source ~/.bashrc

pyenv install 3.5.2
cd OMNIDB_FOLDER
pyenv local 3.5.2

pip install pip --upgrade
pip install -r requirements.txt

1.3- Running OmniDB

Download or clone OmniDB repo and extract it somewhere. To start Django server, enter into OmniDB/OmniDB folder and type:

python omnidb-server.py

2- Introduction

OmniDB is a web tool that simplifies database management focusing on interactivity, designed to be powerful and lightweight. Check-out some characteristics:

• Web Tool: Accessible from any platform, using a browser as a medium
• Responsive Interface: All available functions in a single page
• Unified Workspace: Different technologies managed in a single workspace
• Simplified Editing: Easy to add and remove connections
• Safety: Multi-user support with encrypted personal information
• Interactive Tables: All functionalities use interactive tables, allowing copying and pasting in blocks
• Smart SQL Editor: Contextual SQL code completion
• Beautiful SQL Editor: You can choose between many available color themes
• Tabbed SQL Editor: Easily add, rename or delete editor tabs

Technologies:

• Python (3.5+)
• Django

Supported Platforms:

• Linux
• Windows
• OS X

Supported DBMS:

• PostgreSQL
• Oracle
• MySQL
• Firebird
• SQLite
• Microsoft SQL Server
• IBM DB2

3- Database Schema Management

OmniDB is designed for easy database management. Here are some features:

• Tree view showing database structure

• Powerful table creation
  • Editing capabilities:
    • Tables' names
    • Columns: name, type and nullable
    • Primary keys and respective columns
    • Foreign keys with either table and reference columns, including updating rules and removal as well
    • Indexes

• Table editing: Edit table structure according to DBMS limitations
• Data management: Add, edit and remove records

• SQL Editing
  • Syntax highlighting for SQL
  • SQL code completion for table columns and subquery
  • Multiple themes to be selected

• Support for external tools:

  • pglogical
  • Postgres-BDR
  • Postgres-XL

• Other features:

  • Querying organized in tables
  • DDL commands execution
  • SQL history
  • Graphs displaying tables and their relations

• Graphs displaying complete ER diagram

• Visualization of explain plan

• PL/pgSQL function debugger (requires a plugin, please see here)

• Monitoring dashboard