OmniDB Archives - 2ndQuadrant

Posts

Webinar : Introduction to OmniDB [Follow Up]

November 30, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, OmniDB /by Liaqat Andrabi

A database management tool that simplifies what is complex and drives performance. OmniDB is one such tool with which you can connect to several different databases – including PostgreSQL, Oracle, MySQL and others. 2ndQuadrant recently hosted a webinar on this very topic: Introduction to OmniDB. The webinar was presented by OmniDB co-founders and PostgreSQL consultants […]

OmniDB debugger for PostgreSQL 11

November 6, 2018/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

PostgreSQL 11 was released recently, with exciting new features. One of them is the ability to write SQL procedures that can perform full transaction management, enabling developers to create more advanced server-side applications. SQL procedures can be created using the CREATE PROCEDURE command and executed using the CALL command. Since OmniDB 2.3.0 it is possible […]

Postgres Installer by 2ndQuadrant – now supports OmniDB!

September 4, 2018/0 Comments/in 2ndQuadrant, Marriya's PlanetPostgreSQL, OmniDB, Postgres Installer /by Marriya Malik

Postgres Installer is a user-friendly, graphical installation and configuration tool for PostgreSQL. With just a few clicks you can install PostgreSQL – version 9.5, 9.6, 10 and 11(beta) – on Windows, Linux and macOS. The latest Postgres Installer release includes support for OmniDB – an interactive and user-friendly database management tool to manage multiple databases in […]

Postgres-BDR 3.0 with OmniDB

June 26, 2018/3 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

Introduction OmniDB 2.8 introduced support for Postgres-BDR 3.0, the ground-breaking multi-master replication tool for PostgreSQL databases, announced last month in PostgresConf US. Here we have 2 virtual machines with Postgres-BDR 3.0 installed and we will use OmniDB to connect to them and setup replication between the machines. Pre-requisites Postgres-BDR 3.0 requires PostgreSQL 10 or better […]

Oracle with OmniDB

February 13, 2018/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

OmniDB was designed to allow users to manage multiple databases from different RDMBS within an unified workspace. The philosophy is to use the same familiar web interface (same structures, icons, context menu and handy features such as SQL Autocomplete, Create/Edit Table Form and Edit Data) so the user feels comfortable and confident to manage different […]

OmniDB: Monitoring Dashboard

February 8, 2018/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

OmniDB 2.4.0 introduces a new cool feature called Monitoring Dashboard. We know a picture is worth a thousand words, so please take a look: As you can see, this is a new kind of inner tab showing some charts and grids. This Monitoring inner tab is automatically opened once you expand the tree root node (the PostgreSQL […]

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 […]

Postgres-XL with OmniDB

October 17, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. Introduction Postgres-XL (or just XL, for short) is an open source project from 2ndQuadrant. It is a massively parallel database built on top of PostgreSQL, and it is designed to be horizontally scalable and flexible enough to handle various workloads. Here we will show how to build a test environment to play with XL […]

PostgreSQL 10 Logical Replication with OmniDB

September 19, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. Introduction Logical replication uses a publish/subscribe model and so we create publications on the upstream (or publisher) and subscriptions on downstream (or subscriber). For more details about it, please refer to this blog post from my colleague Petr Jelinek, and also to the PostgreSQL documentation. Here we will show how to build a test […]