Framelist - Framer Plugin

A lightweight, terminal-based task manager built with Node.js and SQLite for developers who live in the command line.

Overview

Built a feature-complete task management system that integrates seamlessly with existing development workflows. The tool supports project-based organization, time tracking, and Git integration.

Key Features

• Project-based organization with nested task hierarchies
• Time tracking with automatic Git commit correlation
• Smart filtering by status, priority, and project
• Markdown export for documentation and reporting
• Git hooks integration for automatic task updates

Technical Stack

# Core dependencies
node.js + commander.js  # CLI framework
sqlite3                 # Local database
inquirer               # Interactive prompts
chalk                  # Terminal styling

Architecture Highlights

Database Schema

CREATE TABLE tasks (
  id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  project TEXT,
  status TEXT DEFAULT 'pending',
  priority INTEGER DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  time_spent INTEGER DEFAULT 0
);

Command Structure

task add "Fix auth bug" --project=api --priority=high
task list --status=active --project=frontend
task start 42  # begins time tracking
task done 42   # stops timer, marks complete

Performance & Scale

• Handles 10k+ tasks without noticeable lag
• Sub-100ms response for most operations
• Offline-first design with optional sync capabilities

Lessons Learned

1. SQLite is perfect for local tools - simple, fast, zero-config
2. Commander.js scales beautifully from simple to complex CLIs
3. Time tracking changed my workflow - visibility drives better habits

Tech: Node.js, SQLite, Commander.js, Git hooks
Timeline: 3 weeks (evenings)
Status: Daily driver for 6+ months