2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / Liaqat's PlanetPostgreSQL3 / Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
Liaqat Andrabi

Here’s How You Can Run OmniDB On Postgres10 [VIDEO]

November 8, 2017/0 Comments/in Liaqat's PlanetPostgreSQL, OmniDB, PostgreSQL /by Liaqat Andrabi

OmniDB is an open source web tool designed specifically for managing relational databases with focus on simplicity and user interaction, but at the same time be fast, powerful and light on memory. OmniDB, at the moment, supports several different relational database systems such as PostgreSQL.

The latest release of OmniDB, version 2.3.0, has introduced ‘Debugger for PL/pgSQL functions’ – a much requested feature for OmniDB users.

If you’re a PostgreSQL user and want to extract the power of its functionalities through a simple GUI tool, here is Simon Riggs from 2ndQuadrant demonstrating how to run OmniDB on top of PostgreSQL 10.

Transcript:

My name is Simon Riggs from 2ndQuadrant, and I’m going to give you a demo of OmniDB running on top of Postgres 10.

What is OmniDB? It’s a GUI tool designed to access multiple databases and especially, it’s designed to access PostgreSQL, but it does access many different kinds [of databases].

I’m demonstrating OmniDB 2.2 which was out on 12th October 2017.

What we’re going to do, first of all, is connect through to the database.

If I just click quickly on the Select Connection icon, we will go straight through into the database.

I’m demonstrating this to you on a Mac application but the same interface would be accessible through web browser, if you choose to do it that way.

What I’m going to show to you first is that we’ve got access to a database here, that as you can see is Postgres 10 and it’s got a number of different objects within it. You can see that we’ve got a tree-view here that illustrates the different object types within the database. And things within the public schema such as Tables – displayed to you in the standard tree-view drop-down, so that allows us to see what’s going on within the database.

We can run queries against the database as well. If I type in a query here that we can use to demonstrate what’s possible:

Select count(*) from customers

This button here (RUN) as you can see runs the query. So there is one record returned. You can see the start time, the duration, and the output from that query.

What we can also do, inside this interface, is inspect things like individual trigger functions. We can actually edit those fairly easily by accessing the function itself on the interface, again fairly straightforward, fairly easy to use.

One of the things that we’ve added for Postgres 10 is the ability to access the Logical Replication features, which were one of the most important aspects of Postgres 10.

What I’d like to do now is just demonstrate to you how easy it is to use the Publication feature.

If we look at Publications, we can see that there isn’t actually any Publications recorded at this time. But if we choose to create a publication, then what we can do is actually edit together a piece of SQL, that will allow us to create a publication. So if we look at,

CREATE PUBLICATION customers_pub

FOR TABLE customers

(click RUN)

There we go. That’s all we need to create a publication from OmniDB – again fairly simple.

The philosophy here is that instead of presenting you with lots of complex dialog boxes with tick boxes on, the concept is every time you want to perform some DDL action, it will actually present you with a template of the SQL and then you can actually learn to type in the SQL yourself.

It’s pretty much as quick as using a GUI interface so there’s no real difference in terms of speed.

What we end up here is SQL that you can actually cut and paste into other applications if you want to, so that’s quite an important aspect.

Another thing that we can do with OmniDB is look at Monitoring. One of the things we can do there is to access a number of different sessions that are running on the database.

Here [Monitoring –> Backends] you can see the types of things that are executing.

Finally the last feature of OmniDB is a Version Specific Documentation. You can see that quickly and easily takes us through to Postgres 10 documentation.

So that’s just a short overview really of what OmniDB can do.

What I’d like to point out here is that, you can actually access multiple different connections to multiple systems at the same time. For example, if you had a Postgres 9.6 system or Postgres 10 system then you’d be able to access each of those at the same time from the same interface.

What’s especially important and why we call it OmniDB is that it gives you access to multiple types of databases. For example, if you’re accessing MySql database or a SqlServer database or an Oracle database, you can do all of that from a single interface, which obviously makes managing different databases a lot easier than needing to switch between the individual tools. (if you’re switching between each of the different systems which provide multiple tools)

The overall purpose of Omni DB is to produce a single GUI tool that supports Postgres well, but also supports other databases.

Please use and enjoy OmniDB.

Thank you very much!

[Youtube, 2ndQuadrant]

Tags: OmniDB, PostgreSQL 10
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Get in touch with us!

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
How long does it take to change your mind? PG Phriday: Getting RAD with Docker [Part 2]
Scroll to top
×