Releases: OmniDB/OmniDB
Releases · OmniDB/OmniDB
3.0.3b
-
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).
- Core Changes
-
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
- Bug Fixes
-
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
- Re-included
-
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
- Bug Fixes
3.0.2b
-
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).
- Core Changes
-
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
- Bug Fixes
-
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
- Re-included
3.0.1b
-
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).
- Core Changes
-
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
- Bug Fixes
3.0.0b
-
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).
- Core Changes
OmniDB 2.17.0
- New features:
- Support to PostgreSQL 12.
- Improvements:
- 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.
- Bug fixes:
- 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.
OmniDB 2.16.0
- New features:
- 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
- Improvements:
- 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
- UI usability:
- Important changes:
- PostgreSQL Debugger Plugin: Requires a host connection on all platforms
- Deployment:
- OmniDB server and PostgreSQL debugger plugin packages under Debian PGDG repository (thanks to Christoph Berg @df7cb )
- Bug fixes:
- 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
OmniDB 2.15.0
- New features:
- SSH terminal emulator
- PostgreSQL: Support to event triggers and event trigger functions
- Improvements:
- 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
- Bug fixes:
- 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
- Changes in deployment
- Dropped support for 32 bits builds
- Linux deployment machines migrated from Vagrant to Docker
- Changes in test pipeline
- 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)
OmniDB 2.14.0
- 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
OmniDB 2.13.0
- New features:
- 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
- Improvements:
- 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
- Bug fixes:
- 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
OmniDB 2.12.0
- New features:
- 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
- Improvements:
- 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
- Bug fixes:
- 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