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
2.8.0
6 years ago
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
2.7.0
6 years ago
New features:
Basic support for MySQL 5.6/5.7 and MariaDB 10.1/10.2
Management of multiple databases in the same connection
Debugger plugin can now be installed in PostgreSQL hosted on Windows (Install Instructions)
Improvements:
Improved security for omnidb-server when running with SSL
New button to reload the source code of the function in the debugger interface
Other improvements to the debugger interface
Improved security for debugger
Commands ?, \x and \timing for Console Tab for Oracle, MySQL and MariaDB
Console status showing number of rows affected in Console Tab for Oracle, MySQL and MariaDB
"Analyze" action for tables and materialized views for PostgreSQL
"Truncate" action for tables for PostgreSQL
UI and editor themes can be applied on-the-fly
Dark theme for charts
Support to quoted identifiers on Oracle
2.6.0
6 years ago
New features:
Psql like console tab allowing users to run commands and keep track of past executions
Export query results to CSV or XLSX
Interface allowing users to define shortcuts for several actions, such as run query, cancel query, explain, tab management and others
Execute selected query in query tab
Improvements:
Separation between server hosting OmniDB and websocket server (to handle query, console and debugging tabs), enhancing performance for multiple users (deployment tutorial)
JSON and JSONB types fetched with single-quotes, following the JSON standard
Enhanced performance of database tree when rendering thousands of nodes
OmniDB sets application_name for all PostgreSQL connections
New login screen
Welcome tab with details about current version
2.5.0
6 years ago
Basic support to Oracle databases. Users can manage, connect, and interact with Oracle databases using most of the same features provided to manage PostgreSQL databases.
macOS: Download Oracle Instant Client (64-bit) and extract in ~/lib.
Linux: Install Oracle Instant Client (32-bit) (64-bit) and extract it into OmniDB's folder.
Windows: Install Oracle Instant Client (32-bit) (64-bit) and extract it into OmniDB's folder.
New DDL Panel. A new panel located below the treeview displays properties and DDL of the currently selected node (works for PostgreSQL and Oracle).
2.4.1
6 years ago
Connections are now managed in the workspace, without losing existing work and focus
Autocomplete shortcut key is now Ctrl-Space by default
New improved Find & Replace for SQL Editor
OmniDB server now listens to the same port for HTTP(S) and WS(S), no need for opening two ports in firewall anymore
2.4.0
6 years ago
Custom Monitoring Dashboard: User defined monitoring dashboard with charts and grids allowing the user to create custom monitors in a python sandbox
Persistent user data: OmniDB's database, config files and logs now persist through new release upgrades
Bug fixes:
Autocomplete box window doesn't hide on mouse move anymore
2.3.0
6 years ago
Debugger for PL/pgSQL functions (requires a plugin, please see installation instructions and how to use)
Automatic saving of query tabs (fixes #200)
Automatic closing of database connections
Other enhancements:
Tabbed SQL History
Packages for openSUSE
Bug fixes:
#239: Unable to use some password
#261: Click and drag image
#278: EditData does not work when column has uppercase letters
#279: Autocomplete in query and EditData does not work for columns with upper case