Tag

#sqlite

10 posts

dankMire: A 5-Machine Home Lab Running 4.3 Million Files
Applied linux 8 min

dankMire: A 5-Machine Home Lab Running 4.3 Million Files

Five machines named after Greek gods. 4.3 million indexed files. A media database, a productivity heatmap, and an AI video studio — all running on local hardware with zero cloud dependencies.

dankmire home-lab sqlite
Agent Core: 9 Tools Is All You Need
Applied ai ml 22 min

Agent Core: 9 Tools Is All You Need

How we trained a universal LoRA standard — 9 tools, 3 databases, a vault boundary — into a Qwen3-8B model that beats 23-tool fine-tuning with 87% fewer prompt tokens.

lora fine-tuning tool-calling
Self-Distillation: Mining Your AI Conversations for LoRA Data
Professional ai ml 20 min

Self-Distillation: Mining Your AI Conversations for LoRA Data

Your real coding agent interactions are the highest-quality training data you'll ever have. Here's the 4-stage pipeline that converts conversation histories into structured LoRA training data — zero cost until Stage 3.

lora fine-tuning training-data
Schema on the Inside: Training an 8B Model to Recall Tool Schemas From Memory
Applied ai ml 18 min

Schema on the Inside: Training an 8B Model to Recall Tool Schemas From Memory

How we trained Qwen3-8B to call 23 tools without any schemas in the prompt — and beat BFCL benchmarks in the process.

lora fine-tuning tool-calling
Building an R&D Dashboard for Your AI Research Pipeline
Applied web development 18 min

Building an R&D Dashboard for Your AI Research Pipeline

How I built a browser-based command center for reviewing, curating, and acting on AI-generated research with Preact, Express 5, and SQLite.

preact express sqlite
Building a Personal AI Research Pipeline
Applied ai ml 18 min

Building a Personal AI Research Pipeline

How I built a system that queries multiple AI APIs, auto-saves results as timestamped markdown, and indexes hundreds of files with SQLite FTS5.

ai research sqlite
From Research to Pull Requests: Automating Triage and Implementation with AI
Applied ai ml 18 min

From Research to Pull Requests: Automating Triage and Implementation with AI

Turn raw research into scored triage cards and draft PRs with a three-stage pipeline that runs on cron.

ai automation triage
Building a Life Dashboard with Calendar Heatmaps
Applied web development 14 min

Building a Life Dashboard with Calendar Heatmaps

GitHub tracks your code contributions. I built a dashboard that tracks everything — commits, tasks, wellness — in one heatmap.

dashboard heatmap sqlite
What Is a Database? Build Your First One with SQLite
Foundations python 11 min

What Is a Database? Build Your First One with SQLite

Every app you use runs on a database. Here's what that actually means — and how to build your first one in 10 minutes with SQLite.

sqlite databases sql
Building a Home Lab Dashboard with Preact, Express 5, and SQLite
Applied web development 16 min

Building a Home Lab Dashboard with Preact, Express 5, and SQLite

dankMire is my personal command center — a lightweight dashboard for tracking projects, managing media assets, and monitoring my home lab.

preact express sqlite