Blog
Many-to-Many Relationship in Database
In relational database design, a many-to-many relationship is a type of association where multiple records in one table are related to multiple records in another table. Many-to-many relationships ...
One-to-One Relationship in Database
One-to-one relationships in the database are important when organising data so that each record in a table can relate to just one record in another table.
Search insert position
Given a sorted array of distinct integers and a target value, return the index if the target is found. If not, return the index where it would be if it were inserted in order.
One-to-Many relationship in Database
One-to-many relationship in the database are important when organising data so that each record in a table can relate to multiple records in another table.
Difference between DELETE, TRUNCATE and DROP
When managing a database, data removal is a common task that needs careful consideration. SQL offers several commands to remove data or database objects, each serving different purposes. In this ar...
Types of SQL Statements: A Guide to DDL, DML, DCL, TCL, and DQL
In this comprehensive guide, we break down Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Language (TCL), and Data Query Language...
Setup Vitest with React for unit testing (replace Jest)
Vitest is fast and really good when used with Vite which developers are preferring nowadays. It is a good alternative to Jest for a better experience.
The best free resources to learn web development
Web development means developing websites or web applications which also includes developing APIs, designing UI/UX, database design and many more. It consists various technologies like HTML, CSS, J...
Data fetching in Next.js
Next.js provides various ways to fetch data from an API or any other source. These methods can be used to either generate static pages(SSG) or for server-side rendering(SSR). getStaticProps, getSta...