System Design Codex (@ProgressiveCod2)

Amazon found that every 100 milliseconds of latency cost them 1% in sales. Google found an extra .5 seconds in search page generation time dropping the traffic by 20%. These are staggering implications. If there’s just one thing you can optimize your system for, I’d recommend trying to go for low...

6 Must-Know Concepts of RESTful APIs (also the reasons why REST is so popular) [1] Stateless Each request is independent of the other request. The server doesn't store any info about the user between requests. [2] Standard Response Formats Responses are sent in standard formats such as JSON, XM...

The acronym ACID in the context of DB transactions stands for Atomicity, Consistency, Isolation, and Durability. This post is going to make each term crystal clear. ✅Atomicity (A) Atomic means something that cannot be broken down. It’s the same thing that our Physics teachers tried to tell us m...

9 points on how Discord stored trillions of messages: [1] In 2017, Discord migrated from MongoDB to Cassandra. [2] Over the next few years, its DB cluster grew from 12 to 177 Cassandra nodes. [3] The Cassandra cluster ran into serious performance issues. Few reasons for this: 👉 The Partitioning ...

12 database types you can use in 2024 and when to use them: 1 - Relational Databases (SQL) - Ideal choice when your data is structured and needs to be consistent - Supports ACID transactions and complex relational queries - Examples: MySQL, PostgreSQL, CockroachDB 2 - Document Databases - Handle...