Foreign Keys and Performance: Things You Might Not Know in RDBMS
A FOREIGN KEY in a relational database management system (RDBMS) is a constraint used to…
All topics
AI & Machine Learning
Tips
A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices
Introduction As your application scales and serves multiple tenants, choosing the right multi-tenancy architecture is…
AI & Machine Learning
Ruby
Ruby on Rails
Tips
Multi-Tenancy in Rails: Best Practices and Approaches Comparison
Introduction As your Rails application scales, you may need to serve multiple tenants while ensuring…
AWS
Ruby
Security
Tips
Best Practices for SSH Access with AWS Session Manager on EC2 – 2024
Simplifying EC2 Host Management with AWS Session Manager Managing EC2 instances can sometimes be complex,…
Architecture & Design
Docker
Traefik with docker – The Modern Reverse Proxy
If you're working with microservices, containers, or cloud-native applications, chances are you've come across reverse…
Architecture & Design
Docker
Tips
How to Migrate Nginx to Docker with Traefik as a Reverse Proxy
1. Problem I'm currently running Nginx on my Ubuntu server to host my Rails application.…
AI & Machine Learning
REST vs gRPC: A Detailed Comparison for High-Performance APIs
RESTful APIs and gRPC are two popular approaches for building distributed systems and services, but…
Database
PostgreSQL
Understanding PostgreSQL WAL and How It Can Save Your Data
PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity,…
Database
MySQL
Buffer Cache Hit in MySQL: What It Is and Why It Matters
The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data…
Database
MySQL Indexes: Boosting Query Performance with Column Order
In MySQL, the order of columns in a composite index (an index that spans multiple…