All Articles

PostgreSQL: Migrating INT to BIGINT Primary Keys

Step-by-step guide for altering primary key columns from INT to BIGINT in PostgreSQL, including foreign key handling and vacuum operations.

May 25, 2023 by Vinay Naik

#postgresql #database #migration +2

RabbitMQ Cluster Migration Guide

Migrating from single-node RabbitMQ to clustered mode for improved availability and throughput

May 23, 2023 by Vinay Naik

#rabbitmq #messaging #clustering +2

MongoDB TTL Index and Storage Optimization

Implementing TTL indexes for automatic document expiration and storage optimization in MongoDB NT systems

Apr 25, 2023 by Vinay Naik

#mongodb #database #indexing +3

Feed Ranking Algorithm: Balancing Recency, Affinity, and Priority Pins

Building a content feed ranking system with configurable weights for recency, user affinity, proximity, and time-limited priority pinning for admin content

Mar 27, 2023 by Vinay Naik

#algorithms #feed-ranking #content-discovery +2

RFID Partner Integration Operations Playbook

Information exchange requirements between RFID hardware vendors and platform providers for successful access control system deployment

Jan 24, 2023 by Vinay Naik

#rfid #integration #iot +3

Creating a Debug Documentation Template for Microservices

Standardized template for documenting service debugging procedures including health checks, component thresholds, and troubleshooting runbooks

Dec 14, 2022 by Vinay Naik

#debugging #documentation #observability +2

Service Debug Documentation Template

A standardized template for documenting service debugging procedures, including component thresholds and hygiene checks.

Dec 14, 2022 by Vinay Naik

#debugging #documentation #observability +2

RCA: SSL Certificate Expiry Incident

Root cause analysis of a service outage caused by expired SSL certificates, with preventive measures for certificate lifecycle management.

Nov 25, 2022 by Vinay Naik

#rca #ssl #certificates +2

S3 Image Security with CloudFront and Lambda@Edge

A pattern for serving private S3 images through CloudFront using Lambda@Edge for URL signing with time-limited validity.

Sep 26, 2022 by Vinay Naik

#aws #s3 #cloudfront +2

Event Stream Schema Design for Partner Integrations

A specification for designing generic event schemas in MongoDB to handle diverse partner integration events with retry tracking.

Jun 21, 2022 by Vinay Naik

#mongodb #event-sourcing #schema-design +2