2ndQuadrant Archives - 2ndQuadrant

PostgreSQL is the worlds’ best database

March 12, 2020/4 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

The title is not clickbait or hyperbole. I intend to prove that by virtue of both design and implementation that PostgreSQL is objectively and measurably a better database1 than anything currently available, with or without money considerations.

How in the world can I claim and justify such a lofty statement? Read on, gentle nerd. I promise that your time will not be wasted.

How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall

March 11, 2020/2 Comments/in 2ndQuadrant, PostgreSQL, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection. With SQL injection, rogue players target the backend database of any system. Usually, these systems are public-facing. Hackers try to send seemingly innocuous and regular […]

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

March 10, 2020/0 Comments/in 2ndQuadrant, Business, Featured /by Umair Shahid

Ensuring high availability for our clients’ PostgreSQL databases is our primary business objective. We are able to achieve that by ensuring availability of our PostgreSQL experts round the clock and around the world. Just like we plan failover and switchover contingencies for our clients, we plan for backups and backups-of-backups for business continuity so our […]

Researching PostGIS slowness (2019 edition)

February 27, 2020/2 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

Just as last year was ending, one of our long-time customers came to us because one of their long-existing PostgreSQL queries involving PostGIS geometry calculations was much slower for specific values. We researched the problem and found out how to solve it; read on! What we found as the cause of the problem will surprise […]

Webinar: All you need to know about CREATE STATISTICS [Follow Up]

February 27, 2020/0 Comments/in 2ndQuadrant, Webinars /by Nouman

Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL 12. This command allows the database to collect multi-column statistics which helps the optimizer understand dependencies between columns, produces more accurate estimates and results in […]

How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)

February 27, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we’ll use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We’re going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL 11.6 Orange […]

Announcing New PostgreSQL Online Training Series

February 13, 2020/0 Comments/in 2ndQuadrant, training /by Umair Shahid

2ndQuadrant’s training courses are very popular amongst PostgreSQL professionals and enthusiasts, and have hosted more than 500 trainees in the last 10 years. Our current Public and On-Site training options, however, have their limitations. We are often asked: “When are you going to offer a training course in my region?“ It’s disheartening to tell people […]

Releasing Cloud Native BDR Operator for Kubernetes

February 5, 2020/0 Comments/in 2ndQuadrant, Cloud Native /by Gabriele Bartolini

I am very excited to announce the first release of “Cloud Native BDR Operator” for Kubernetes. BDR Operator is the first 2ndQuadrant product to be launched in the Cloud Native landscape and it is part of our long term commitment in this area: 2ndQuadrant indeed is a Silver member of the Cloud Native Computing Foundation […]

How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)

February 4, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Seemab's PlanetPostgreSQL /by Semab Tariq

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In the article, we’ll use an example of Animals to predict whether they are mammals, Birds, Fish or Insects. Software versions We’re going to use 2UDA version 11.6-1 to implement the Machine Learning model. 2UDA version 11.6-1 combines: PostgreSQL 11.6 […]

Barman Cloud – Part 1: WAL Archive

January 27, 2020/0 Comments/in 2ndQuadrant, Barman, DevOps, Featured, Jonathan's PlanetPostgreSQL, PostgreSQL /by Jonathan Battiato

Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL server itself? Well, since Barman 2.10 this is now possible! How? Let’s discover that together in the following articles.

PostgreSQL is the worlds’ best database

How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

Researching PostGIS slowness (2019 edition)

Webinar: All you need to know about CREATE STATISTICS [Follow Up]

How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)

Announcing New PostgreSQL Online Training Series

How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)

Support & Services

Products

Postgres Learning Center

About Us