How sseraflm/blue-rose-archive works
Blue Rose Archive is a song discography and credits archive. Editors add structured song and cover information to a hand-maintained JSON source, then a CLI sync upserts it into MariaDB. Visitors browse the catalogue, inspect song details, and use live search; those public pages read from the database. The graph includes the shared PDO layer and the documented relational schema. The README supports the overall workflow, while sampled source confirms the specific page queries and JSON/database operations; unsampled implementation details are not inferred.
Main entry points: db.php PDO connection · sync.php Data sync · index.php Catalogue page · search.php Search API
Components 11
Song authoring
- Local editor
tools/add-song.php - Song source
data/songs.json - Data sync
tools/sync.php
Public archive
- Catalogue page
public/index.php - Live search
public/js/search.js - Search API
public/api/search.php - Song detail
public/song.php
Persistence
- PDO connection
src/db.php - Archive schema
database/schema.sql - MariaDB
Other components
- Visitor
Connections 16
- Local editor → Song source: appends entries
README.md - Data sync → Song source: reads entries
tools/sync.php - Data sync → PDO connection: loads connection
tools/sync.php - Data sync → MariaDB: upserts songs
tools/sync.php - Visitor → Catalogue page: opens catalogue
README.md - Catalogue page → PDO connection: loads connection
public/index.php - Catalogue page → MariaDB: queries catalogue
public/index.php - Visitor → Live search: types query
public/js/search.js - Live search → Search API: requests matches
public/js/search.js - Search API → PDO connection: loads connection
public/api/search.php - Search API → MariaDB: searches titles
public/api/search.php - Visitor → Song detail: opens song
README.md - Song detail → PDO connection: loads connection
public/song.php - Song detail → MariaDB: reads song data
public/song.php - PDO connection → MariaDB: opens PDO session
src/db.php - Archive schema → MariaDB: defines tables
README.md