Pgpool‑II with PostgreSQL RDS: Setup Guide and Why Amazon QuickSight Skips Memory Cache
When integrating Pgpool-II with PostgreSQL RDS, many administrators notice an interesting behavior…
How We Eliminated SSL Costs in OCI LB and API Gateway
When running production workloads on Oracle Cloud Infrastructure (OCI), HTTPS is mandatory…
Keycloak 26.2.4 Installation Guide (VMware Linux)
XYZ Solutions is a fast-growing SaaS provider in the financial services industry. Their platform manages sensitive customer and transaction data for multiple clients across regions.
Row-Level Security (RLS) in PostgreSQL: A Complete Guide
When building multi-tenant applications or securing sensitive data, PostgreSQL’s Row-Level Security (RLS) is a game-changer…
Secure AWS Access with GitHub Actions Using OIDC
GitHub Actions can access AWS resources via OIDC (OpenID Connect), eliminating the need for long-term IAM credentials…
Ensuring Zero Downtime: On-Prem High Availability Docker Swarm Setup with Proxmox
Maintaining high availability (HA) in a Docker Swarm cluster is crucial for production-grade deployments. In this blog…
Automating PostgreSQL Backups to Amazon S3 Using Shell Script
Database backups are an essential part of any data-driven application. Automating this process not only saves time…
Automatically Register GitHub Actions Self-Hosted Runners via Terraform and Shell Script
Dynamically register a GitHub Actions self-hosted runner using Terraform and a shell script. This approach ensures that
Triggering AWS Lambda from S3 Uploads with Terraform
AWS Lambda allows you to run code without provisioning or managing servers. In this guide, we will integrate AWS Lambda with Amazon S3 to trigger a function
Efficiently Managing AWS S3 Files at Scale with Node.js
In a recent project, we needed to process and manage a vast amount of data stored in AWS S3. Our challenge? Handling over 7,000 company IDs and more than 100,000 files while ensuring efficient retrieval, filtering, and management of the latest relevant files.