Releases: OmniDB/OmniDB
Releases · OmniDB/OmniDB
OmniDB 2.11.0
- 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
- Support to PostgreSQL 11
- 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
OmniDB 2.10.0
- 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:
OmniDB 2.9.0
- 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
OmniDB 2.8.0
- 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
- 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
OmniDB 2.7.0
- 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
OmniDB 2.6.0
- 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
OmniDB 2.5.0
- 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).
OmniDB 2.4.1
- 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
OmniDB 2.4.0
- 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
OmniDB 2.3.0
- 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: