InStackademicbyCrafting-CodeTechniques for optimizing SQL queries in a high-traffic applicationLesser-known techniques for optimizing SQL queries in a high-traffic application, especially when dealing with complex joins and indexing…Aug 14, 20236Aug 14, 20236
InLevel Up CodingbySDE Story CraftingZero To Million Users (Part 4) : Database ReplicationNow that load is balanced(part 3), what about data loss protection? Let’s dive into a more fun and thought-provoking part of the system…Apr 16, 20231Apr 16, 20231
Nikhil SukhaniThe Power of Stored Procedures: How to get the most out of your SQL QueriesWhat are stored procedures?Dec 31, 2022Dec 31, 2022
InLevel Up CodingbyArslan AhmadMaster the Art of Data Partitioning for System Design Interviews: A Complete GuideA Comprehensive Data Partitioning Guide for Acing System Design Interviews.Mar 23, 2023Mar 23, 2023
Aayush SainiIsolation Levels in ACID Properties | System DesignIn the ACID Properties, The “I” Stands for Isolation provides the property of the particular transaction executed independently from the…Mar 11, 20231Mar 11, 20231
Burak KOCAKOptimizing PostgreSQL Database PerformanceManaging the performance of a PostgreSQL database with millions of transactions every week requires careful planning, monitoring, and…Mar 9, 20231Mar 9, 20231
InTowards Data EngineeringbyAyush DixitDesign a database to store large amounts of historical data that needs to be regularly analyzed.This is the most frequent question that comes to our mind when we start designing the database of any analytical system. Today in this blog…Feb 19, 2023Feb 19, 2023
InTowards Data EngineeringbyAyush DixitData Modeling: Design the data model for a taxi service like Uber.In this article, we will design a data model that can capture all critical data elements including trips, ratings, documents, driver…Mar 7, 20234Mar 7, 20234
InComputer Science FundamentalsbyLarry | Peng YangSystem Design — StorageStorage concepts and considerations in System DesignApr 15, 20204Apr 15, 20204
InTDS ArchivebyZixuan ZhangDatabase Replication ExplainedPart 1 — Single Leader ReplicationNov 9, 20211Nov 9, 20211
Sagar AroraDatabase designDatabase design is one of the most important skill for a software engineer. You will be working with data in-and-out and is important to…Dec 14, 2022Dec 14, 2022
InDev Learning DailybyThe Educative Team7 Tips for Query Optimization in SQL ServersWhen optimizing performance, developers and architects often overlook tuning their SQL queries. Understanding how databases work and…Jan 31, 2023Jan 31, 2023
InTowards Data EngineeringbyAyush DixitDatabase Design for Spotify.In this series of Database Designs, I have already discussed two case studies. You can check out those blogs.Feb 1, 20232Feb 1, 20232
InTowards Data EngineeringbyAyush DixitDatabase Design for a food delivery app like Zomato/SwiggyAfter reading my last blog on Database Design of systems like LinkedIn. I hope you got an understanding of the basic building of database…Jan 30, 202310Jan 30, 202310
