Skip to main content
R3X R3X
Home Creations Blog About Contact
X / Twitter RSS

Engineering Blog & Writing

Essays, systems breakdowns, software architecture patterns, and technical notes from the workbench.

All Articles (5) Databases (1) Systems Engineering (1) Laravel & Architecture (2) Indie Engineering (1)
Tags: #Architecture #Laravel #Database #DevOps #SQLite #Performance #Indie Engineering
6 min read
Laravel & Architecture

Why SQLite is Often the Best Database for Modern Creator Platforms

The case for SQLite is not that it scales further than you think. It is that the operational cost of the alternative is far higher than most small products can justify — and that cost is paid every month, forever.

#Database #Laravel #SQLite
Read
8 min read
Indie Engineering

The Solo Engineer's Playbook: Shipping Production Software

Working alone changes which engineering practices pay for themselves. The constraint is not skill or time — it is that you are the only person who will ever be paged, and everything follows from that.

#Architecture #DevOps #Indie Engineering
Read
10 min read
Systems Engineering

Zero-Downtime Laravel Deploys: The Parts That Actually Bite

Atomic symlink swaps are the easy half. The failures that take a site down mid-deploy come from opcache, queue workers running old code, and migrations that lock a table.

#Laravel #DevOps #Architecture
Read
8 min read
Laravel & Architecture

Killing N+1 Queries: Detection, Fixes, and Prevention

The N+1 query is the most common performance bug in ORM-backed applications, and it never shows up in development — because with twelve rows in your local database, nobody notices 13 queries.

#Laravel #Performance #Database
Read
9 min read
Databases

Running SQLite in Production: What Actually Breaks

SQLite handles far more production traffic than its reputation suggests — but the failure modes are specific, and most of them trace back to two settings people never change.

#SQLite #Database #Architecture
Read