Indexes in SQL
database

Introduction to Indexes in RDBMS

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…

ruby

Send keyword in Ruby

Recently I have been introduced to ruby, while working on the project I saw this function is been used many times in our existing codebase. Let’s discuss what problem it solves. Consider you want to call a list of functions dynamically, eg. Consider an interaction to list animals data which takes the animal name as…

ACID
database

Introduction to ACID

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….

Database
database

Types of Databases

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…

database

An Introduction to Database

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…

Tech

SOLID principles in C#

Have you encountered a codebase where a single class/module doing so many things and any small change in a module breaks another and you think to yourself how this happened, if only you knew how to prevent this in the first place? Or a case when a senior developer reviews your PR and says move…

Tech

with_options in rails

I have recently encountered this method, which saved my time and helped me follow the DRY principle Use case: Consider a scenario, you have a list of trains and you have to apply filters on like depature_time, arrival_time, train_number, arrival_station, depature_station, number of coaches, etc. For that, you have to write interaction. The input will…