Skip to content

Latest commit

 

History

History
121 lines (97 loc) · 4.12 KB

README.md

File metadata and controls

121 lines (97 loc) · 4.12 KB

OmniDB-NG

We proudly leverage all of the great work Open Source work done by the original (now dormant) project https://github.com/OmniDB/OmniDB

Run it yourself from source

If you want or need a new feature, submit a pull request for us to consider.

Pre-req's for Debian/Ubuntu

sudo apt install python3-dev python3-venv python3-wheel libpq-dev libldap2-dev libsasl2-dev

Pre-req's for Enterprise Linux flavors

sudo yum install xxx yyy zzz

Pre-req's for OSX using Homebrew

brew install python3 xxx yyy zzz

Build instructions

sudo apt install python3-dev python3-venv python3-wheel libpq-dev libldap2-dev libsasl2-dev
python3 -m venv omenv
source omenv/bin/activate
git clone https://github.com/pgsql-io/omnidb-ng
cd omnidb-ng
pip3 install -r requirments.txt

Start it up

cd omnidb-ng/OmniDB
python3 omnidb-server.py

OmniDB-NG 3.0.6

Release Date: May, 10 2022

Release Notes

  • New features:

    • PostgreSQL 9.6, 10, 11, 12, 13 & 14 support
    • Database structure tree and Properties/DDL tabs with support to additional PostgreSQL objects
    • Option to use Active Directory / LDAP to authenticate OmniDB's users
    • Option to use PostgreSQL as OmniDB's backend database
    • Additional monitoring units
    • Omnis UI helper component (offering walkthroughs)
    • OmniDB's own graphical explain component (displaying Explain and Explain Analyze)
    • Option to share connections between OmniDB users
  • Improvements:

    • Core Changes
      • Websocket > Long Polling
      • Better handling of database connections, reusing connection when appropriate
      • Shared tunnels
      • Updated python and javascript libraries (security + stability)
      • Electron > NWJS (New desktop technology)
      • Enhanced shortcuts, allowing users to maintain shortcuts per OS
    • UX/UI improvements for several elements (Connections management, Autocomplete, Global snippet panel with quick-[save/load], contextual menus).
  • 3.0.1 changes

    • Bug Fixes
      • Fixed an issue in the long polling mechanism
      • Dark theme colors on autocomplete selection
    • Improvements
      • Added snippets and custom monitoring units to the OmniDB 2 to 3 automatic migration process
  • 3.0.2 changes

    • Re-included
      • Explain visualizer component from OmniDB 2.x
      • Shortcuts for issueing Explain and Explain Analyze
    • Bug Fixes
      • Fixed missing dark theme colors on connection results when in full-view
      • Fixed conflict between the z-index of the new explain visualizer and the database tree context menus
    • Improvements
      • Added a toggle to switch between the old and new explain components
      • Improved client-side CPU usage performance (browser rendering gpu-intensive processes)
      • Added a new node-spin loading icon for dark themes with improved visibility
  • 3.0.3 changes

    • Bug Fixes
      • Query Tab: Fixed editor key behaviours related to up/down arrows (skipping rows, text selection, text shifting, text indenting)
      • Console Tab: Fixed issue describe command for tables in PostgreSQL 12+
      • Console Tab: Fixed background theme color on console output when changing themes
    • Improvements
      • Reduced chances of having OmniDB being flagged as a threat by security tools (false-positives)
      • Outer Menu: Improved layout and behaviour, providing better awareness of the context
      • Result Grid: Improved resizing behaviours
      • Added password option on --createconnection
  • 3.0.4 Changes

  • 3.0.5 Changes

    • Support latest django (v4)
    • 1st pass at Packages support for Oracle
    • Add build instructions to README
  • 3.0.6 Changes

    • Freeze requirements file for prod stability
    • OmniDB-NG branding sponsored by PGSQL.IO & Denis Lussier
    • fix error saving PG connections
    • fix blowfish warning when starting up server
    • improve the connections form with db specific placeholders

Website: http://omnidb-ng.org

Full Documentation: https://omnidb-ng.readthedocs.io