cli + tui to publish to leaflet (wip) & manage tasks, notes & watch/read lists 馃崈
desertthunder.dev
charm
leaflet
readability
golang
1-- Notes table
2CREATE TABLE IF NOT EXISTS notes (
3 id INTEGER PRIMARY KEY AUTOINCREMENT,
4 title TEXT NOT NULL,
5 content TEXT NOT NULL,
6 tags TEXT, -- JSON array
7 archived BOOLEAN DEFAULT FALSE,
8 created DATETIME DEFAULT CURRENT_TIMESTAMP,
9 modified DATETIME DEFAULT CURRENT_TIMESTAMP,
10 file_path TEXT -- optional path to source markdown file
11);
12
13CREATE INDEX IF NOT EXISTS idx_notes_title ON notes(title);
14CREATE INDEX IF NOT EXISTS idx_notes_archived ON notes(archived);
15CREATE INDEX IF NOT EXISTS idx_notes_created ON notes(created);
16CREATE INDEX IF NOT EXISTS idx_notes_modified ON notes(modified);