OmniDB Archives - 2ndQuadrant

Posts

Webinar: Managing and Monitoring PostgreSQL Clusters with OmniDB [Follow Up]

October 19, 2020/0 Comments/in 2ndQuadrant, Webinars /by Quratulain Ghazali

OmniDB is an effective workspace to tame and optimize PostgreSQL clusters, with easy and secure access to data, system health, and customizations. And all this, unified in the flavor of your preference: web-browser solution with access to multiple DBAs or a single ready-to-use desktop app installed on your working station. In order to explore OmniDB […]

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

July 21, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Sadeq's PlanetPostgreSQL, Technology /by Sadequl Hussain

In a previous article of this series, we created a two-node PostgreSQL 12 cluster in the AWS cloud. We also installed and configured 2ndQuadrant OmniDB in a third node. The image below shows the architecture: We could connect to both the primary and the standby node from OmniDB’s web-based user interface. We then restored a […]

Machine‌ ‌Learning‌ ‌with‌ ‌2UDA‌ ‌-‌ ‌PostgreSQL‌ ‌and‌ ‌ Orange‌ ‌-‌ ‌Concluding‌ ‌the‌ ‌series‌

July 17, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

In this blog series, we have covered the following machine learning models to utilize Machine Learning capabilities with 2UDA. KNN SVM Random Forest Tree Logistic Regression AdaBoost Neural Network Now we are bringing you a recap of this blog series in order to summarize the results we obtained through these models in a single post. […]

PG Phriday: It’s the End of the World as We Know it (and Postgres is Fine)

July 3, 2020/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

On June 17th, I gave a presentation on Postgres Monitoring to the Chicago Postgres User Group. Since MeetUp doesn’t allow uploading slides, I figured I’d convert my presentation into a more comprehensive writeup. Enjoy! Why Monitor So, what are the finer points of Disaster Mitigation? Let’s start with a few questions: What broke? When did […]

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1

June 25, 2020/0 Comments/in 2ndQuadrant, OmniDB, PostgreSQL, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

OmniDB is an open-source, graphical database management tool developed by 2ndQuadrant, a world-leader in PostgreSQL technologies and services. OmniDB is a browser-based, universal client tool that can manage major database engines like PostgreSQL, MariaDB, MySQL, and Oracle. Other soon-to-be-supported engines include SQLite, Firebird, MS SQL Server, and IBM DB2. Like any excellent database client software, OmniDB […]

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

Read 2ndQuadrant’s response to the COVID – 19 emergency here