PostgreSQL User Management: A DBA Tool Built for Everyone Managing PostgreSQL roles and privileges is powerful but notoriously opaque. This tool wraps every psql command you would ever need into a guided, eight-page Streamlit application so your entire team can operate safely, without memorising SQL syntax. The Problem With psql for Non-DBAs PostgreSQL has a […]
Logs, Metrics, and Traces: Making Sense of the Observability Buzzword The tech industry sometimes becomes fascinated by a fresh buzzword every so often, and at the moment it is observability that is having a dominant influence. If you spend a sufficient amount of time going through the way vendors market their products, you might come […]
Why a GKE Ingress can look fine in kubectl and still have no IP — and how that differs from EKS and ALB If you have used EKS, HTTP Ingress usually means an Application Load Balancer. Someone installs the AWS Load Balancer Controller, you set ingressClassName: alb, and AWS creates an ALB. Certificates often come […]
Introduction When building microservices, one question comes up quickly: How should one microservice communicate with another? Should it call a REST API and wait for a response, or publish an event and let other services react asynchronously? There is no universal answer. Both approaches solve different problems. As a developer, I prefer starting with the […]
How do you redirect thousands of customer subdomains in AWS? Without creating an ALB rule for every customer? A few weeks ago I got handed something that sounded like a non-issue. Redirect a subdomain to a path. One line in the ticket, basically. I assumed I’d knock it out before lunch, and instead spent most […]
Introduction This blog provides step-by-step instructions to implement centralised AWS Backup across an AWS Organisation using Terraform. Backup policies are managed from a dedicated DevOps Tooling account using Delegated Administration. A CloudFormation StackSet automatically deploys the required IAM role and backup vault to all member accounts. Org-level backup policies are attached to the Production and […]
The Problem Every team eventually hits the same failure mode: a new build goes out, the application starts, and it immediately breaks because a required schema change wasn’t applied first. Maybe someone forgot to run the SQL script. Maybe it ran against the wrong environment. Maybe it ran after the app already tried to query […]
Introduction In a 24×7 Managed Services environment, incident management is critical to maintaining service availability, meeting SLAs, and ensuring a consistent customer experience. However, increasing infrastructure complexity and alert volumes make fully manual incident management difficult to scale. Automation provides an opportunity to make incident management faster, smarter and more proactive. From Reactive to Proactive […]
As your data grows and your user base expands, your Amazon Redshift cluster faces increasing demands from concurrent queries. Without proper management, this can lead to performance bottlenecks, longer query times, and frustrated users. Fortunately, Amazon Redshift offers a feature called Concurrency Scaling to address exactly this problem. This post covers what it is, how […]
