A collection of technical research, thoughts, and problem-solving case studies in Software Development.
Tech Note
Practical Guide to Login Security: Backend & Frontend
Explaining what to consider when implementing a login feature from a security perspective (Frontend and Backend).
Case Study
Zero Downtime Database Migration
How to migrate from a SQL database to NoSQL in a production system without disrupting active users.
Understanding Callback Hell and Promises
An in-depth explanation of what Callback Hell is in JavaScript, and how Promises and Async/Await solve it.
Database Replication Strategies: Master-Slave & Master-Master
Why do we need database replication? Explanation of replication types and when to use them.
CDN: What It Is and When to Use It
An in-depth explanation of how CDNs work, complete with a diagram, and when to best use them for your website.
PostgreSQL: Aggregating Rows into Arrays
How to solve row duplication issues when performing JOINs on One-to-Many relationships using ARRAY_AGG() and JSON_AGG() in PostgreSQL.