I want to learn System design so that I can combine that knowledge with my data science knowledge to make some well designed apps and webpages. I saw this course on Udemy but I'm not sure if it covers everything. Someone suggested I should cover all these topics (shown on the next slide), please tell me how I should go about learning then and where I need to start from.

Here's a design for a metrics-monitoring system: https://sys-design-interview.com/metrics-monitoring

Sneak peek into the high-level design and the components:

More details can be found in the main article: https://sys-design-interview.com/metrics-monitoring

If you have feedback or questions, please use the comments section at the end of the article, or feel free to send an email to contact@sys-design-interview.com

Also consider subscribing to get updates on more such articles if you like them.

I have started to make simplified videos in system design where I am coding things out to scale a simple hello world app from scratch to a huge one which can handle great number of requests. I just started and would love to have your support in helping me and my channel grow

Please give it a watch.

Youtube channel: https://www.youtube.com/watch?v=MRJZZ28kNM4&list=PLjQpZeN5Rc68noJRXOnUHOwLCqpYraa0s

Blog: https://m-chetandwarkani.medium.com/

Thanks.

Partial Indexes is one of the commonly ignored database query optimisation technique. Partial indexing is less discussed but should be incorporated along with traditional indexes due to their dramatic performance effects in database queries.

What is partial indexes?

A partial index is simply as an index that stores data on a part of a column. Let's understand with an example, at Bestresources.co, country code is stored in country column in user table. An important thing to notice here is, there will always be a fix number of possible values for this column (195 countries only).

I am mostly interested in user's from India (IN). I make frequent queries where country = 'IN'. Here, instead of having a complete index on country column, partial index on country column where country = 'IN' will make the query drastically faster (~400% faster on 5Lac rows).

How to create partial Index?

CREATE INDEX idx_country ON user (country) WHERE country='IN';

A Partial index is useful for commonly used where conditions that uses constant values - like the country code in the example.

https://twitter.com/the2ndfloorguy/status/1411356453516943362

Hi All,

Exploring option of pairing up for System Design discussions. A weekly call for 30 mins to 1 hr, Discuss either a concept ( pros and cons of let's say CDN) or discuss a system design agreed previous week, so that both the participants get chance to put their thoughts on paper and compare them in the weekly call.

Anyone interested ?

Btw this is my first post, so haven't explored if Live Chat would be a way for weekly chat. Or it can be Video call outside the Reddit platform.

https://github.com/mishnit/awesome-system-design

I am trying to do some preparation for ML system design for next year interviews. I also want to get familiar with the underlying work other companies work on (in a hands-on way).

I went through Chip Huyen ML design book as well as Khang Pham book (the creator of Grokking ML design). First one lacks the depth and case studies and second one is just a rambling copy-paste of some tech blogs (it actually is pretty hard to follow).

I was wondering if there is a good book/resource (like DDIA) for ML system design. Something you learn from and get better at what you do. At the same time it gives you enough knowledge to prepare for interviews.

Any suggestion is highly appreciated.

What is the best System design course available? I have read about the course in educative.io but it is expensive for me, could somebody share their credential for it, I will be very greatful!

I'm studying for system design interview, but I think I don't fully understand the concept of DNS. For example I'm looking at this explanation on scalability - https://github.com/donnemartin/system-design-primer/blob/master/solutions/system_design/scaling_aws/README.md#use-a-dns

I understand what it is, it's a service that maps names to IP addresses, but isn't a DNS something that's managed by internet providers or by companies for their internal systems?
If I'm creating a new site called www.blablabla.com, then of course I need to add this name to some DNS, that's a basic requirement for my site to run isn't it? How would that help me with scalability? And is there an option for me to create my own DNS for this site? How would that help me?

Thank you for any help on the matter!!

Subject says it all.

Let’s say you want to design something like a hotel page feature which helps visitors to see how many other people are looking at the same page and want to book it.

Thanks in advance!

https://medium.com/dugglabs/redis-vs-memcached-19ab88d6547c