valscanner 0.1.8

A recursive file scanner with rich metadata extraction, full-text search, auto-tagging, thumbnail generation, and similar-folder detection — available as a CLI, a PySide6 desktop GUI, and a browser-based Web UI.

ValScanner

A recursive file scanner with rich metadata extraction, full-text search, auto-tagging, thumbnail generation, and similar-folder detection, available as a CLI, a PySide6 desktop GUI, and a browser-based Web UI.

---

Screenshots

Grid View

Thumbnail grid: browse image and video files visually

List View

List view: compact overview of the indexed files

Details View + Inspector

Details view with sortable columns: click any file to see full metadata, tags, and thumbnail in the inspector panel

Similar Folders

Similar folders panel: pairwise similarity scores help identify near-duplicate directories

Similar Folders Filters

Filter panel for similar-folder analysis: narrow down the next analysis

Web UI

Browser-based Web UI

Features

• Three front-ends, one database — CLI for scripting, Qt desktop GUI for everyday browsing, FastAPI + React Web UI for remote / cross-machine viewing
• Recursive scan — indexes every file under a root directory through a backend-agnostic database layer
• Multiple database backends — SQLite (default, zero-config) or local PostgreSQL (optional, better for very large indexes and concurrent access); switch between them through the GUI's Database Settings dialog with no env vars or config-file editing
• Rich metadata — image EXIF, audio tags, PDF page count (optional deps: Pillow, mutagen, PyPDF2)
• Thumbnails — JPEG blobs stored in-database; shown in GUI grid view (requires Pillow or ffmpeg)
• Media samples — short low-quality audio/video clips stored in-database (requires ffmpeg)
• Auto-tagging — rule-based tags from path keywords, filename, size bucket, and extension
• Full-text search — FTS5 (SQLite) or tsvector + GIN (PostgreSQL); live search in the GUI and Web UI
• Similar-folder detection — pairwise comparison using filename Jaccard + extension cosine + size ratio + SHA-256 Jaccard
• View filters — slice the result set by category, size range, extension, or path pattern without re-scanning
• Export — CSV and JSON from CLI, GUI, and Web UI
• Multiple scan sessions — each scan stored with a label; compare, list, or delete past sessions
• Versioned migrations — schema changes managed by Alembic; v0.1.x databases auto-upgrade in place

---

Requirements

Requirement	Version	Role
Python	3.8+	runtime
PySide6	any recent	desktop GUI
SQLAlchemy	≥ 2.0	dialect-agnostic database access
Alembic	≥ 1.13	schema migrations (runs automatically at startup)
keyring	≥ 24.0	OS-keychain storage for the PostgreSQL password (falls back to settings.json when no keychain is available)
platformdirs	≥ 4.0	locating the per-user settings directory
Pillow (optional)	any	image EXIF + thumbnails
mutagen (optional)	any	audio metadata (artist, album, duration, …)
PyPDF2 (optional)	any	PDF page count
ffmpeg (optional)	any	video thumbnails + media samples
psycopg2-binary (optional)	≥ 2.9	PostgreSQL driver — only needed if you choose the PostgreSQL backend
FastAPI + uvicorn (optional)	recent	Web UI HTTP server (pip install ".[web]")
Node.js (optional)	≥ 18	building the Web UI from source (only needed when developing or producing a release build)

---

Installation

pipx (recommended for most users)

# Install from PyPI — both CLI and GUI available immediately
pipx install valscanner

valscanner /path/to/scan      # CLI
valscanner-gui                # GUI

Run once without installing:

pipx run valscanner /path/to/scan
pipx run --spec valscanner valscanner-gui

macOS / Linux (from source)

git clone https://github.com/valabji/val-scanner
cd val-scanner

# Full install — creates .venv, installs all deps, symlinks launchers to ~/.local/bin
bash scripts/install.sh

# Skip optional rich-metadata deps (faster scan, no EXIF/audio/PDF)
bash scripts/install.sh --no-rich

