2ndQuadrant Announces the Release of OmniDB: Lightweight and Easy-to-Use Tool for Database Management
New browser-based tool is open source and designed especially for managing PostgreSQL databases.
OXFORD, England, August 22, 2017 (Newswire.com) - 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.
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.
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.