Reload in ruby and when to use it.

Consider we have a model student when we access data from this using the following command. The variable student contains the data of a student. Each student has enrolled in many courses, which is another model. On printing the student, we get the following data Consider if I update the course model, The expected behavior…

Indexes in SQL

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…


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…


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


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…


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…


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…