Insight for Developers

Failover of Logical Replication Slots in PostgreSQL

failover logical replication slots postgresql

Missing Piece: Failover of the Logical Replication Slot
Logical decoding capability has existed in PostgreSQL for the last several versions, and a lot more functionalities are added over time.  However, one of the very crucial functionalities is still missing in PostgreSQL, which prevents logical replication to be part of critical production environments where downstream expects […]

Read more

SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN

SQL optimizations in PostgreSQL

This is one of the most common questions asked by developers who write SQL queries against the PostgreSQL database. There are multiple ways in which a sub select or lookup can be framed in a SQL statement. PostgreSQL optimizer is very smart at optimizing queries, and many of the queries can be rewritten/transformed for […]

Read more

Working with PostgreSQL and PostGIS: How To Become A GIS Expert

postgresql postgis expert

Mastering Geographical Information Systems, better known simply as GIS, can be considered in some ways as a rite of passage. The complexities and challenges involved learning, what are ostensibly non-IT concepts, is steep. However, as they say, “there’s more than one way to skin a cat“. I’d like to share with you one way […]

Read more

Using Different Versions of a Package in an Application via Go Modules

using go modules

Sometimes you need to write an application that should use different versions of the same package, for example, the ability to work with versions v1.0.1 and v1.22.0 simultaneously. The reasons why can be different, e.g., you have a library that works only with one version of protocol, but your application should be able to […]

Read more