Something went wrong. Try again.
cli + tui to publish to leaflet (wip) & manage tasks, notes & watch/read lists 🍃
charm leaflet readability golang
Something went wrong. Try again.
12345678910111213141516-- Notes tableCREATE TABLE IF NOT EXISTS notes ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, content TEXT NOT NULL, tags TEXT, -- JSON array archived BOOLEAN DEFAULT FALSE, created DATETIME DEFAULT CURRENT_TIMESTAMP, modified DATETIME DEFAULT CURRENT_TIMESTAMP, file_path TEXT -- optional path to source markdown file);
CREATE INDEX IF NOT EXISTS idx_notes_title ON notes(title);CREATE INDEX IF NOT EXISTS idx_notes_archived ON notes(archived);CREATE INDEX IF NOT EXISTS idx_notes_created ON notes(created);CREATE INDEX IF NOT EXISTS idx_notes_modified ON notes(modified);