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 […]
Migration to PostgreSQL [Webinar]
/1 Comment/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiAmong the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as […]
Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products
/0 Comments/in Cloud Native /by Gabriele BartoliniCloud Native PostgreSQL and Cloud Native BDR are the two Kubernetes operators written by 2ndQuadrant entirely from scratch in the Go language and relying exclusively on the Kubernetes API.
PG Phriday: It’s the End of the World as We Know it (and Postgres is Fine)
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasOn 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 […]
Webinar: PostgreSQL Partitioning Roadmap [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarPartitioning is an integral data management strategy for high-performance and high-volume database applications. PostgreSQL provides excellent partitioning support that is constantly evolving. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “PostgreSQL Partitioning Roadmap”. The session was hosted by Simon Riggs, Founder, and CEO at 2ndQuadrant. The webinar looked at the […]
Oracle to PostgreSQL – Binary Objects
/6 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL /by Kirk RoybalBinary Objects in PostgreSQL definitely have caveats, and don’t behave the way you might expect coming from an Oracle background. This article demystifies the Blob, gives some practical advice for dealing with them, and improves your philosophy.
Bulk transactions with RESTful CRUD API using PostgreSQL and Spring Boot
/0 Comments/in Haroon's PlanetPostgreSQL /by Muhammad HaroonA typical database-oriented application setup only must work with single operation SQL or RESTful execution. Your customers might only be sending the INSERT or UPDATE queries one at a time. We have covered this approach in part 2 for our series and have created a simple RESTful API that allows users to perform CRUD operations […]
Webinar: Fantastic Data Types and Where to Use Them [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarPostgreSQL has fantastic data types such as ENUM, ARRAY, and JSON, to name a few. These data types were added to cover use cases that were not easily solved with the existing types. Due to their post-relational nature, they remain unusual and even strange to some developers, but once you learn them, you can create […]
How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)
/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab TariqThis article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We are going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL […]
How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
/0 Comments/in 2ndQuadrant, OmniDB, PostgreSQL, Sadeq's PlanetPostgreSQL /by 2ndQuadrant PressOmniDB 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 […]
Oracle to PostgreSQL: Reasons to Migrate
/9 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk RoybalPostgreSQL has quite a few compelling advantages, some of which are not found in any other database management system. This article will outline the ones that are most interesting to the Oracle developer seeking to do a migration or investigate alternatives for new development. To prevent this article from becoming another list of PostgreSQL features, it […]