Blog tag

#SQLite

6 posts tagged with SQLite.

← Back to all posts
4 min read

How We Fixed Broken Geospatial Queries in Next.js by Ditching Bound Parameters

Laravel's PDO SQLite layer was silently breaking our 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
4 min read

Why We Swapped to SQLite for Local Development in Our AI-Powered Lead Gen App

We switched to SQLite for local dev in our Dockerized AI app—here’s how it simplified setup and boosted team velocity.

SQLiteDockerPythonDeveloper ExperienceAI Applications
Read more
4 min read

Building Lockline AI from Scratch: Docker, SQLite, and htmx in Action on Day One

How I kicked off Lockline AI with Docker, SQLite, and htmx for fast, clean, production-ready development from the first commit.

DockerhtmxSQLiteAI SaaSfull-stackdeveloper tooling
Read more
4 min read

How We Built a Sales Audit System Using a SQLite Backup in Capital City

We turned a cold SQLite backup into a secure, queryable sales audit dashboard using Laravel and Filament—without touching production.

LaravelSQLiteFilamentData AnalysisAudit SystemsLegacy Data
Read more