Next Release: 2.12.0 - October 11, 2018

OmniDB 2.11.0

Release Date: August 23, 2018

Release Notes

New features:
- Support to PostgreSQL 11
  - Tables, functions and stored procedures can be managed in Console Tab and Tree View
  - Debugger can work with PostgreSQL 11 functions and procedures
Improvements:
- Server packages now install a service in systemd
- SQL Template for calling functions and procedures (PostgreSQL)
- Support for indexes for materialized views in the Tree View (PostgreSQL)
- Support for rules for views in the Tree View (PostgreSQL)
- Debugger version for FreeBSD (PostgreSQL)
- Connection Grid now allows sorting by clicking in the column name
- Improvements to Django security
Bug fixes:
- Fixed MESSAGES from a DO block / function / procedure not being shown if an EXCEPTION happens (PostgreSQL)
- Fixed Alter Table GUI not handling NULL values (PostgreSQL)
- Fixed column type names not being displayed correctly in Alter Table GUI (PostgreSQL)
- Fixed DDL for GRANTs for schema (PostgreSQL)
- Fixed SQL Template for REFRESH MATERIALIZED VIEW (PostgreSQL)
- Fixed Postgres-XL tree not replacing node name
Deprecation notice:
- Debian 7 is not supported anymore, server packages are built on Debian 8

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:

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:
Other features:
- Querying organized in tables
- DDL commands execution
- SQL history
- Graphs displaying tables and their relations