Skip to content

@wind39 wind39 released this Dec 5, 2019

  • 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.
Assets 15

@wind39 wind39 released this Jun 13, 2019 · 52 commits to master since this release

  • 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
  • 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
Assets 15
  • 2.15.0
  • 4cf6a08
  • Compare
    Choose a tag to compare
    Search for a tag
  • 2.15.0
  • 4cf6a08
  • Compare
    Choose a tag to compare
    Search for a tag

@rafaelthca rafaelthca released this Apr 18, 2019 · 99 commits to master since this release

  • 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)
Assets 13

@rafaelthca rafaelthca released this Feb 14, 2019 · 188 commits to master since this release

  • 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
Assets 2
  • 2.13.0
  • df29df2
  • Compare
    Choose a tag to compare
    Search for a tag
  • 2.13.0
  • df29df2
  • Compare
    Choose a tag to compare
    Search for a tag

@wind39 wind39 released this Dec 20, 2018 · 231 commits to master since this release

  • 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
Assets 2

@wind39 wind39 released this Oct 23, 2018 · 278 commits to master since this release

  • 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
Assets 2

@rafaelthca rafaelthca released this Sep 10, 2018 · 389 commits to master since this release

  • 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
Assets 2

@wind39 wind39 released this Jul 27, 2018 · 448 commits to master since this release

  • New feature:
    • Support to Foreign Data Wrappers, Foreign Servers, User Mappings and Foreign Tables (PostgreSQL)
  • Improvements:
    • Monitoring Dashboard: Save current chart disposition per connection
    • Monitoring Dashboard: Monitoring units that require plpythonu no longer have this requirement (PostgreSQL)
    • Monitoring Dashboard: Improved current charts and added new ones (PostgreSQL)
    • Renamed "Data Mining" feature with "Advanced Object Search" (PostgreSQL)
    • Advanced Object Search: Only shows a line when finds something, does not show "No match" (PostgreSQL)
  • Bug fixes:
    • Fixed "Failed to find conversion function from unknown to regprocedure" (PostgreSQL, #591)
    • Fixed "Unsupported regnamespace type" (PostgreSQL, #605)
    • Fixed "Object object" error message when using Query Data (Oracle, #611)
Assets 2
  • 2.9.0
  • 5142c0b
  • Compare
    Choose a tag to compare
    Search for a tag
  • 2.9.0
  • 5142c0b
  • Compare
    Choose a tag to compare
    Search for a tag

@wind39 wind39 released this Jun 23, 2018 · 483 commits to master since this release

  • New features:
    • Plugin System. Develop and share custom features
    • Data Mining, an advanced pattern matching search over database objects and tables data
  • Improvements:
    • SQL Template now available for CREATE TABLE and ALTER TABLE
    • SQL Template now available for inserting and updating records
    • Query Data action now creates a SQL Template including all columns and ORDER BY primary key
    • DDL/Properties are now available for all elements in the tree for PostgreSQL databases
    • DDL tab now shows GRANT for all supported objects for PostgreSQL databases
    • BDR3 is now available as a plugin
  • Bug fixes:
    • Debugger can now be used when connecting via SSH tunnel
    • Queries that return very large sets of data no longer block the query server
    • Fixed SSH tunnel connection issue when using the monitoring dashboard
    • Fixed \dx+ EXTENSION command in console tab
Assets 2
  • 2.8.0
  • 1ff7258
  • Compare
    Choose a tag to compare
    Search for a tag
  • 2.8.0
  • 1ff7258
  • Compare
    Choose a tag to compare
    Search for a tag

@wind39 wind39 released this May 17, 2018 · 578 commits to master since this release

  • New features:
    • Connection to any database via SSH tunnels
    • Support for BDR 3.0
    • Support for pglogical 3.0
  • Improvements:
    • Improvements to the OmniDB app window container
      • IMPORTANT - Oracle Management with OmniDB-app on WINDOWS: Oracle Instant Client (32-bit) (64-bit) must be extracted into [OmniDB's folder]/resources/app/omnidb-server OR PATH environment variable must be adjusted to point to OIC's location.
    • Backslash commands supporting PostgreSQL 10 partitioned tables and partitions
    • DDL for PostgreSQL 10 partitioned tables and partitions
    • Tree view shows PostgreSQL 10 partitioned tables and partitions with different icons
  • Bug fixes:
    • Fixed displaying table data in treeview when using MySQL 5.7
    • Fixed column autocomplete when using MySQL and MariaDB
    • Fixed JSON and JSONB editing
Assets 2
You can’t perform that action at this time.