Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database faster, and improve your application’s performance.
0:00 Intro
0:05 Example database table
0:15 Example query
0:21 The problem with a full table scan
0:50 Using EXPLAIN ANALYZE
1:04 What is a SQL index?
1:17 How to create a single-column index
1:37 How to create a multi-column index
2:08 Optimizing our SQL query
2:31 Caveats of sql indexes
What’s an API gateway? It is a server that exposes internal service APIs to external client devices, using a protocol like HTTP.
The gateway also uses design patterns like REST and GraphQL to expose APIs, which allow clients to get and update data through servers with databases.
In this video, we will talk about API gateways, their use cases, and how they work with CDNs and DNSes to ensure fast and reliable user request handling.
How does Uber handle real-time ride-sharing for millions of users? In this video, we design an Uber-like system, focusing on core components like APIs, database structure, real-time communication with WebSockets applying the principles of Event Driven Architecture. Learn how ride requests are processed, drivers are matched, and real-time updates are sent—all using an event-driven architecture and technologies like Kafka. Perfect for system design interviews or understanding scalable application architecture.
Timestamps:
0:00 – Introduction
0:43 – Clarifying Requirements and Scope
1:35 – API Design and Key Endpoints
3:47 – Real-Time Communication with WebSockets
4:08 – Database Design: Relational vs. NoSQL
10:31 – Event-Driven Architecture
13:10 – Detailed Workflow Example
13:58 – Real-Time Updates During a Ride
14:10 – WebSocket Session Management
15:46 – High-Level System Overview
18:30 – Future Enhancements
n this video, we’ll break down Event Driven Architecture (EDA) pattern and dive into real-world case studies from Netflix and Uber, who leverage EDA to handle billions of events daily.
Learn how EDA decouples services, enabling scalable, flexible, and efficient systems. We’ll also cover key components like Event Producers and Event Consumers, along with advanced concepts such as Complex Event Processing. Discover the advantages of using EDA alongside other patterns like Service Mesh and Sidecar Pattern.
If you’re looking to build scalable, real-time systems, this is the perfect video for you! Don’t forget to subscribe for more in-depth software architecture insights.
Timestamps
00:00 – Introduction to Event-Driven Architecture
00:30 – The need for EDA in modern systems
01:48 – EDA components: Producers and Consumers
02:29 – Netflix and Uber: Real-world EDA use cases
04:21 – EDA, Service Mesh and Sidecar pattern
05:53 – Event Processing: Simple and Complex
07:30 – EDA Challenges
07:55 – EDA Tooling: Kafka, SQS and RabbitMQ
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.
We are a professional review site that has advertisement and can receive compensation from the companies whose products we review. We use affiliate links in the post so if you use them to buy products through those links we can get compensation at no additional cost to you.OkDecline
960 Comments
Tomi Engdahl says:
Top 7 Ways to 10x Your API Performance
https://www.youtube.com/watch?v=zvWKqUiovAM
Tomi Engdahl says:
SQLite vs PostgreSQL Performance
https://www.youtube.com/watch?v=VzQgr-TgBzc
PostgreSQL vs SQLite Performance Comparison.
0:00 Intro
0:37 SQLite vs PostgreSQL Comparison
3:49 Test Design
6:30 Implementation Overview
7:13 1st Test (INSERT – UPDATE – DELETE)
11:59 2nd Test (SELECT)
Tomi Engdahl says:
What is RPC? gRPC Introduction.
https://www.youtube.com/watch?v=gnchfOojMk4
Tomi Engdahl says:
API Pagination: Making Billions of Products Scrolling Possible
https://www.youtube.com/watch?v=14K_a2kKTxU
Tomi Engdahl says:
7 Must-know Strategies to Scale Your Database
https://www.youtube.com/watch?v=_1IKwnbscQU&t=13s
SQL indexing best practices | How to make your database FASTER!
https://www.youtube.com/watch?v=BIlFTFrEFOI
Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database faster, and improve your application’s performance.
0:00 Intro
0:05 Example database table
0:15 Example query
0:21 The problem with a full table scan
0:50 Using EXPLAIN ANALYZE
1:04 What is a SQL index?
1:17 How to create a single-column index
1:37 How to create a multi-column index
2:08 Optimizing our SQL query
2:31 Caveats of sql indexes
Tomi Engdahl says:
What is an API Gateway?
https://www.youtube.com/watch?v=RbMxB_Cyx6A
What’s an API gateway? It is a server that exposes internal service APIs to external client devices, using a protocol like HTTP.
The gateway also uses design patterns like REST and GraphQL to expose APIs, which allow clients to get and update data through servers with databases.
In this video, we will talk about API gateways, their use cases, and how they work with CDNs and DNSes to ensure fast and reliable user request handling.
Some of their most common use cases are:
1. Authentication and Authorization
2. Request Transformation
3. Request Validation
4. Rate Limiting
5. Routing
6. Load Balancing
Tomi Engdahl says:
Uber System Design | Websockets and Event Driven Architecture
https://www.youtube.com/watch?v=2WYjtfRyHzQ
How does Uber handle real-time ride-sharing for millions of users? In this video, we design an Uber-like system, focusing on core components like APIs, database structure, real-time communication with WebSockets applying the principles of Event Driven Architecture. Learn how ride requests are processed, drivers are matched, and real-time updates are sent—all using an event-driven architecture and technologies like Kafka. Perfect for system design interviews or understanding scalable application architecture.
Timestamps:
0:00 – Introduction
0:43 – Clarifying Requirements and Scope
1:35 – API Design and Key Endpoints
3:47 – Real-Time Communication with WebSockets
4:08 – Database Design: Relational vs. NoSQL
10:31 – Event-Driven Architecture
13:10 – Detailed Workflow Example
13:58 – Real-Time Updates During a Ride
14:10 – WebSocket Session Management
15:46 – High-Level System Overview
18:30 – Future Enhancements
Tomi Engdahl says:
Unlock the Power of Event-Driven Architecture: How Netflix & Uber Handle Billions of Events
https://www.youtube.com/watch?v=hrvx8Nv9eQA
n this video, we’ll break down Event Driven Architecture (EDA) pattern and dive into real-world case studies from Netflix and Uber, who leverage EDA to handle billions of events daily.
Learn how EDA decouples services, enabling scalable, flexible, and efficient systems. We’ll also cover key components like Event Producers and Event Consumers, along with advanced concepts such as Complex Event Processing. Discover the advantages of using EDA alongside other patterns like Service Mesh and Sidecar Pattern.
If you’re looking to build scalable, real-time systems, this is the perfect video for you! Don’t forget to subscribe for more in-depth software architecture insights.
Timestamps
00:00 – Introduction to Event-Driven Architecture
00:30 – The need for EDA in modern systems
01:48 – EDA components: Producers and Consumers
02:29 – Netflix and Uber: Real-world EDA use cases
04:21 – EDA, Service Mesh and Sidecar pattern
05:53 – Event Processing: Simple and Complex
07:30 – EDA Challenges
07:55 – EDA Tooling: Kafka, SQS and RabbitMQ
Tomi Engdahl says:
IPC: To Share Memory Or To Send Messages
https://www.youtube.com/watch?v=Y2mDwW2pMv4
Tomi Engdahl says:
CICD Pipeline | System Design
https://www.youtube.com/watch?v=su3-fAEePs0&list=PLJq-63ZRPdBssWTtcUlbngD_O5HaxXu6k
In this video we will understand and design a CICD (Continuous Integration and Continuous Delivery) Pipeline. This is taken from Ex-Googler interview,