backend
database
devops
Added typed repository layer and DatabaseService to @suprlogs/database
- Repository layer with DatabaseService, 16 repositories, and 136 tests — Restructured the database package to provide a single DatabaseService + lazy db singleton that exposes fully-typed repository classes for all tables. This improves reliability and makes backend code easier to use and test (136 Vitest unit tests added and all passed).
Repository layer
- Added a DatabaseService facade and a lazy `db` singleton to @suprlogs/database to provide a single, easy-to-use entry point for database access.database
Repository APIs
- Added 16 fully-typed repository classes (e.g. UserRepository, ProjectRepository, ChangelogEntryRepository, EntitlementRepository) with explicit input/output interfaces covering every table in the schema.backend
Types & client
- Added createDatabaseClient() (service-role Supabase client) and a hand-written Database type describing all 19 tables so repository methods are type-safe.database
Tests & quality
- Added 136 Vitest unit tests for repository logic; all tests passed and TypeScript compiled with zero errors, improving stability and confidence for backend changes.devops
Packaging & exports
- Updated packages/database exports to expose repositories, types, and createDatabaseClient; added vitest devDependencies and `test`/`test:watch` scripts to package.json.devops
Documentation
- Updated changelog and package docs to describe the new repository layer and where to find the database types and repository interfaces.