journal
Notes on backend engineering, fintech, API design, and applied AI. Long-form pieces — published when there's something worth saying.
All posts
17 posts-
A/B Testing Statistical Analysis: Making Data-Driven Decisions
Designing and analyzing A/B tests for website conversion rates, using proper statistical methods to ensure reliable, actionable results.
-
Building a Real-Time Analytics Dashboard with React and D3.js
Creating an interactive dashboard to visualize real-time data streams — WebSocket connections, dynamic chart updates, and TimescaleDB for time-series storage.
-
Getting Started with PostgreSQL: A Beginner's Guide
A practical walkthrough of PostgreSQL installation, your first database, table creation, basic queries, and essential administration tasks.
-
Understanding Database Indexes: A Guide to Performance Optimization
How database indexes work, when to use them, the different types available in PostgreSQL, and how they can dramatically improve query performance.
-
Database Backup and Recovery Strategies for Beginners
Essential backup and recovery techniques every database administrator should know to protect critical data — including full, incremental, and continuous backup approaches.
-
Git Version Control: A Beginner's Guide
Learn the fundamentals of Git — from basic commands and branching to working with remote repositories and common workflows.
-
Advanced Git: Branching Strategies and Collaboration
Master advanced Git techniques including Git Flow, rebasing vs merging, stashing, conflict resolution, and effective team collaboration patterns.
-
Installing CodeIgniter: A Beginner's Guide to PHP Framework Setup
Step-by-step guide to installing and configuring CodeIgniter 4 — from Composer to your first controller, view, and route in under 30 minutes.