# Sprint 8 v1.7 - Quality Review & Data Decision

## Fixes

- Unified User Log and Review Log into Audit Logs.
- Audit Logs show full raw log content in an expandable detail block.
- Score fields are clamped to whole numbers from 0 to 100.
- Required fields are highlighted in red before publishing a supplier record.
- Portal preview now shows application preview while typing instead of record-selection placeholder.
- News is separated from Complaint / Content navigation.
- Ad placements are reorganized by exact page location with clearer descriptions.
- Methodology is rewritten into professional scoring explanations.
- Database recommendation clarified: PostgreSQL for online shared data, SQLite only for small single-server setups, CSV only for export/backup.

## Database choice

### PostgreSQL
Best for PSP Radar production. It supports multiple admins, audit logs, permissions, search, relationships and safe concurrent edits. Setup is slightly more work, but managed services such as Supabase, Neon, Render PostgreSQL and Railway make it straightforward.

### SQLite
Easier than PostgreSQL for a single small server and still much better than CSV. Good for early private deployment, but not ideal for multiple app servers or high concurrency.

### CSV
Do not use as the live online database. Use CSV only for exports, backups, reports and manual review.
