If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a
๐ EXPLAIN-based index analysis detects full table scans, missing indexes, filesort & temporary tables on #MySQL, #MariaDB & #SQLite
๐ Duplicate query detection finds identical queriesโฆ
โ๏ธ Automatic model selection: haiku for trivial, sonnet for standard, opus for critical planning
๐ณ Flexible isolation: #Docker containers, #git worktrees, or direct execution
๐พ Built-in crash recovery via #SQLite
#sqlite key value in 3 lines of sql
@nobodyinperson@fosstodon.org
