Refactoring my Local AI Assistant: Moving from JSON to SQLite and Plugins (v1.2.0)
Dev.to AI
•
Generative AI
AI Tools
A few days ago, I built a local virtual assistant in Python (JARVIS) using Ollama, PyQt6, and Piper TTS. It was a fun MVP, but as I started using it daily, the architectural flaws became obvious. Hardcoding tool calls into the main loop made the file massive, and storing conversation history in flat.json files wasn't scalable. I just released the v1.2.0 update, focusing purely on technical debt and scalability. Here is a breakdown of the refactoring process: 1. The Database Migration (SQLite) Previously, JARVIS saved facts (like user preferences) and chat history in.