Writing
Dec 20, 2025 · 10 min
PgBouncer Deep Dive
A deep dive into how PgBouncer connection pooling saved our PostgreSQL database from being overwhelmed by connection storms and performance bottlenecks.
PostgreSQL · DevOps · System Design
July 19, 2025 · 10 min
Backend Dev's Analytics War Story
A solo backend developer's journey through building and scaling an analytics system, tackling PostgreSQL performance challenges, and learning hard lessons about database optimization.
Backend · PostgreSQL · Analytics
July 11, 2025 · 10 min
SQL User Hierarchy Dilemma
Exploring different approaches to modeling and querying hierarchical user trees in SQL databases, from adjacency lists to nested sets and closure tables.
Backend · PostgreSQL · Database Design
Sep 24, 2024 · 8 min
Deep Sea Underwater Images
Techniques and algorithms for processing and enhancing underwater images captured in deep sea environments using computer vision and OpenCV.
Computer Vision · Python · OpenCV
Oct 06, 2023 · 12 min
3D Vectors in C++
A comprehensive guide to implementing and working with 3-dimensional vectors in C++, covering the Vec3 class and essential operations for 3D graphics programming.
C++ · Mathematics · 3D Graphics
Sep 26, 2023 · 15 min
HashMaps Deconstructed
Breaking down the internal workings of hash maps, exploring collision resolution strategies, hash functions, and the data structures that make them so efficient.
Data Structures · Algorithms · Computer Science
Sep 10, 2023 · 10 min
ReactJS for Newbies
A beginner-friendly introduction to React, covering fundamental concepts like components, props, state, and hooks to get you started with modern frontend development.
React · JavaScript · Frontend