2 min read
Candle Continuity, Local-First Market Data, and Deploy Health
A 32-commit day making candle-service fast and continuous while moving dex-trader to local-first data.
FastAPISQLitePerformanceTradingData Pipelines
Read more
2 min read
Regime Feeds, Volume Workers, and Curation in Candle Service
Adding a Binance regime feed, backfilling volume, and dropping a concept that didn't earn its complexity.
PythonMarket DataSQLitePerformanceRefactor
Read more
2 min read
Standing Up Candle Service: A Market Data Aggregation API
From design doc to a deployed FastAPI service with multiple upstream clients, workers, and rate limiting in one evening.
PythonFastAPISQLiteMarket DataDocker
Read more
2 min read
OpCache, JIT, and a Slimmer Docker Build
Trimming image build time while turning on PHP performance features and extracting a reusable migration kit.
DockerPHPPerformanceOpCacheSQLite
Read more
2 min read
A Meals-Provided Checkbox and SQLite Migration Fixes
A small event-form feature plus repairing two mobile token migrations that broke under SQLite.
LaravelSQLitePHPMigrations
Read more
3 min read
Fixing 20-60 Second Page Loads Across the AustinsElite Codebase
A performance day: SQLite query fixes, frontend bottlenecks, and performance smoke tests to keep it from regressing.
SQLitePerformanceLaravelPlaywrightFrontend
Read more
2 min read
No-Nonsense Orchestration: Autonomous Agents on a SQLite Task Board
A fresh orchestrator built around one hard constraint—only one agent may own the GPU at a time.
PythonOrchestrationAISQLite
Read more
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 Broken Geospatial Queries in Next.js by Ditching Bound Parameters
Laravel's PDO SQLite layer was silently breaking my geospatial queries—here's how inline parameter binding saved venue search in AustinsElite.
LaravelSQLitegeospatial queriesPDOperformance optimizationHybrid Architecture
Read more
3 min read
Building a Live-Editable Admin Interface with htmx and SQLite in Lockline AI
How I used htmx and SQLite in Docker to build a fast, live-editable admin panel for Lockline AI—no heavy JS frameworks needed.
htmxFlaskSQLiteDockeradmin interfacePython
Read more
4 min read
Debugging the Invisible: Fixing Celery Task Failures and History Tracking in Lockline AI
How I tracked down intermittent Celery task failures and missing history logs in Lockline AI after migrating to SQLite and Docker.
PythonCelerySQLiteDockerDebuggingAI
Read more