Adopting a Modular Monolith with Event-Driven Architecture to Handle Time-Consuming APIsHandling time-consuming APIs in a monolithic architecture can be a significant challenge, often leading to server timeouts and poor user…Jan 12Jan 12
Why Auto-Increment IDs are Challenging for ScalabilityIn the world of database design, auto-increment IDs are a simple and intuitive way to generate unique identifiers for records. While they…Jan 11Jan 11
PostgreSQL for Writes, While MySQL for Reads?When deciding between PostgreSQL and MySQL for a project, developers often encounter the idea that PostgreSQL is better suited for writes…Jan 1Jan 1
Horizontal Scaling — NoSQL vs. Relational DatabasesOne of the major advantages of NoSQL databases over relational databases (RDBs) is their ability to scale horizontally, which is also…Dec 26, 2024Dec 26, 2024
What is a Columnar Database and Why is it Strong for Writes?A columnar database is a type of database that stores data by columns rather than rows. Unlike traditional row-oriented databases (such as…Dec 22, 2024Dec 22, 2024
Why is consistent hash effective for distributed systems?Understanding Consistent Hashing: A Comparison with Modular HashingDec 21, 2024Dec 21, 2024
Investigations on B-tree and B+treeChoosing the Right Database Index: Understanding B-tree vs. B+treeOct 22, 2024Oct 22, 2024
Time zone is crucial for One Time PasswordDeveloping two factor authentication, I got an error where the password didn’t pass, even though the logic was right.Sep 19, 2024Sep 19, 2024
Consider about where to store an endpoint before deciding to use API gateway.I have been studying AWS recently, and I managed to come up with an idea of a service. However, I gave it up. I’ll summarize the story.Sep 7, 2024Sep 7, 2024