History:Next Generation Schema / Roadmap

Milestones

May 25

Object model and read-only user interface in place. This is essentially equivalent to Lukáš’ NGS-p implemented in Catalyst/Template Toolkit based on Oliver’s work from the last year. With this milestone users will be able to convert an existing database to the NGS schema and be able to browse the data in the new schema via the read-only user interface. No editing will be possible at this point in time.

• Data classes for core entities (artist + related, release + related, recording, release group, work)
• DB schema definition + basic Perl handlers:
  • Artist
  • Artist credit
  • Label
  • Recording
  • Work
  • Release group
  • Release
  • Tracklist + track
  • Medium
• ID cache
• GID cache (just redirects to IDs, not full objects)
• DB schema + Perl code for ARs [1]
• DB schema + Perl code for annotations [2]
• DB schema + Perl code for tags [3]
• DB schema + Perl code for ratings
• DB schema + Perl code for artist/label/work aliases [4]
• Data::ReleaseGroup::find_by_artist + controller for /artist/MBID with a list of release groups [5] [6]
• Data::Release::find_by_artist + controller for /artist/MBID/releases with a list of releases [7] [8]
• Data::Work::find_by_artist + controller for /artist/MBID/works with a list of works
• Data::Recording::find_by_artist + controller for /artist/MBID/recordings with a list of recordings [9] [10]
• Data::Release::find_by_label + controller for /label/MBID with a list of releases [11]
• Data::Release::find_by_release_group + controller for /release-group/MBID with a list of releases
• Controller for /recording/MBID [12]
• Controller for /work/MBID
• Tracklist loading + controller for /tracklist/ID [13]
• Medium loading + controller for /release/MBID [14]
• Controllers for /*/MBID/relationships
• Controllers for /*/MBID/aliases
• Controllers for /*/MBID/tags [15]
• Controllers for /*/MBID/annotation
• GID redirects + code for this in get_by_gid
• Local search engine using PG 8.3's text search [16] [17]
• Merge individual NGS update scripts into global Create*.sql scripts
• Conversion SQL script to migrate the database [18]

June 29

The basic types are in place for editing artists, labels, and release-groups. Release and track level edits will not be complete.

• Artist/label/release/etc. name lookup (find_or_insert_name) [19]
• Artist credit lookup (find_or_insert_artist_credit) [20]
• Insert/update/delete code:
  • Artist [21]
  • Label [22]
  • Release (not mediums or tracklists) [23]
  • Release group [24]
• Edit handlers:
  • Add artist
  • Edit artist
  • Merge artists
  • Remove artist
  • Add label
  • Edit label
  • Merge labels
  • Remove label
  • Edit release group
  • Remove release group
  • Merge release groups
• "Forms":
  • Add artist
  • Edit artist
  • Merge artists
  • Remove artist
  • Add label
  • Edit label
  • Merge labels
  • Remove label
  • Edit release group
  • Remove release group
  • Merge release groups - Pending review (draft)

July 27

Release and release related edit-types will be in place, but without a complete UI. The release edits will take a lot of work to get right so, we’ll have these edits in place, but may not be able to finish a working UI for them.

• Edit handlers:
  • Edit release edit type
  • Edit medium
  • Edit work
  • Edit track
  • Create medium

Aug 31

All remaining edit types are in place and the NGS enabled server enters beta phase.

• Server features:
  • Edit searches
  • Edit voting
  • Save/retrieve stash
  • List stashes
  • Indexed search
  • CDStub and DiscID/TOC submit wizard

• Edit handlers:
  • Edit tracklist -- Pending review for add track/delete track
  • Edit/create/delete release-label in edit release
  • Merge releases

• Forms
  • Release editor:
    • Editing releases
    • Editing mediums
    • Editing tracklists
    • Editing tracks
  • Client side support for sending/retrieving to/from stash
  • Edit stashes:
    • List
    • Open
    • Delete