Jan 3, 20266 min read
How db works internally (Overview)
A deep dive into database internals, exploring how queries are parsed, optimized, executed, and safely persisted on disk.
DatabaseDatabase InternalsDBMS
Read Article
Punyansh Singla
Builder • Student • Full Stack Developer • Intern
A Full-Stack Developer turning ideas into scalable digital products with JavaScript/TypeScript.
Founder at GymFlow
punyanshcoder@gmail.com
Featured Projects
GymFlow
Technologies
Next.js
Tailwind CSS
MongoDB
Typescript
Better Auth
Razorpay
ShadCN UI
Node.js
Resend
A full-featured Gym Management System designed to manage members, trainers, products, inventory, staff, plan, diet plan, expenses, attendance, plans, payments, and revenue through a clean, scalable SaaS dashboard.
FastSell
Technologies
Next.js
TypeScript
Tailwind CSS
ShadCN UI
MongoDB
Clerk
Stripe
Resend
Zod
Zustand
SWR
A full-stack e-commerce platform featuring product discovery, reviews, product-comparing, cart management, secure checkout, and an admin panel for managing products, orders, and users.
Ems
Technologies
Next.js
TypeScript
Tailwind CSS
MongoDB
Better Auth
ShadCN UI
Zod
Node.js
Resend
SWR
Vercel
A full-stack Employee Management System that centralizes employee data, attendance, roles, departments, leaves, messages, and analytics through a secure, modern admin dashboard.
JanFebMarAprMayJunJulAugSepOctNovDec
Loading...
Less
More
Technologies & Tools
"I’m not limited to a fixed skill set. I adapt, learn, and build with whatever the project requires.
I focus on understanding the core concepts."
Tailwind CSS
TypeScript
React
MongoDB
Supabase
Tailwind CSS
TypeScript
React
MongoDB
Supabase
Tailwind CSS
TypeScript
React
MongoDB
Supabase
Tailwind CSS
TypeScript
React
MongoDB
Supabase
Vercel
Express.js
Git
Next.js
Zod
Vercel
Express.js
Git
Next.js
Zod
Vercel
Express.js
Git
Next.js
Zod
Vercel
Express.js
Git
Next.js
Zod
SWR
Better Auth
Resend
PNPM
Redis
SWR
Better Auth
Resend
PNPM
Redis
SWR
Better Auth
Resend
PNPM
Redis
SWR
Better Auth
Resend
PNPM
Redis
Featured Blogs
Jan 16, 20264 min read
How Git Works Internally
A very simple guide to understand what happens inside Git, including the .git folder, objects, snapshots, and how git add and git commit really work.
GitGit InternalsVersion Control
Read Article
Jan 30, 202611 min read
How DNS Resolution Works: From Domain Name to IP Address
Learn how DNS resolution works behind the scenes. Understand root, TLD, and authoritative name servers, dig commands, and how a browser turns domain names into IP addresses.
DNSInternet BasicsNetworking
Read Article
Jan 30, 202613 min read
How TCP Works: Handshake, Data Transfer, and Connection Close
Understand how TCP works behind the scenes. Learn why TCP is needed, how the 3-way handshake works, how data is reliably transferred, and how TCP connections are closed.
TCPNetworking3-Way Handshake
Read Article
Loading reviews...
Get in Touch
If you have any inquiries, please feel free to reach out. You can contact me via email at
punyanshcoder@gmail.com
Counting visitors…