omnidb mysql_OmniDB: OmniDB 是一个开源的基于浏览器的数据库管理工具

Next Release: 2.15.0 - April 11, 2019

OmniDB 2.14.0

Release Date: February 14, 2019

Release Notes

New features:

Connection via URI, allowing more connection parameters (for more details check https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING)

Easy installation/removal of OmniDB plugins

Plugin API: Monitoring Units can now be created as separate plugins

Global user interface font size is now customizable

(PostgreSQL) Support to user-defined types and domains

Improvements:

Monitoring Dashboard: Charts with many labels now are rendered with a vertical scroll bar

Monitoring Dashboard: Non-append charts now keep original colors

Included support to MariaDB 10.3

Included support to MySQL 8.0

Included support to Oracle 18c

Included support to Postgres-XL 10

Bug fixes:

Fixed error when clicking on a foreign table, then Data Actions, then Query Data

Fixed error when changing connection: object of type 'NoneType' has no len()

Fixed CentOS 7 package error: OmniDB server service file is missing

Fixed error in EditData being shown if PK column name has quotes and table has at least 1 record

1- Installation

1.1- Installation packages

Just go to omnidb.org, download the appropriate file for your

operating system and architecture and install it.

You can also install from repositories (as root):

1.1.1- Debian / Ubuntu repository

apt install apt-transport-https dirmngr

echo "deb https://dl.bintray.com/wind39/omnidb-deb debian main" > /etc/apt/sources.list.d/omnidb.list

apt-key adv --recv-keys 379CE192D401AB61

apt update

apt install omnidb-app # for the app; or

apt install omnidb-server # for the server; or

apt install omnidb-plugin # for the plugin

1.1.2- CentOS 7 / Fedora repository

cat > /etc/yum.repos.d/omnidb.repo <

[omnidb]

name=omnidb

baseurl=https://dl.bintray.com/wind39/omnidb-rpm

gpgcheck=0

repo_gpgcheck=0

enabled=1

EOF

yum install omnidb-app # for the app; or

yum install omnidb-server # for the server; or

yum install omnidb-plugin # for the plugin

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 / MariaDB

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

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