Tagliatelle

Previously called taggart, renamed for unfortunate rhyming reasons

A simple golang application to provide a flexible SQLite tagging database and file browser via web browser.

Very rough around the edges, but functional. Primarily intended for personal use.

Running

cd tagliatelle
go get github.com/mattn/go-sqlite3
go run . -d your_directory -p 8080

Then access the server via a web browser, the default port is 8080.

Dependencies

• ffprobe and ffmpeg for converting incompatible video uploads
• sed for custom bulk note manipulation
• yt-dlp for video downloader

Features

• Multiple tags per category
• Bulk tag management via file-id or tag:value query
• Search through file names, descriptions or tag values with wildcard support
• Image, video, text and cbz gallery viewers
• Will transcode incompatible video formats
• Tag value aliases, e.g. color:blue and color:navy
• Regenerate video thumbnails via web interface
• Add files via local upload, remote upload or yt-dlp directly
• Clickable rotate90, l45, 01:23 and file/1234 shortcodes in file descriptions
• Artbitrary searchable descriptions on files
• Raw file URI copying for external application access
• In browser file management (delete, rename)
• Self-organising, categorised notes, with optional sed operation rules
• Orphan and reverse orphan finding
• Database backup and vacuum support
• tag=!, tag=!123 and tag=x,value=! for duplicating previously applied tags
• Chainable /and/tag/tag2/value2 filter matching

Limitations

• SQLite requires cgo, which requires gcc. Build/run with CGO_ENABLED=1
• Database deletions get reserved so you won't have sequential file ID's

Credits

• mattn/go-sqlite3 for the go SQLite3 library
• Fluent UI System Icons for SVG icons used