# Install into your active Python environment instead of a new venv
bash scripts/install.sh --no-venv

# Choose where launcher symlinks go
bash scripts/install.sh --prefix /usr/local

Windows (from source)

git clone https://github.com/valabji/val-scanner
cd val-scanner

# Full install — creates .venv, writes .cmd launchers to %LOCALAPPDATA%\Programs\ValScanner\bin
.\scripts\install.ps1

# Skip optional deps
.\scripts\install.ps1 -NoRich

# Install into your active Python environment
.\scripts\install.ps1 -NoVenv

# Choose launcher directory
.\scripts\install.ps1 -Prefix "C:\Tools\ValScanner"

pip (manual)

pip install valscanner              # CLI + desktop GUI
pip install "valscanner[rich]"      # + image EXIF / audio tags / PDF metadata
pip install "valscanner[web]"       # + FastAPI Web UI server (valscanner-web)
pip install "valscanner[postgres]"  # + PostgreSQL driver (psycopg2-binary)
pip install "valscanner[rich,web,postgres]"   # everything

Extras are additive — combine the ones you need. The base install always includes the CLI and desktop GUI.

---

Quick Start

# Index your Downloads folder — thumbnails and media samples are generated by default
valscanner ~/Downloads

# Open the result in the desktop GUI
valscanner-gui

# Or in your browser (requires the [web] extra)
valscanner-web

The CLI scans everything by default: all files and folders are indexed, image/video thumbnails are stored, and short audio/video samples are captured. Add --no-thumbnails, --no-samples, or any --skip-* flag to narrow the scope.

The GUI loads your most recent scan automatically. Switch between grid and list view, search by filename, filter by category or size, and inspect any file in the detail panel on the right.

All three front-ends share the same database, so a scan started from the CLI shows up immediately in the GUI and the Web UI. The default database is ~/valscanner.db (a plain SQLite file) — see Database backends to switch this or to use PostgreSQL instead.

---

CLI Usage

Basic scan

valscanner /path/to/scan

