2ndQuadrant Archives - Page 3 of 12 - 2ndQuadrant

Data Modelling – It’s a lot more than just a diagram

June 22, 2018/0 Comments/in 2ndQuadrant /by George McGeachie

If the title of this blog post rings a bell with you, perhaps you were at PG Day in Horwood House in 2014, when I stood up for 5 minutes to make the case for data modelling; a data model is much more than just a diagram. I shouldn’t be, but I am often amazed […]

Postgres Installer – A GUI based, user-friendly installer for PostgreSQL

June 5, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Postgres Installer, PostgreSQL /by Liaqat Andrabi

Installing the world’s top enterprise-class open source database – PostgreSQL – is now a whole lot easier with Postgres Installer. Postgres Installer is a GUI based, user-friendly installer for PostgreSQL that is digitally signed and certified by 2ndQuadrant. The installer is currently available for PostgreSQL versions 9.5, 9.6, 10, 11 and 12(beta) and has the […]

Introduction to Postgres-BDR [Webinar Follow-up]

May 28, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

The announcement of Postgres-BDR 3.0 last month at PostgresConf US had been long-awaited in the PostgreSQL community. Complex use cases from customers have driven the development of BDR far beyond the original feature set, resulting in a more robust technology than ever imagined – so we’re happy to say that it was worth the wait. Postgres-BDR […]

Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)

April 30, 2018/0 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin Yildirim

I’ve started to write about the tool (pglupgrade) that I developed to perform near-zero downtime automated upgrades of PostgreSQL clusters. In this post, I’ll be talking about the tool and discuss its design details. You can check the first part of the series here: Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I). The tool is […]

2ndQuadrant at PostgresConf US 2018

April 27, 2018/0 Comments/in 2ndQuadrant, PostgreSQL /by Marriya Malik

The world of PostgreSQL continues to grow stronger by the year! Last week we saw it all come together at PostgresConf US 2018 in Jersey City. The conference was held to promote awareness and usage of PostgreSQL through tutorials and case-studies, as well as providing the opportunity to listen first hand to some of the best […]

OmniDB: Console Tab

April 17, 2018/0 Comments/in 2ndQuadrant, OmniDB, William's PlanetPostgreSQL /by William Ivanski

Introduced in OmniDB 2.6.0, the new OmniDB Console Tab provides an easy and comfortable way to interact with your databases. Users familiar with the psql command line utility will find that Console Tab behaves very similarly. In fact, many of the backslash commands Console Tab provides are present in psql. For example, \? shows a […]

Partition Elimination in PostgreSQL 11

April 11, 2018/14 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David Rowley

The feature freeze for the PostgreSQL 11 release is now upon us. During the last few days my colleague Álvaro Herrera pushed two changes into the development branch of PostgreSQL: 1. Faster Partition Pruning 2. Partition Pruning at Execution Time These patches aim to improve the performance and usability of the declarative table partitioning feature […]

Using Java Database Interface (jDBI) with PostgreSQL

April 10, 2018/0 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair Shahid

jDBI is designed to be the middle ground between high level ORMs like JPA & Hibernate on one hand and raw JDBC on the other. You can think of it as a layer of convenience on top of JDBC that is still at a lower level than ORMs. When working with JDBC, you are exposed […]

PGConf APAC 2018 – bigger & better each year

March 29, 2018/0 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair Shahid

Last week saw the 3rd event in as many years in Singapore, and yet this time something was very different. For the last 2 years, we had been conducting the conference as a PostgreSQL track with FOSSASIA. This year, we were able to pull off an entirely independent, 2-day event completely focused on PostgreSQL! The event kicked […]

Don’t be hard-headed… Harden your PostgreSQL database to ensure security

March 28, 2018/0 Comments/in 2ndQuadrant, Britt's Marketing /by Britt Cole

When it comes to database security, the risk is definitely not worth the reward. Being hard-headed about database security procedures can not only disrupt your business and cost you millions, but it can make irreparable damage to your customer relationship and public identity. How important is the security of your data to your organization Nearly […]

Data Modelling – It’s a lot more than just a diagram

Postgres Installer – A GUI based, user-friendly installer for PostgreSQL

Introduction to Postgres-BDR [Webinar Follow-up]

2ndQuadrant at PostgresConf US 2018

OmniDB: Console Tab

Partition Elimination in PostgreSQL 11

Using Java Database Interface (jDBI) with PostgreSQL

PGConf APAC 2018 – bigger & better each year

Don’t be hard-headed… Harden your PostgreSQL database to ensure security

Support & Services

Solutions

Postgres Learning Center

About Us