it's not about being the best it's about being better than yesterday
When designing a database in Postgres, one of the crucial decisions to make is choosing the primary key for your tables. Traditionally, many developers use serial (auto-incrementing integers) as primary keys. However, there’s an increasing trend in using universally unique identifiers (UUIDs) as primary keys. Each approach has its pros and cons, and in this…
It’s important to understand how database stores data internally, understanding this allows us to understand why a query runs fast or slow. Before diving in, let’s clear out some computer fundamentals, all the data on a computer is stored as streams of 1s and 0s as blocks/pages on the drive, Databases use these blocks and…
The database is used to store data and help us to query complex queries. As time passes every table becomes heavy the number of rows a particular table will increase. This will lead to a slow response of queried data. Indexing addresses this problem, what essentially an index does is sort the data in such…
ACID is the acronym for four relational database properties know as Atomicity, Consistency, Isolation, and Durability. Relational Databases provide these features and we will see why these features are needed and what they are. What is Transaction in database? The transaction is a collection of SQL statements that act as a single. Consider this transaction….
Over the years, there were many competing approaches to data storage and querying. The oldest and best-known database is a relational database, where the data is organized into relations called a table. To overcome the drawbacks of Relational Database like scalability, a document model database is introduced the term NoSql got famous. The term NoSQL…
A database is a collection of data, arranged in such a way that you can access and manage it easily. The database is vast topic concepts like index, ACID, CAP theorem, types of databases, normalization, Sharding, Consistency, MapReduce, Eventual Consistency is some of the interesting topics in this field. This blog will be a series…