Indexes Are Not a Magic Wand, They Have a Cost.
Database indexes work like the index at the back of a textbook. Instead of scanning every single page (a full table scan), the database checks the index to locate the exact page (disk block) where the

Search for a command to run...
Database indexes work like the index at the back of a textbook. Instead of scanning every single page (a full table scan), the database checks the index to locate the exact page (disk block) where the

If Your Query Is Complicated, It May Be More Efficient The principle “If your query is complicated, it may be more efficient” sounds quite counterintuitive. It is expected that simpler queries run fas

Rows Returned measures the final result returned to the client. Rows Examined (or scanned) measures how much data the database execution engine had to load and inspect to return the final result. When

Today, frontend applications can be deployed and served actual users in several ways. You can use platforms such as Vercel, Netlify, GitHub Pages, or AWS Amplify. You can also go a level lower and d

This short article describes certain database terms that you would hear thrown around a lot if you work with software developers. Computers make accessing data easy and faster, so storing information on computers is a no-brainer. There are two types ...

A tutorial on how to authenticate users using node js, express, mongoose, json web token, bcryptjs and your computer.

In this tutorial we will be learning how to serve static files with http using node js. before starting this you should be familiar with node js and preferrably have created a http server . p.s if you haven't check out my other write up on how to ...

Learnt the basics of react and mongo db about a year ago but I couldn't confidently call myself a full stack developer. But after several suggestions from my mentors ( all of tech twitter ) Decided to build something and I chose a functional social m...

This is a break down of how I built a server using the http module and sent text, json and html as responses. If you would follow along i expect you already have node installed if not check this tutorial on how to get started with node js or chec...
