Aryaman Guptaaryamangupta.hashnode.dev·Apr 14, 2024Demystifying Replication and Sharding in MongoDBMaking a MongoDB cluster "Production Ready" by performing database Replication and Sharding (horizontal fragmentation) What is Replication? Replication is the method of duplication of data across multiple servers. For example, we have an application ...Discussreplication
Raj Kasaudhanrajkasaudhan.hashnode.dev·Mar 29, 2024Understanding N+1 Query TroublemakerEver feel like your database is hiding your info? Like it takes forever to answer your questions? That's the sneaky N+1 query problem causing problems you didn't even know about. In the world of databases, speed is key. When you have a website or app...DiscussDatabases
SOURAV BERAsouravtechzone.hashnode.dev·Feb 29, 2024Mastering Database Design: Navigating Anomalies and NormalizationSituation: Imagine you're tasked with developing a database system for a new e-commerce platform. Your goal is to create a robust and organized database structure that can efficiently handle large volumes of transactional data while ensuring data int...Discuss·1 likeAnomalies
SOURAV BERAsouravtechzone.hashnode.dev·Feb 28, 2024Unlocking Database Design: Mastering ER Diagrams and Understanding CardinalityIntroduction to ER Diagrams: An Entity-Relationship (ER) diagram serves as a blueprint for database design, showcasing the relationships between entities within the system. This visual representation elucidates how various entities interact with each...Discuss·11 likesERDiagrams
Jatu Naazneennaazweb.hashnode.dev·Feb 18, 2024Data Organization: Flattened vs. Nested Foreign KeysOrganizing your data effectively is crucial for a smooth-running platform, particularly when managing multiple tables. One key decision you'll face is choosing between nested foreign keys and flattened foreign keys to establish relationships among th...DiscussDatabase DesignDatabases
Victor OhachorforThe Hexed Engineer's Inkwellpoeticmaniac.hashnode.dev·Feb 14, 2024Database RelationshipsOverview For every backend developer, it is crucial that you understand how to store application data in a way that allows for data consistency, minimizes redundancy, and preserve the integrity of your data. Hence, knowing how to use an ORM library a...DiscussDatabase Diablerie: The Hexed Book on DatabasesDatabases
Jatu Naazneennaazweb.hashnode.dev·Feb 4, 2024Database Design Dilemma: Single Table Simplicity vs. Joined FlexibilityBuilding a robust and efficient database requires careful consideration of how to store and access your data. One key decision lies in choosing between the simplicity of a single table and the flexibility of multiple tables connected by joins. Scenar...Discuss·3 likes·44 readsDatabase Designdatabase design
Ian Carsoniancarson.hashnode.dev·Jan 15, 20245 Database Lessons I learnt the hard way.Some of the lessons and patterns that are called standards or best practices, came as result of several years of experiences and in some cases, studies. I have had my fair share of tough lessons that I learnt the hard way. Below are a couple of the l...DiscussDatabases
Ian Carsoniancarson.hashnode.dev·Dec 27, 20235 Critical Rules to design a good database.A good and performant database is not an accident, neither a Miracle. It is a combination of proper planning and execution. The more experienced one is with dealing with Databases, the better the design and the higher the chances that the database wi...Discuss·1 likeDatabases
Prudviprudvi.hashnode.dev·Dec 27, 2023How to choose right database for your projectPicking the right database for your project is very important which can make your app fast, easy to use and maintain. This article explains how to pick the right one, with real-life examples to make it super clear, no matter if you're new or a pro! A...DiscussDatabases