Archive
About

Archive

2026

Jan 04I Built a Coaching platform for my brother, from scratch to deployment part 2

2025

Dec 04Backend Engineering Fundamentals: A Complete Guide
Nov 17How I Prepare for Google Summer of Code
Nov 16I Built a Coaching platform for my brother, from scratch to deployment, since no one is hiring jnr
Sep 04Running Out of TCP Ports
Sep 02Linux SYN and Accept Queues
Sep 02How SELECT COUNT Affects Performance
Aug 28Journey of a Backend Request
Aug 28Journey of a Request to Backend
Aug 28Session vs JWT Auth
Aug 25How ChatGPT Uses SSE Internally
Aug 25Notes on Designing Software
Aug 04Understanding Layer 4 vs Layer 7 WebSocket Proxying
Aug 01Understanding Layer 4 vs Layer 7 Load Balancers
Aug 01Understanding Nagle's Algorithm and Why It's Often Disabled
Aug 01Understanding Proxies and Reverse Proxies: A Networking Foundation for Backend Developers
Aug 01When Should You Use Threads in Programming?
Jul 31Making Backend Requests Safe: Understanding Idempotency
Jul 31Multiple Threads Accepting on One Socket
Jul 31Socket Sharding: Multiple Listeners on the Same Port
Jul 30Single Listener/Acceptor/Reader Thread Pattern (Node.js Example)
Jul 29Thread Execution Patterns: From Single Listener to Load Balanced Workers
Jul 27Test Input Generation with Java PathFinder
Jul 24Understanding Java Pathfinder: A Guide to Software Model Checking
Jul 24Understanding How Socket Data Is Read and Sent in Backend Systems
Jul 23How the Backend Accepts TCP Connections
Jul 20Understanding Backend Execution: Processes and Threads
Jul 16Understanding HTTPS: Secure Web Communication and Latency Optimization
Jul 14Understanding WebRTC: Real-Time Communication in the Browser
Jul 07Understanding gRPC: Streamlining Client-Server Communication
Jul 03Understanding HTTP/2: Evolution, Features, and Trade-offs
Jul 03Understanding HTTP/3 and QUIC: Revolutionizing Web Performance
Jul 02Understanding WebSockets: Real-time Communication for the Web
Jun 30Understanding HTTP/1.1: The Enduring Web Protocol
Jun 30Understanding HTTPS, TLS, Keys, and Certificates
Jun 28Understanding Transport Layer Security (TLS): Comprehensive Lecture Notes
Jun 27Understanding TCP: The Backbone of Reliable Networking
Jun 25Understanding Postgres Locks: A Deep Dive
Jun 25Advanced InnoDB Locking Techniques in MySQL 8
Jun 25Optimistic vs Pessimistic Concurrency Control in Databases
Jun 25Why SELECT * Can Slow Down Your Database
Jun 24Understanding NULLs in Database Queries and Their Impact on Performance
Jun 24Understanding Write Amplification in Databases and SSDs
Jun 22Why Uber Switched from Postgres to MySQL: Lecture Notes
Jun 20Understanding Indexing in PostgreSQL vs MySQL
Jun 18Understanding Distributed Transactions
Jun 18Understanding Hash Tables and Consistent Hashing
Jun 17Understanding PostgreSQL Architecture: Processes and Configurations
Jun 17Is QUIC a Good Protocol for Databases?
Jun 11How Databases Store Data on Disk
Jun 10Understanding SELECT COUNT(*) Performance Issues
Jun 10Shopify's Switch from UUID to ULID for Database Optimization
Jun 07Database Logs: WAL, Redo, and Undo Logs Explained
Jun 07Understanding Index Creation and Write Operations in Databases
Jun 07Understanding Postgres vs MySQL: Key Differences in Indexing and Data Management
Jun 04Understanding Bitmap Index Scans in Database Queries
Jun 04Database Engineering Q&A: Indexing, Durability, Locks, and More
Jun 03Understanding Read-Only Transactions and Primary Key Choices in Databases
Jun 03Why Updates in PostgreSQL Affect All Indexes
Jun 02Q&A: Why Can't We Use a Single Database Connection for Multiple Clients?
Jun 02Understanding Serializable Isolation Level and SELECT FOR UPDATE in Database Transactions
Jun 02Understanding Non-Key Column Indexes in Databases
Jun 02Understanding Relationships in SQL Databases
Jun 02Exploring Arrow Functions, Rest Parameters, and let in TypeScript
May 30Why Databases Read Pages Instead of Rows
May 30Understanding Indexing with Duplicate Values
May 29Why Databases Might Ignore Indexes: A Lesson from Karate’s Question
May 29Understanding Repeatable Read vs. Snapshot Isolation in Database Transactions
May 29SQL Querying Fundamentals: Databases for Real-World Data
May 28Clarifying Database Isolation Levels
May 28Why PostgreSQL Chooses Bitmap Heap Scan Over Index-Only Scan
May 28Understanding Cost Units in PostgreSQL Query Planner
May 27Understanding Homomorphic Encryption: A Future for Secure Data
May 22Best Practices for Database Permissions in REST API Development
May 22Experiment: Finding the Largest SQL Query a Database Can Handle
May 21Understanding the MongoDB Wire Protocol with Wireshark
May 21Exploring the Postgres Wire Protocol with Wireshark
May 21How to Secure Your Postgres Database by Enabling TLS/SSL
May 20Understanding Redis: Why It’s So Popular
May 18Understanding Memcached Architecture
May 17Database Architectures Unveiled: MongoDB and MemCached
May 17Understanding Memcached: Architecture and Key Concepts
May 15Understanding TypeScript Classes and Their JavaScript Output
May 14Advanced JavaScript Concepts: `this`, Closures, Numbers, and Truthy/Falsy Values
May 14Evolution of MongoDB's Architecture: From MMAPv1 to Clustered Collections
May 13Understanding Server-Side and Client-Side Database Cursors
May 13Understanding JavaScript Basics in TypeScript
May 12Understanding Database Engines: MyISAM, InnoDB, and Beyond
May 12Introduction to TypeScript: Getting Started and Key Concepts
May 08Designing a URL Shortener Database Backend: Trade-offs and Scaling
May 04Designing a Twitter-like System: Trade-offs and Core Concepts
May 03Understanding Database Replication: Master-Slave vs. Multi-Master
May 01Why SQL Pagination With Offset is Slow and How to Optimize It
Apr 28Database Sharding and Consistent Hashing Explained
Apr 19B+ Trees vs B-Trees: How Database Indexing Really Works
Apr 19PostgreSQL Partitioning – Real-World Lessons from Hussein's Database Lectures
Apr 16Database Performance Deep Dive: UUIDs, Bloom Filters, Indexes & Scaling
Apr 16Comprehensive Database Indexing & Performance Notes
Apr 15Understanding Database Consistency in Transactions Day 2
Apr 15Row vs Column Databases: How Your Data Storage Choices Make or Break Performance
Apr 14Understanding ACID Properties in Databases
Apr 13UDP Communication Design Patterns & Protocols: Lecture Note (Day 4)
Apr 12Backend Communication Fundamentals: Internet Protocol (IP) – Day 3
Apr 10Backend Communication Fundamentals: Protocols (Day 2)
Apr 09Backend Communication Fundamentals: Protocols (Day 1, Section 3)
Apr 03Backend Communication Fundamentals: Week 1 Recap
Apr 01Backend Communication Fundamentals: Week 1 Recap
Mar 31Backend Communication Fundamentals: Day 3 Notes
Mar 30Backend Communication Fundamentals: Day 2 Notes
Mar 29Backend Communication Fundamentals: Day 1 Notes
Mar 25Automating Spyware Detection with Machine Learning & GitHub Actions
Mar 25Building a Real-Time Spyware Detection Engine with Flask & Machine Learning
Mar 12Automating Spyware Detection with Machine Learning & GitHub Actions
Feb 17Revamping the Frontend: A Modern UI for File Processing
Feb 10Building a Spyware Detection System: Refactoring & Lessons Learned
Feb 08Building a Real-Time Virus Scanning System Using ML: Lessons Learned
Feb 01Markdown Guide

© Ahmed's Blog 2019, Powered by Jekyll & TeXt Theme.

Search