New browser-based tool is open source and designed especially for managing PostgreSQL databases

Oxford, United Kingdom - August 22, 2017

2ndQuadrant proudly announces the release of OmniDB, an interactive, browser-based tool that simplifies database management. It is designed to be a powerful, yet lightweight and user friendly interface for PostgresQL databases. OmniDB is fully backed by 2ndQuadrant’s world renowned 24/7 Production Support.

OmniDB includes a smart SQL editor that runs smoothly in any browser from any operating system. This revolutionary tool is powered by WebSocket technology, enabling the user to execute multiple queries in parallel. The interface includes all the necessary features to add, edit, and manage user data in a unified workspace.

OmniDB is capable of connecting and identifying main structures such as tables, keys, indexes and constraints. The interactive and customizable SQL editor features syntax highlighting and SQL code completion for tables and subqueries. The most impressive aspect of OmniDB is the highly performant response time averaging only 0.03 seconds.

“Performance has been a cause for frustration within the PostgreSQL community while working with GUI tools for database management. While developing OmniDB, one of our primary aims was to address this issue. We started off with a target of 0.1 seconds as the maximum time to complete a transaction. I am very proud to say that our benchmarks show an outstanding average response time of only 0.03 seconds.” - Umair Shahid, Head of Marketing & Products

In addition to the unparalleled response time, the key capabilities of OmniDB are:

• Easy to manage. The structure of the user's database is shown as an interactive tree. Each node's context menu contains access to every available action. The user can easily switch between database connections by picking from a simple dropdown menu.
• Create and edit tables easily. As a result of a powerful interface and extended editing capabilities, OmniDB allows the user to manage and edit existing tables and create new ones easily. It also allows the user to add & edit various table attributes such as columns, foreign keys, etc.
• Data Management. It is possible to add, edit, and remove table records depending on the table’s characteristics.

Where to find OmniDB

Download and installation instructions are available here.

About 2ndQuadrant

2ndQuadrant was founded in 2001 by Simon Riggs, a major developer and committer of the PostgreSQL project. As the largest single collective organization of PostgreSQL experts of any company globally, it is 2ndQuadrant's mission to provide the gold standard of products and services to support PostgreSQL and its continuous growth. Comprised of some of the best known developers from around the globe, all members actively contribute to the development of PostgreSQL.

SQL Maestro Group announces the release of PostgreSQL Maestro 17.8, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:

1. PostgreSQL 10 compatibility.
2. Support for Native Table Partitioning (PostgreSQL 10).
3. Support for Identity Columns (PostgreSQL 10).
4. Support for Restrictive RLS Policies (PostgreSQL 10).
5. Custom captions and colors for server nodes in Database Explorer.
6. New Statistics tab in the Edit Database Profile dialog.
7. Improved Data Grid.
8. New SQL Editor options.
9. Links to our Socials at the Quick Launch panel.
10. Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.