Local Note-Taking App

Problem/Feature Description

A developer wants to build a local note-taking CLI application in Go that stores data in SQLite. The app should be a simple command-line tool, not a web server.

The app needs to support:

• Creating a new note with a title and body
• Listing all notes, ordered by creation date (newest first)
• Searching notes by title (case-insensitive substring match)
• Deleting a note by ID
• Tagging notes: each note can have multiple tags, and the user can list notes by tag

Each note has: id (integer primary key), title, body, created_at, updated_at. Tags have: id (integer primary key), name (unique). A join table links notes to tags.

Output Specification

Produce:

• main.go -- CLI entry point that parses subcommands (create, list, search, delete, tag, list-by-tag)
• db.go -- Database connection and migration setup
• notes.go -- Functions for all note operations
• go.mod -- Module file with required dependencies

The code should be complete Go with no placeholders or TODO comments.