goclaw/migrations/000049_vault_path_prefix_index.down.sql at dev - goclaw - Gitea: Git with a cup of tea

tiennm99/goclaw

mirror of https://github.com/tiennm99/goclaw.git synced 2026-09-03 20:22:16 +00:00

Files

T

viettranx 35ce8cc2c5 feat(vault): tree sidebar with lazy-load folder hierarchy

Replace flat paginated document list with collapsible tree view.
Backend: two-query-per-level approach (files + DISTINCT deeper paths
for virtual folder derivation), path parsing in Go for PG+SQLite
compatibility, text_pattern_ops index for prefix range scans.
Frontend: VaultTree component with doc_type colored icons, compact
single-line nodes, truncate-middle filenames, scope dots, hover
tooltip for date. Sidebar expanded to 384px on large screens.

Also fixes pre-existing SQLite scanVaultDocRow missing path_basename.

2026-04-12 12:37:10 +07:00

2 lines

49 B

SQL

Raw Permalink Blame History

DROP INDEX IF EXISTS idx_vault_docs_path_prefix;