Database Sharding Easily Explained (under 20 minutes)

Check out our sponsor TestSprite: https://www.testsprite.com/?via=sd ======⚡⚡⚡====== Deep dive into Database Sharding for system design — covering shard keys, different shardign strategies, sharding vs. partitioning, routing to shards, common best practices & pitfalls and production tradeoffs. Learn how sharding works in PostgreSQL, Citus, and CockroachDB, and how to design scalable and resilient databases. Consider becoming a member of the channel by joining me ❤️ https://www.youtube.com/channel/UCqAL_b-jUOTPjrTSNl2SNaQ/join ☕ Buy me a coffee: https://www.buymeacoffee.com/softwaredeveloperdiaries 🙌 Become my Patreon and get exclusive perks: https://patreon.com/softdevdiaries 💼 Follow me on LinkedIn and drop me a message if you'd like: https://www.linkedin.com/in/gadirovgs/ 💻 Also, let's connect on GitHub: https://github.com/gusgad 📚 Resources: https://www.geeksforgeeks.org/system-design/database-sharding-a-system-design-concept Partitioning: https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE 🕒 Timestamps: 0:00 Intro 0:36 What is database sharding? 2:33 Benefits of sharding 5:05 Sharding keys 7:27 Range-based sharding 8:58 TestSprite 11:08 Hash-based sharding 12:52 Geo sharding 13:47 Directory sharding 14:47 What to consider when choosing a sharding key 18:29 Challenges of sharding 22:12 When not to shard And don't forget to subscribe for more videos like this 😊 #database #systemdesign