so this is transactional replication but for each individual table?

I am sorry but that bgm is really irking me

Woow, you have even shared your noted!! That's perfectly perfect!

Thank you so much Irtiza, that's pure Gold content!! Every sec was full of informarion!! Subscribed!

As a Frontend dev, you're videos have been pivotal in my understanding system design. You explain everything so well! I wish you had more fullstack SD videos... I could watch your videos all day!

Wow, this is one of the best videos on system design I've seen. This was super well organized and thought out. I really appreciate the clear explanations!

Okay, so I'm rewatching this. We said at the beginning that guests are not booking actual rooms rather, it is a room type they are booking, that makes sense. Now the issue of multiple guests booking the same seems irrelevant here, dont you think. A reservation is for a particular room type in a particular hotel. For example Hotel XYZ has 50 King Size Room types, recorded in the room_type_inventory table yeah? So if guest A books one of such room types in Hotel XYZ, we have 49 left right? At this point guest A has no idea what the room number is until they are checking in, most likely at the hotel front desk. So what I am saying is, guests booking the same room does not apply, since they are only able to book a room type in advance. What am I missing?

11:50 let me clarify, this is a very compound PRIMARY KEY <PARTITION KEY, league, kit_number, position, goals> with a PARTITION KEY <name, club>?

Amazing videos and great explanations. Awaiting for new videos.

Mentioning the consistent hash ring should be a necessity for intro to cassandra videos

Another question partaining to partioning. So one of the functional requirements is that a user should be able to search for a room by a given date range. Would it be right to partition the table in question by date field?

Great!

In the case where multiple users are trying to make a booking or reservation for the same room, wont the reservation status suffice instead of using the optimistic locking approach or db constraint? Let's say the status is an enum {'available', 'pending', 'payment_completed'} as an example, if the status is not `available` then it can be reserved. Wouldn't that be sufficient to avoid multiple booking?

Thank you :)

the best explanation

Albert Spur

can i used this design for RAG system in production for real time update postgres to vector database?

Anthony Isle

Lots of conflict in your talk. If user A pushes its message to its channel, and A's subscribers go to pull the message themselves, why does A need to look up which friend is online and then determine if A needs to push message or not.

Ortiz Drives

Robert Turnpike

Mine is saying no module named redis. So how do I troubleshoot it??

Stanton View

Can you do api calls with the self host version?

Thank you, this was a basic demo, but a really good one!

Thank you Man, really enjoyed it.

Jackson Trafficway

Great content!

Thanks for the tutorial! I learned a lot from it!

Nice video, but 30% of the screen is wasted.

Hi Irtiza, Thanks for the video. Just wondering, could there be any cons/trade-offs for using cache instead of MySQL DB?

how do you search for availability of rooms given a date range and city or location?

Thats a clear and crisp video. You have such structured system design videos of why you chose which design. Thanks for the great work!

it's fair that you could also mention that the original source is "System Design Interview - An Insider's Guide (Volume 2)" By Alex Xu

Really outstanding you start from brute force and then add components for optimization that Really alot for us thank for making such great quality videos

nice and simple, Thanks so much

Great explanantion. To serve more read, we can create secondary noes of db (CQRS).

brilliant

very nice. How are you writing the code and suddenly it's one auto corrects to one line and then auto corrects to headers of the table?

Sir ek create karke bata hi diye hote

What are some of the tools that provide CDC? Does databases provide it? or Are there any generic services?

wow finally a video tutorial on kafka with code

How do I configure my AWS with this Serverless framework?

Do you have a GitHub account? I’d like to follow you there for any updates on FastAPI projects.

this is the first time i understand how Nginx works thanks for this amazing video please can you make a video how to deploy multiple docker on same server?

upload more videos. good qulity videos overall.

What is this crap ?

This is an extremely rich and high quality video. I stumbled upon this by chance when I was searching for some info about Debezium for some project we might be interested in. Interestingly enough, the files provided in the video description did not quite work for MAC and it took about 2 days to make the required adjustments including getting the correct images and port configuration, network configuration etc. but in the end things worked. My experience was that I learned a lot as I went through the process, not just about Debezium but a great deal of other things on what docker-compose structure, network dependency, port issues and all that. So it was worth. Kudos to Irtiza for taking all efforts to put together such as amazing tutorial....!!

where is the code example??

please add url for video notes.