2 min read
SQLite Performance Tuning and Killing a Stale Cache Bug
WAL mode, PRAGMAs, missing indexes, and a date-comparison sweep after the SQLite cutover surfaced stale pay-tracker entries.
SQLiteLaravelPerformanceDatabaseCaching
Read more
2 min read
Cutting Over to SQLite and Ripping Out the Legacy Database
The big one: a full cutover to SQLite, direct lead routing, and an anonymized activity feed after months of planning.
SQLiteLaravelDatabaseMigrationPHP
Read more
4 min read
How I Fixed Git Context’s Database Consistency with Path Normalization and Symbol Tracking
I solved flaky tests in Git Context by normalizing file paths and fixing symbol reference counts in the database.
gitdatabasedebuggingtypescripttesting
Read more
4 min read
How I Recovered and Stabilized HomeForged’s Database Migrations in a Single Day
After a critical migration loss, I restored database integrity in hours using Laravel Artisan, targeted seeding, and CI safeguards.
LaravelDatabaseMigrationsDevOpsRecovery
Read more