OmniDB Versions Save

New features:

• PostgreSQL 13 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

New features:

• PostgreSQL 13 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

New features:

• PostgreSQL 13 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

New features:

• PostgreSQL 13 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).

• Support to PostgreSQL 12.

• Table DDL panel shows generated columns.
• Added SQL template for Cluster Index, accessible from context menu in TreeView.
• Added Advanced Object Search as an option in Inner Tab context menu.

• Fixed: Server ping causing peaks of false positives in moments of brief network interruption or idle activities, or when the notebook running OmniDB was put to sleep.
• Fixed: High CPU usage when SSH console is being used and tunnel gets closed.
• Fixed: Render issue with graph chart type.
• Fixed: Permission issue to install OmniDB plugins on Linux.
• Fixed: SQLite dependency issue on CentOS 6.

• Monitoring Dashboard: Graph monitor unit type
• Monitoring Dashboard: New standard units: TPS, WAL Production and Replication Graph
• PostgreSQL TreeView: New groups for partitioned and inherited tables
• PostgreSQL Debugger Plugin: Support for PostgreSQL running on OSX
• Server: Support to run OmniDB on a custom URL path
• Snippets: Run Snippet in Connection

• UI usability:
  • Add Connection list in (+) menu of outer tabs
  • Show red X on tabs only on mouse hover
  • Color icons in Dark Theme
  • Release Notes outer tab now stay closed and only open upon next upgrade
• Other improvements:
  • Included procedures in Advanced Object Search for PostgreSQL 11

• PostgreSQL Debugger Plugin: Requires a host connection on all platforms

• OmniDB server and PostgreSQL debugger plugin packages under Debian PGDG repository (thanks to Christoph Berg @df7cb )

• Fixed #768: Monitoring - some units fail on a standby server
• Fixed #836: SELECT ... INTO is not allowed here
• Fixed #845: Partitioned relation indexes
• Fixed #938: Password in connection string not used
• Fixed #940: Unable to change column width of query results
• Fixed #960: Snippet TreeView not rendering properly
• Fixed #970: Focus on change Query Tab names
• Fixed #981: Updatable chart titles
• Fixed #990: Cleanup of inactive web socket clients

• SSH terminal emulator
• PostgreSQL: Support to event triggers and event trigger functions

• Monitoring units can now use past data, allowing users to create historical charts
• Improved security: disabled TLSv1.0 and TLSv1.1
• Support to file .my.cnf for MySQL and MariaDB connections
• App graphical stack upgraded to Electron 4.1 and GTK 3
• Grid component HandsOnTable upgraded to 7.0
• Improved thread safety
• Improved websocket connection handling in the client side

• Fixed error on EditData when primary key was of type date or timestamp
• Fixed display and handling of array types
• Fixed handling of BC and infinity dates
• Fixed bug involving SELECT INTO statements
• Fixed error message not completely copyable from error popup
• Fixed bug when sorting connection grid
• Fixed bug when changing user password
• Fixed bug when creating connections from omnidb-config (CLI)
• Fixed bug that sporadically breaks query tab usability after query is cancelled
• Fixed bug in drag and drop of tabs in Firefox

• Dropped support for 32 bits builds
• Linux deployment machines migrated from Vagrant to Docker

• PostgreSQL, Oracle, MySQL and MariaDB test machines migrated from Vagrant to Docker
• New Vagrant machines for User Acceptance Tests (with graphical environment to test OmniDB app)

• 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

• 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

• 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

• Connection Groups: allow users to, for example, easily distinct Production and Test database servers
• User and connection management via omnidb-config CLI utility, which helps with automated deploying

• Advanced Object Search now considers view and materialized view definition
• Show trigger function when expanding the trigger node in the tree view
• PostgreSQL: Improved \h command, which provides syntax help on SQL commands
• Linux: OmniDB systemd service now uses configuration file in /etc/omnidb.conf
• Converted all OmniDB users passwords into hashes in the OmniDB user database, improving security
• OmniDB upgrade procedure now takes a backup of the user database (file omnidb.db)
• Autocommit is now always enabled on Oracle/MySQL/MariaDB
• User won't need to execute query again after password expiration / re-validation
• OmniDB debugger plugin for PostgreSQL 11 for FreeBSD

• Fixed: Click index with WHERE clause: "Can only transpose a table with a single row"
• Fixed: Export to XLSX/CSV does not consider all rows
• Fixed: Error closing error window
• Fixed: Monitoring Dashboard: Column widths are not adjusted when the monitoring tab doesn't have focus
• Fixed: User Mapping is not being shown in the tree if there are no options
• Fixed: Foreign Table DDL not being shown correctly if there are no options
• Fixed: DDL for functions and procedures do not show a necessary comma after function body

• New modern look & feel on the entire web interface, components and icons
• PostgreSQL: User now can enable/disable autocommit
• PostgreSQL: Status of the backend is shown to the user
• PostgreSQL: If autocommit is disabled or user starts a transaction, user can either COMMIT or ROLLBACK
• PostgreSQL: New full-featured autocomplete component for PostgreSQL
• PostgreSQL: Support to HASH partitions (SQL templates, treeview, properties and DDL)
• New User options to set CSV encoding and delimiter

• PostgreSQL: OmniDB now uses PostgreSQL server-side cursors whenever possible to always keep low OmniDB memory usage
• PostgreSQL: Improved SELECT template for views and materialized views
• Save title of Query Tabs
• OmniDB debugger: Different RPM for CentOS 6 and 7
• OmniDB plugin API: Adapted to new OmniDB look & feel
• OmniDB plugin API: Support to pglogical, Postgres-BDR 1.0 and Postgres-XL removed from core and are now separated open source plugins

• Fixed: PostgreSQL: High memory usage when returning very large dataset (using server-side cursors)
• Fixed: Oracle/MySQL/MariaDB: QueryBlock not displaying first row of every block
• Fixed: Click on removed node on the treeview: "Can only transpose a table with a single row"
• Fixed: Export to XLSX does not respect locale
• Fixed: Editor loses focus after Alt-Tab