Writes results to the active database (default: ~/valscanner.db; configurable via the GUI's Database Settings dialog or the --db flag). Prints a summary when done:

✅ Done in 4.2s — scan #1, 12,847 indexed, 0 errors, 3 skipped

Named scans

Use --label to tag a scan session with a human-readable name. Useful when you scan the same root repeatedly over time:

valscanner ~/Documents --label "docs-before-cleanup"
valscanner ~/Documents --label "docs-after-cleanup"
valscanner --list-scans

[  1]  docs-before-cleanup       14,201 files     2.1 GB  2026-05-01 09:12
[  2]  docs-after-cleanup        11,088 files     1.6 GB  2026-05-17 14:30

Fast scan (skip hashing)

SHA-256 hashing is the slowest part of a scan. Skip it when you only need the file index, not exact-duplicate detection:

valscanner /large/drive --no-hash

Note: the similar-folder algorithm uses a lighter similarity model when hashes are absent, relying on filenames, extensions, and sizes instead.

Thumbnails and media samples

Thumbnails and media samples are generated by default. Opt out with --no-thumbnails or --no-samples:

# Full scan — indexes files, stores thumbnails and 5-second media clips
valscanner ~/Pictures --db photos.db

# Skip media generation for a faster index-only run
valscanner /large/drive --no-thumbnails --no-samples --no-hash

# Larger thumbnails at higher quality
valscanner ~/Pictures --thumb-size 256 --thumb-quality 90

# Longer media samples (10 s instead of the default 5 s)
valscanner ~/Music --sample-duration 10

Thumbnails require Pillow (images) or ffmpeg (video). Media samples require ffmpeg. If neither is installed, those options are silently skipped and a warning is printed.

Filtering what gets scanned

All --skip-* flags are off by default — everything is indexed unless you ask otherwise:

# Skip version-control and build noise
valscanner ~/Projects --skip-vcs --skip-caches

# Skip hidden dirs and files (e.g. .git, .DS_Store)
valscanner ~ --skip-hidden-dirs --skip-hidden-files

# Lightweight audit: skip binaries, logs, and temp files
valscanner /Volumes/Archive --skip-binaries --skip-temp --skip-logs --no-hash

# Skip everything noisy in one go
valscanner ~/Projects \
  --skip-vcs --skip-caches --skip-system \
  --skip-hidden-dirs --skip-hidden-files \
  --skip-binaries --skip-temp --skip-logs

Search after scanning

valscanner /path --query "invoice"

Runs an FTS5 query against the database and prints matching files after the scan completes. You can also query an existing database without re-scanning:

valscanner --query "contract" --db my.db --list-scans

Export results

# Export to CSV and JSON in one pass
valscanner ~/Projects --export-csv --export-json --db projects.db

# Resulting files: projects.csv, projects.json

The CSV contains one row per file with all indexed columns. The JSON is an array of the same objects, useful for piping into jq or loading into pandas.

Verbose mode

Print each file path as it is indexed — useful to verify what is being included or skipped:

valscanner /path --verbose

Similarity analysis

Find folders that look like near-duplicates — useful before a migration, cleanup, or de-duplication pass.

After a scan — analyze only the folders from the scan that just ran:

valscanner ~/Projects --analyze

Standalone — analyze an existing database without re-scanning:

valscanner --analyze --db archive.db

Tune the analysis — filter out noise and adjust sensitivity:

# Only consider folders with ≥ 10 files; raise the similarity bar to 0.6
valscanner --analyze --db archive.db --min-files 10 --threshold 0.6

# Exclude build and VCS directories from the comparison
valscanner --analyze --db archive.db --skip-caches --skip-vcs

# Restrict to a single scan session
valscanner --analyze --db archive.db --analysis-scan-id 3

# Limit output to the top 50 pairs
valscanner --analyze --db archive.db --analysis-results 50

Output lists folder pairs sorted by similarity score. Child pairs (sub-folders that are also similar) are indented under their parent:

   Score  Folder A                                       Folder B
   ─────  ─────────────────────────────────────────────  ─────────────────────────────────────────────
    0.94  /Volumes/Drive/Photos/2024                     /Volumes/Drive/Backup/Photos/2024
    0.87  /Volumes/Drive/Projects/acme                   /Volumes/Drive/Archive/acme
    0.74    ↳ /Volumes/Drive/Projects/acme/src           /Volumes/Drive/Archive/acme/src

   3 pair(s) found.

The --skip-* flags apply to the similarity comparison itself — folders containing only skipped files are excluded from the analysis. When used alongside a scan, those same flags also control what gets indexed.

Manage scan history

# List all scans stored in a database
valscanner --list-scans --db archive.db

# Delete a specific scan (removes its files, folders, thumbnails, and media samples)
valscanner --delete-scan 3 --db archive.db

Full flag reference

General

Flag	Default	Description
path	—	Root directory to scan (required unless using --list-scans, --delete-scan, or standalone --analyze)
--db PATH	~/valscanner.db	SQLite file path or full SQLAlchemy URL (e.g. postgresql://user:pw@host/db)
--label NAME	directory name	Human-readable label for this scan session
--no-hash	off	Skip SHA-256 hashing (faster; lighter similarity model)
--resume	off	Resume an interrupted scan of the same path
--export-csv	off	Write <db-name>.csv after scan
--export-json	off	Write <db-name>.json after scan
--query TERM	—	FTS5 query to run against the database after scanning
--verbose	off	Print each file path as it is indexed
--list-scans	—	Print all scans in the database and exit
--delete-scan ID	—	Delete a scan by numeric ID and exit

Thumbnails (requires Pillow for images, ffmpeg for video — on by default)

Flag	Default	Description
--no-thumbnails	off	Skip thumbnail generation
--thumb-size PX	128	Thumbnail max dimension in pixels (32–512)
--thumb-quality PCT	75	JPEG compression quality (40–95)

Media samples (requires ffmpeg — on by default)

Flag	Default	Description
--no-samples	off	Skip audio/video sample generation
--sample-duration SEC	5	Sample clip length in seconds (1–30)

Skip filters (all off by default — everything is scanned)

Flag	Skips
--skip-hidden-dirs	Directories whose name starts with .
--skip-vcs	Version-control dirs (.git, .svn, .hg, …)
--skip-system	OS system dirs (Windows, Library, /proc, …)
--skip-caches	Cache/build dirs (node_modules, __pycache__, venv, …)
--skip-hidden-files	Files whose name starts with .
--skip-binaries	Binary/compiled files (.exe, .dll, .so, .pyc, …)
--skip-temp	Temp/backup files (.tmp, .bak, .swp, .DS_Store, …)
--skip-logs	Log files (.log)

Similarity analysis

Flag	Default	Description
--analyze	off	Run folder-similarity analysis (after scan, or standalone with --db)
--min-files N	3	Minimum files a folder must contain to be considered
--threshold F	0.40	Minimum similarity score to report (0–1)
--analysis-results N	200	Maximum number of folder pairs reported
--analysis-scan-id ID	—	Restrict analysis to one specific scan

The --skip-* flags above also apply to the analysis: folders whose files are all excluded are omitted from the comparison.

---

GUI Usage

Launch the GUI:

valscanner-gui
# or via pipx
pipx run --spec valscanner valscanner-gui

Starting a scan

Click Scan in the toolbar or go to File → Scan Directory. A file picker opens; choose a root directory. Then click Options (or the gear icon) before confirming to configure the scan.

Scan Options dialog

Option	What it does
Store thumbnails	Saves a JPEG thumbnail per image/video file into the database. Shown in grid view. Requires Pillow (images) or ffmpeg (video).
Thumbnail size	Max pixel dimension (32–512 px, default 128 px)
JPEG quality	Compression quality for stored thumbnails (40–95%, default 75%)
Store media samples	Saves a short low-quality clip per audio/video file (32 kbps MP3 / 240p MP4). Requires ffmpeg.
Sample duration	Length of each media sample (1–30 s, default 5 s)

Folder filters (applied during scan — excluded folders are never indexed):

Filter	Skips
Hidden folders	Any directory whose name starts with .
Version control	.git, .svn, .hg, and similar VCS directories
System folders	Windows, System32, Library, /proc, /sys, and similar
Cache & build dirs	node_modules, __pycache__, .venv, venv, dist, build, and similar

File filters (applied during scan — excluded files are never indexed):

Filter	Skips
Hidden files	Any file whose name starts with .
Binary / compiled	.exe, .dll, .so, .pyc, .o, .a, and similar
Temporary files	.tmp, .bak, .swp, .DS_Store, and similar
Log files	.log

Browsing results

After a scan completes, the file list populates immediately. Use:

• Grid view — shows thumbnails for images and videos; cards display name, size, and category colour
• List view — compact rows; sortable by name, size, category, or extension; numeric sort for size
• Search bar — full-text search over filenames and paths (FTS5); results update as you type
• Folder tree (left panel) — click any folder to filter the file list to that directory; hold Shift and click for a recursive filter
• Detail panel (right panel) — click any file to see its full path, size, category, extension, tags, EXIF/audio metadata, and thumbnail

View Filters dialog

View → Filters opens a live, non-modal filter panel. Changes apply instantly without re-scanning.

Categories — toggle any combination of the 14 file categories:

archive · audio · code · data · document · ebook · executable · font · image · other · photo · presentation · spreadsheet · video

Use Select all / Select none buttons to quickly isolate a single category.

Size range — enter a min and/or max file size with a unit (B / KB / MB / GB). Example: show only files between 10 MB and 2 GB.

Extensions — comma-separated list of extensions to show. Leave empty for all. Example: jpg, png, webp shows only those three.

Path & file filters — same folder/file filter options as the Scan Options dialog, but applied to the current view in real time (no re-scan needed):

• Hide hidden folders / VCS dirs / system folders / cache dirs
• Hide hidden files / binary files / temp files / log files

Click Reset all filters to return to the unfiltered view.

Similar folders panel

View → Similar Folders (or the tab on the left) runs a background analysis comparing every folder pair in the scan using a weighted blend of:

• Filename Jaccard similarity
• Extension cosine similarity
• Size ratio
• SHA-256 Jaccard similarity (only when hashes exist)

Results are shown as collapsible cards. Each card shows the two folder paths, their similarity score, and — if one folder is a subfolder of the other — the relative path. Child pairs nest under ancestor pairs.

Exporting from the GUI

File → Export CSV / File → Export JSON writes the current scan to a file of your choice.

Database Settings dialog

Settings → Database… opens a modal dialog for switching between SQLite and PostgreSQL without editing any config files:

• SQLite (default) — pick any .db path with Browse…, or leave the default ~/valscanner.db
• PostgreSQL — fill in host, port, database, user, and password (the password is stored in the OS keyring; a plaintext fallback is used on platforms with no keychain, e.g. headless Linux). Install the optional driver first: pip install ".[postgres]"

Click Test Connection to verify the engine can reach the database, then Save & Reload to switch — the app re-opens against the new database in the background, no restart required. Settings are persisted to a per-user JSON file (see Database backends).

---

Web UI

The Web UI is a single-page React app served by a FastAPI backend on localhost:7070. It re-uses the same scanner, repository layer, and database as the CLI and desktop GUI.

Run a pre-built Web UI

If you installed with the [web] extra (and the project ships a pre-built SPA), this is all you need:

valscanner-web                       # serves on http://127.0.0.1:7070
valscanner-web --db /path/to/db      # point at a specific SQLite file or SQLAlchemy URL
valscanner-web --host 0.0.0.0 --port 8080   # bind elsewhere (loopback-only by default; see below)
valscanner-web --no-browser          # don't auto-open a browser tab

By default the server binds to 127.0.0.1 only — because the scan endpoint reads arbitrary filesystem paths from request bodies, exposing it on a public interface is unsafe. To opt in to non-loopback binding, set VALSCANNER_ALLOW_REMOTE=1 in the environment.

Develop against the Web UI

You'll need Node.js ≥ 18. From a source checkout:

# One-time
pip install -e ".[web]"
cd web-ui && npm install && cd ..

# Two terminals
valscanner-web --db my.db --dev      # terminal 1 — FastAPI on :7070
cd web-ui && npm run dev             # terminal 2 — Vite dev server on :5173 with HMR

Open http://localhost:5173. Vite proxies /api/* to the FastAPI server in --dev mode.

Build the Web UI for production

./scripts/build_web.sh               # bundles the SPA into valscanner/web/static/
valscanner-web --db my.db            # serves the built app on :7070

---

Database backends

The scanner, GUI, CLI, and Web UI all talk to a single backend-agnostic layer (SQLAlchemy Core + Alembic). Two backends are supported:

Backend	Best for	Driver
SQLite (default)	Everyone. Zero setup, single .db file, full-text search via FTS5, easy to share.	bundled with Python
PostgreSQL (optional)	Power users who already run Postgres locally. Better concurrent access for several front-ends hammering the DB at once, larger indexes, tsvector/GIN full-text search.	psycopg2-binary (install via pip install ".[postgres]")

The app does not install or manage a PostgreSQL server for you — that's your responsibility. The Database Settings dialog only stores connection details and connects to a database you've already created.

Where settings live

Non-secret connection details (backend choice, SQLite path, PG host/port/db/user) are stored in a per-user JSON file:

Platform	Location
macOS	~/Library/Application Support/valscanner/settings.json
Linux	~/.config/valscanner/settings.json
Windows	%APPDATA%\valscanner\settings.json

The PostgreSQL password is stored separately in the OS keyring under service "valscanner", username "pg_password". If your platform doesn't have a keychain available (e.g. headless Linux without DBus), the app falls back to a pg_password field in settings.json and logs a warning at startup.

URL resolution order

Whenever you launch any front-end, the active database URL is resolved in this priority order:

1. An explicit --db argument (CLI, valscanner-web)
2. The DATABASE_URL environment variable (intended for headless / CI use)
3. The saved settings.json (+ keyring for the PG password)
4. The built-in default (sqlite:///~/valscanner.db)

Every front-end masks passwords before logging or displaying URLs.

Migrations

The first time any front-end touches a database, Alembic upgrades it to the latest schema revision. Fresh databases get created from scratch; existing v0.1.x databases are stamped at the baseline revision and then upgraded — your old scan history is preserved.

---

Scenarios

"My Downloads folder is a mess"

valscanner ~/Downloads --label downloads-audit --export-csv

Open the CSV in a spreadsheet. Sort by size_bytes descending to find the largest files, or filter category = video to see what's eating space. In the GUI, use View Filters → Categories to hide everything except video and archive, then check the Folder tree for clusters.

"Index my entire photo library"

pip install "valscanner[rich]"   # ensure Pillow is present
valscanner ~/Pictures --label photos-2026 --db photos.db
valscanner-gui

Thumbnails are generated automatically — no extra flag needed. Open the GUI and switch to Grid view to browse image previews. Filter by category photo or image, then use the size filter (e.g. Min 5 MB) to find RAW files. Click any file in the detail panel to read its EXIF (camera model, date taken, GPS, dimensions).

To scan quickly without storing thumbnails (e.g. just to get a file count first):

valscanner ~/Pictures --no-thumbnails --label photos-2026 --db photos.db

"Find near-duplicate folders before migrating to a NAS"

# Scan and immediately run analysis — results print to the terminal
valscanner /Volumes/OldDrive --label old-drive --db migration.db --analyze

# Or run analysis later against an existing database
valscanner --analyze --db migration.db --threshold 0.6 --skip-caches

Pairs with a score above 0.8 are strong duplicate candidates. Alternatively, open the Similar Folders tab in the GUI — cards are collapsible and show child pairs nested under their ancestor pair.

"Audit a project repo before archiving"

# Exclude build noise at scan time so it never enters the database
valscanner ~/Projects/acme --label acme-audit \
  --skip-vcs --skip-caches --skip-binaries --skip-logs --no-hash

Switch to the Folder tree panel to see which subdirectories are heaviest. Use View Filters → Extensions: log to check how much log data slipped through. The View Filters panel can also hide additional patterns without requiring a re-scan.

"Compare a drive before and after a cleanup"

valscanner /Volumes/Drive --label before --db drive.db
# ... do your cleanup ...
valscanner /Volumes/Drive --label after  --db drive.db
valscanner --list-scans --db drive.db

Both scans share the same .db file. In the GUI, use the Scans panel to switch between them and compare totals.

"Scan a server or large drive without a GUI"

# Full scan with thumbnails + samples, then export for offline analysis
valscanner /data --label server-audit --db /tmp/audit.db --export-json

# Lightweight index-only run (no hashing, no media) — much faster on huge trees
valscanner /data --no-hash --no-thumbnails --no-samples \
  --skip-vcs --skip-caches --skip-logs

# Copy the resulting .db to your laptop and open in the GUI
valscanner-gui --db /path/to/copied/audit.db

"Quick search without opening the GUI"

# Find all files matching "contract" in an existing database
valscanner --query contract --db ~/Documents/docs.db --list-scans

---

Auto-generated tags

Every file receives a set of tags automatically. Tags are visible in the detail panel and exported with the file record.

Category tags

Category	Tags added
photo	photo, photos, media
video / audio	video / audio, media
document / spreadsheet / presentation / ebook	category name, documents
code	code, source-code, lang-<ext> (e.g. lang-py)
archive	archive, compressed
executable	executable, binary

Size tags

Tag	File size
empty-file	0 bytes
tiny	< 10 KB
small	10 KB – 1 MB
medium	1 MB – 100 MB
large	100 MB – 1 GB
huge	> 1 GB

Folder keyword tags — applied when the file's path contains a known folder name:

downloads-folder · desktop-folder · documents-folder · pictures-folder · music-folder · videos-folder · backup · archived · old-files · temp-files · cached · log-files · work · projects · personal · private · shared · screenshots · wallpapers · fonts · assets · source-code · binaries · libraries · node-modules · python-venv · git-repo

Filename keyword tags — applied when the filename contains a known keyword:

resume · invoice · receipt · contract · screenshot · wallpaper · backup · draft · final-version · readme · changelog · license · build-file · docker · installer · config-file · log-file · test-file · notes · todo · report · summary · budget · sensitive

Extension tags

Extensions	Tag
.jpg .jpeg .heic .heif .raw .cr2 .nef	camera-photo
.png .svg .webp	graphic
.mp4 .mov .m4v	modern-video
.mp3 .flac .m4a .aac	music-file

Other tags: hidden-file, dotfile (files starting with .)

---

Database schema

Every database contains the same logical schema regardless of backend:

Table	Contents
scans	One row per scan session (label, root, file count, total size, timestamp)
files	One row per file; extra_meta is a JSON blob of rich metadata (EXIF, audio tags, etc.)
folders	Cumulative byte/file counts for every ancestor directory up to the scan root
thumbnails	JPEG blobs keyed by file_id
media_samples	Low-quality audio/video clips keyed by file_id
analysis_runs	One row per similar-folders analysis; stores results, filters, threshold, duration
alembic_version	Single-row table tracking the current migration revision

Full-text search is implemented per-dialect:

• SQLite — an additional FTS5 virtual table files_fts mirrors files, kept in sync by AFTER INSERT / UPDATE / DELETE triggers
• PostgreSQL — files.fts is a tsvector column with a GIN index, populated by a BEFORE INSERT OR UPDATE trigger that weights filename > category/tags > path

The SQLite database is a plain .db file — query it directly with any SQLite client:

sqlite3 ~/valscanner.db "SELECT filename, size_bytes, category FROM files ORDER BY size_bytes DESC LIMIT 20"

---

Project layout

val-scanner/                ← repo root
├── pyproject.toml          ← packaging & entry points
├── valscanner.spec         ← PyInstaller spec (native app)
├── app_entry.py            ← PyInstaller entry point
├── scripts/
│   ├── build_app.sh        ← macOS/Linux native app builder
│   ├── build_app.ps1       ← Windows native app builder
│   ├── build_web.sh        ← bundles the React SPA into valscanner/web/static/
│   ├── install.sh          ← macOS/Linux installer
│   ├── install.ps1         ← Windows PowerShell installer
│   └── bump_version.py     ← update version across all files
├── web-ui/                 ← React + Vite source for the Web UI
│   ├── src/                ← components, hooks, API client
│   ├── package.json
│   └── vite.config.js
├── tests/                  ← pytest suite (core repository, web routers, settings)
│
└── valscanner/             ← installable Python package
    ├── cli.py              ← CLI entry point (valscanner)
    ├── alembic.ini         ← in-package migration config
    ├── migrations/         ← Alembic versions 0001 → 0004
    │
    ├── core/               ← zero Qt dependencies; backend-agnostic
    │   ├── app_settings.py ← load/save settings.json + active_url() + mask_url()
    │   ├── db_config.py    ← SQLAlchemy engine factory + per-URL cache
    │   ├── bootstrap.py    ← ensure_schema(): runs Alembic at startup
    │   ├── exceptions.py   ← DBConnectionError, DuplicateRecordError, …
    │   ├── schema.py       ← SQLAlchemy Table metadata + FTS helpers
    │   ├── db.py           ← thin facade re-exporting Repository + free fns
    │   ├── repository/     ← Repository split into domain mixins
    │   │   ├── scans.py    ← create/list/delete scans
    │   │   ├── files.py    ← insert/list files, iter_files_for_export
    │   │   ├── folders.py  ← upsert/list folders
    │   │   ├── media.py    ← thumbnails + media samples
    │   │   ├── search.py   ← search_paged (FTS5 / tsvector), search_files
    │   │   └── analysis.py ← similar-folder run persistence
    │   ├── categories.py   ← extension → category mapping
    │   ├── metadata.py     ← EXIF, audio, PDF, thumbnail, media-sample extractors
    │   ├── tagging.py      ← generate_tags()
    │   ├── scanner.py      ← scan() — calls ensure_schema, then walks + indexes
    │   ├── similarity.py   ← find_similar_folders()
    │   └── export.py       ← export_csv(), export_json()
    │
    ├── gui/                ← PySide6 desktop GUI (valscanner-gui)
    │   ├── window.py       ← MainWindow
    │   ├── workers.py      ← ScanWorker, AnalysisWorker, ConnectWorker
    │   ├── models.py       ← FileTableModel, FileIconModel, ThumbnailCache
    │   ├── delegates.py    ← FileCardDelegate (grid), FileRowDelegate (list)
    │   ├── dialogs.py      ← ScanOptions, ViewFilters, DatabaseSettings dialogs
    │   └── panels/
    │       ├── detail.py   ← file inspector (tags, metadata, thumbnail)
    │       ├── folders.py  ← folder tree
    │       ├── similar.py  ← similar-folder cards
    │       ├── scans.py    ← scan session switcher
    │       └── console.py  ← stderr bridge / log output
    │
    └── web/                ← FastAPI Web UI server (valscanner-web)
        ├── server.py       ← create_app() — wires routers, serves SPA, mounts /api
        ├── scan_registry.py ← in-process scan progress + SSE fan-out
        ├── models.py       ← Pydantic request/response shapes
        ├── routers/        ← scans, files, folders, media, export, reveal
        └── static/         ← built SPA (populated by scripts/build_web.sh)

---

Development

# Editable install with every optional extra
pip install -e ".[rich,web,postgres,dev]"

# Web UI dev deps (Node ≥ 18)
cd web-ui && npm install && cd ..

# Run without installing — module entry points
python -m valscanner.gui.window     # desktop GUI
python -m valscanner.cli /path      # CLI
python -m valscanner.web.server     # Web UI server (or: valscanner-web)

# Run the test suite
python -m pytest                    # full suite (PG tests auto-skip without DATABASE_URL)
DATABASE_URL=postgresql://localhost/test python -m pytest tests/core/test_repository_pg.py

Output files (*.db, *.csv, *.json) and the Web UI build output (valscanner/web/static/, web-ui/dist/, web-ui/node_modules/) are gitignored.

Database migrations

Alembic configuration lives in-package at valscanner/alembic.ini and valscanner/migrations/. To author a new migration:

# Auto-generate a revision against your current dev DB
DATABASE_URL=sqlite:///./dev.db \
    alembic -c valscanner/alembic.ini revision --autogenerate -m "describe change"

# Apply
DATABASE_URL=sqlite:///./dev.db \
    alembic -c valscanner/alembic.ini upgrade head

In production core.bootstrap.ensure_schema() runs upgrade head on every startup, so users never have to invoke Alembic manually.

Building native apps

# macOS (.app bundle, optionally .dmg)
bash scripts/build_app.sh
bash scripts/build_app.sh --dmg

# Linux (standalone directory + .tar.gz)
bash scripts/build_app.sh

# Windows (.exe via PyInstaller, optionally Inno Setup installer)
.\scripts\build_app.ps1
.\scripts\build_app.ps1 -Installer

Bumping the version

python scripts/bump_version.py 0.2.0

Updates pyproject.toml, valscanner/__init__.py, valscanner.spec, build_app.sh, build_app.ps1, and assets/windows_version_info.txt in one pass.

---

License

MIT — Copyright (c) 2026 Abdalrahman Valabji