Database Indexing (Minute Engineering)

In this Youtube Stories I discuss database indexing, b-trees, why indexing can slow down writes and wear down your SSD if you are not careful.

🏭 Software Architecture Videos

💾 Database Engineering Videos

🛰 Network Engineering Videos

🏰 Load Balancing and Proxies Videos

🐘 Postgres Videos

🚢Docker

🧮 Programming Pattern Videos

🛡 Web Security Videos

🦠 HTTP Videos

🐍 Python Videos

🔆 Javascript Videos

Support me on PayPal

Become a Patreon

Stay Awesome,
Hussein

[Nurckye]

Cool videos, make more of those. It's cool to listen to this kind of short vids in the subway or in the morning. All the best!

[mzaman]

Very Educational! Eid Mubarak brother!

[jivanmainali]

how should we model our databse for follower following as that of social media site??

[IBITZEE]

good rant... but:

there is much... much more to say about indexes, , ,
single field, composite indexes, indexes for blob/text (index a digest(ed) key), , ,
indexes in distributed databases and how to deploy and maintain consistency...
indexed for shards... how can we maintain integrity between shards...

In new OS(s), the FS will have the responsability to manage the solid-state disk cells (like Apple ADFS... TRIM.. ???)
so this is not a concern for indexes/logs/etc...

about a true modern DB Engine is not feasible to hold a pointer to a row
(or calculate the row position obtaining a index*record-size like in old DB engines)
the internal engine will only work using the primary key (who generally is auto-indexed)

waintin' a video touching this few topics above...
Thx

[sundaramjha]

If u can create a video on Where the database data get stored in the file system. Format of file an all. For Db like mysql, postgres & mongo. Because interview they also ask this question, So people will get help from ur video.

Its my suggestion, because u always say i learn new things from comment.
If u think its good topic so u pick & create video.

Love ur videos. Thanks from India.

[zummotv]

Hussein if you had to design database for Youtube, where you have your personal videos that can be private or public, then you have videos on your homepage and all other functionality. What will be your approach for Youtube database design? Please make a video on this. Love your content.

[mohamadabujafari]

Great Video Hossein😍. THANK YOU for sharing your knowledge with us. can u share us about database design more?

[prashanthkumar]

Integer searchs are easy .

But how does real search like finding a user's record by email id, or username would work...

and how about LIKE clause ...
how does that kind of searching works ..

Please if you can explain it, because i am unable to find anything related that . atleast that i can understand....

[rajath]

What's your take on postgres for the same ?