Evidence desk
Import permitted searchable PDFs and review extracted fields against source excerpts and pages.
Research / App case study
PACS
A localhost-only research desk for permitted thesis PDFs, evidence review, FTS5/BM25 and TF-IDF search, an auditable analytical data mart, and a validated PQL interpreter.
Localhost-only academic research prototype
- React
- TypeScript
- Express
- SQLite
- PQL
01 / Overview
What it’s built for.
Connect source-aware research review, explainable discovery, an analytical data mart, and a bounded query language without a cloud dependency.
Who it serves
Students and reviewers preserving permitted thesis PDFs and tracing academic evidence.
02 / Features
Inside the app.
Discovery and continuity
Search verified evidence with FTS5/BM25 and TF-IDF similarity, showing relationships as candidate evidence.
Warehouse and PQL
Run logged ETL, review analytical snapshots, and execute validated saved queries through PQL.
03 / Workflow
From task to outcome.
Import a permitted, searchable thesis PDF.
Review and verify extracted evidence against its source.
Search related studies or build a bounded PQL query.
Load eligible evidence into the warehouse and review reports or evaluation artifacts.
04 / Technical layers
How the pieces work.
React · TypeScript · Vite
The local research desk provides review, discovery, query, and backup workspaces.
Node.js · Express
A loopback-only server performs import, review, search, ETL, and backup operations.
SQLite · FTS5 · Local PDFs
Separate operational and analytical databases store evidence, review history, ETL snapshots, and audit records.
PQL · BM25 · TF-IDF
Lexer, parser, semantic validation, and prepared execution keep queries bounded and source-aware.
05 / Limitations
What to keep in mind.
- The source thesis remains authoritative; the system does not prove research gaps, grade work, or approve titles.
- Normal operation has no OCR, cloud model, or external API dependency; imported PDFs must be searchable and permitted.
- Offline walkthrough, restore drills, real-corpus evaluation, and target-device performance require separate acceptance evidence.
06 / Evidence
Follow the source.
These descriptions were reviewed against the linked source snapshot on October 12, 2026. Repository code and documentation may evolve after this review.