Tag postgres

The Pitfall of Using PostgreSQL Advisory Locks with Go's DB Connection Pool

We have a problem! Imagine for a moment that you have a microservice written in the Go Programming Language that is deployed on more than one instance for reliabilty and...

Optimising Time Window Queries with Postgres Timestamp Range Data Types

This post explains how we were able to improve a database query performance by replacing two individual timestamptz columns with single Postgres’s tstzrange range column.

Tag database

The Pitfall of Using PostgreSQL Advisory Locks with Go's DB Connection Pool

We have a problem! Imagine for a moment that you have a microservice written in the Go Programming Language that is deployed on more than one instance for reliabilty and...

Optimising Time Window Queries with Postgres Timestamp Range Data Types

This post explains how we were able to improve a database query performance by replacing two individual timestamptz columns with single Postgres’s tstzrange range column.

Tag sql

Optimising Time Window Queries with Postgres Timestamp Range Data Types

This post explains how we were able to improve a database query performance by replacing two individual timestamptz columns with single Postgres’s tstzrange range column.

Tag go

The Pitfall of Using PostgreSQL Advisory Locks with Go's DB Connection Pool

We have a problem! Imagine for a moment that you have a microservice written in the Go Programming Language that is deployed on more than one instance for reliabilty and...

Finding Network Routing Path in Golang

This post shares our experience on finding a way to determine the network interfaces on a Linux Machine that provides the route to a particular remote machine. The use case...

Tag routing

Finding Network Routing Path in Golang

This post shares our experience on finding a way to determine the network interfaces on a Linux Machine that provides the route to a particular remote machine. The use case...

Tag postgresql

The Pitfall of Using PostgreSQL Advisory Locks with Go's DB Connection Pool

We have a problem! Imagine for a moment that you have a microservice written in the Go Programming Language that is deployed on more than one instance for reliabilty and...

Tag golang

SQLite Database Schema Migration Using Golang

SQLite is a nifty choice for client side database applications. It is serverless, works with easily accessible cross-platform database files, and does not need any installation. However, occasionally, there may...

Tag sqlite

SQLite Database Schema Migration Using Golang

SQLite is a nifty choice for client side database applications. It is serverless, works with easily accessible cross-platform database files, and does not need any installation. However, occasionally, there may...

Tag migration

SQLite Database Schema Migration Using Golang

SQLite is a nifty choice for client side database applications. It is serverless, works with easily accessible cross-platform database files, and does not need any installation. However, occasionally, there may...