Darsh Pateldarsh-patel.hashnode.dev·Dec 11, 2024ACID in Databases!!Introduction Databases are the most precious thing in modern computing systems, powering everything from online shopping to social media, healthcare, and financial services. At the heart of a robust database is the need for reliability, ensuring that...DiscussDatabases
Shreyansh Guptashreyanshgupta.hashnode.dev·Nov 17, 2024ACID transactions in databasesACID is an acronym that refers to 4 properties. If a database transaction has these 4 properties, it is said to be an ACID transaction. Let’s take a look at these 4 properties. Atomicity All the operations within a transaction execute as an atomic ...DiscussDatabases
Sai Prasanna Maharanasaimaharana.hashnode.dev·Oct 28, 2024SQL: An IntroductionWhat is SQL? SQL (Structured Query Language) is a standardized programming language used for managing and manipulating relational databases. It allows you to create, read, update, and delete data stored in tables, which are organized into rows and co...DiscussSQLSQL
Shreyansh Guptashreyanshgupta.hashnode.dev·Oct 19, 2024Multiple granularities of database locksMultiple granularity locking To understand this concept, first let us take a look at the structure of a database. It can be represented by the following hierarchy. Now, whenever we explicitly apply a lock at any level, all the children nodes are imp...DiscussDatabases
Vivek Khatritech.peculiarvivek.com·Sep 29, 2024DDIA - Chapter 7 - Transactions - thoughts and notesDisclaimer: This blog has been partially written by the help of LLM. The more I read DDIA the more my trust on databases is vanishing. :’) This chapter on transactions was not that interesting, honestly. Most of it was just how the keywords in ACID a...DiscussDatabases
S.S.S DHYUTHIDHARsudheendra.hashnode.dev·Sep 23, 2024Introduction to ACID PropertiesWhen we hear 'ACID,' many may first think of chemistry. However, in databases, ACID stands for four properties that ensure reliable transactions. ACID properties are crucial for database transactions as they ensure consistent performance of transact...DiscussSQL transactions
Sanjay Raisanjhiar2133.hashnode.dev·Aug 21, 2024Choosing the Right Database for Your Product: Key Technical and Non-Technical ConsiderationsWhen selecting a database for your product, it's crucial to evaluate both technical and non-technical criteria. The right choice can significantly impact your system's performance, scalability, and maintainability. Here’s a comprehensive guide to hel...Discuss·1 like#CAPTheorem
Ademola Thompsonsuperhero.hashnode.dev·Jul 23, 2024Understanding atomic transactions in Django: Ensuring data consistencyDjango is a high-level web framework that supports building robust applications quickly and efficiently. One of its notable features is its support for data integrity and consistency through built-in mechanisms that developers can seamlessly integrat...Discuss·66 readsDatabases
Yuval Aloniyuval.hashnode.dev·Jul 20, 2024Databases: The Battle for ACIDIntroduction If you've ever dealt with ANY database system you probably encountered the ACID acronym. Let's briefly go over each of the principles it describes: A for Atomicity The concept of treating something (a block of data operations in our cont...Discuss·3 likes·104 readsDatabases
DataWisokadatawisoka.com·Jul 8, 2024Choosing the right database: Large scale data growth in Postgres vs DynamoDBAs applications grow, so does the volume of data they generate and manage. Whether you're building a social media platform, an e-commerce site, or a data-driven analytics tool, handling large-scale data growth is a challenge that can make or break yo...Discusschoose the right databse