CodeMacaw

Design a scalable, maintainable database schema with Database Normalization

Leave a Comment / Computer Science, Database, MySQL / lahin

When you build a large-scale system, you want your schema to be scalable and maintainable so that, in the future, you can extend the schema without any hassle. If your database schema contains data redundancy, then (depending on your system requirements) you will face a hard time in the future. So as engineer, it is our prime responsibility to ensure that our database schema is well-architected.

Design a scalable, maintainable database schema with Database Normalization Read More »

Understanding the 502 – Bad Gateway error

Leave a Comment / Computer Networking, Computer Science, Software Development, System Design / lahin

Throughout my experience, the error that has no proper indication about its origin was called 502 – Bad Gateway. In this post, we will understand what it is and why it occurs. The Mozilla developer guide states that,

Understanding the 502 – Bad Gateway error Read More »

Security flaws that you should aware of when building a web application

Leave a Comment / Computer Science, Software Development / lahin

Web security is one of the crucial concepts in software development. It is a set of practices that ensure your web application is protected from different kinds of attacks.

Security flaws that you should aware of when building a web application Read More »

Clean Code: Functions

Leave a Comment / Computer Science, JavaScript, Software Development, System Design / lahin

Functions play a vital role in making our code more clean, easier to understand, and easier to maintain. In this blog post, we will review the function chapter of Clean Code by Robert C. Martin.

Clean Code: Functions Read More »

Database Performance: n+1 query problem

Leave a Comment / Database, Software Development, System Design / lahin

Understanding n+1 query issue can reduce latency and improve performance.

Database Performance: n+1 query problem Read More »

Clean Code: Meaningful Names

2 Comments / Computer Science, JavaScript, Software Development, System Design / lahin

In this post you will learn about meaningful names, to make your codebase more clean.

Clean Code: Meaningful Names Read More »

Concepts that will help you understand database engineering easily

Leave a Comment / Computer Science, Database / lahin

In this post we are going to understand some basic concepts of database engineering. Those will help us to know what is actually happening at lower level.

Concepts that will help you understand database engineering easily Read More »

How do databases ensure reliability?

Leave a Comment / Database / lahin

In this post we will learn how databases like PostgreSQL, MySQL, SQLite etc ensure reliability with the help of Write-ahead Logging.

How do databases ensure reliability? Read More »

Consistency in ACID

Leave a Comment / Database / lahin

In this post we will understand Consistency in context of ACID.

Consistency in ACID Read More »

Isolation in ACID

Leave a Comment / Database / lahin

In this post we will understand how isolation works inside database.

Isolation in ACID Read More »

Atomicity in ACID

Leave a Comment / Database / lahin

Atomicity is the first principle of the ACID property. It is so important to know about that when you are designing database.

Atomicity in ACID Read More »

Continuous Deployment using GitHub Actions

Leave a Comment / JavaScript, System Design / lahin

In this tutorial we will learn about Continuous Deployment for a Node(.js)/Express(.js) app inside EC2 instance using GitHub Actions. First create an EC2 instance with Ubuntu (linux) Operating System.

Continuous Deployment using GitHub Actions Read More »

Integrate and run a Node and React application to AWS EC2 instance

Leave a Comment / Computer Networking, JavaScript, NodeJS, React / lahin

In this blog post we will learn how to integrate a Node.js and a React app to AWS EC2 instance via NGINX server.

Integrate and run a Node and React application to AWS EC2 instance Read More »

What is B-tree & B+ tree in DBMS?

2 Comments / Computer Science, Database / lahin

In this post we will go through B-tree & B+ tree, how these fit in DBMS.

What is B-tree & B+ tree in DBMS? Read More »

Understand Database Replication

Leave a Comment / Database, System Design / lahin

Understand Database Replication is crucial task for both performance and reliability.

Understand Database Replication Read More »

Understanding Subnetting of a given IP address

Leave a Comment / Computer Networking, Computer Science / lahin

In this post we will learn about CIDR notation and Subnetting in AWS VPC

Understanding Subnetting of a given IP address Read More »

Primary Index and Cluster Index

Leave a Comment / Computer Science, Database / lahin

In this post we will go through Primary Index, Cluster Index.

Primary Index and Cluster Index Read More »

Database Indexing makes DB Query faster

4 Comments / Computer Science, Database / lahin

Database Indexing is one of the most common technique to make database query faster. In this post we will learn about how indexing makes DB Query faster.

Database Indexing makes DB Query faster Read More »

JavaScript Promise Tips & Tricks

What is IPv4 IP Address?

Leave a Comment / Computer Networking, Computer Science / lahin

In Computer Networking understand the IP or Internet Protocol Address is crucial. If you are a Backend Developer or DevOps Engineer this is essential topic to understand.

What is IPv4 IP Address? Read More »