← All Projects
Complete
View Schema (TypeScript)
A complete rewrite of the View Schema SQLite viewer in 100% strict TypeScript. tsc compiles both the Express server and the KitaJS server-rendered views, eliminating Vite from the build. Pure schema logic moved out of the view layer into a testable module covered by 22 Vitest tests, with a fully typed domain layer and validated auth routes.
Tech Stack
TypeScript 6.0Express 5@kitajs/htmlbetter-sqlite3Vitest
Key Features
- 100% strict TypeScript (tsc --strict) — no Vite, tsc emits server and KitaJS views
- Pure schema helpers extracted to a unit-testable module — 22 Vitest tests passing
- Fully typed data layer, session handling, and route params with input validation
- PRAGMA identifiers properly quoted and static assets resolved from __dirname