Angelina Jordan Wiki:Databases

This wiki uses the Cargo extension^↗ to create and maintain databases for certain types of information.

Existing databases

Performances database

The performance database gathers information about all known performances of songs (or wordless compositions) by Angelina. It is structured into a set of tables, and can be queried either generically or with a set of provided query templates and functions.

Tables

• Performances – an entry describes the performing of a song, which also includes rehearsals and fragments
  • is linked via the "songs" field with the "Songs" table (join on: Performance.song = song.page)
  • {{Performance}} - Cargo template declaring the table, and also used for creating entries to that table
  • {{cPerf}} - additional template for creating entries
  • link to more relevant things…
• Videos – videos or video parts of those performances
  • is linked via the "pid" (Performance ID) field to the "Performances" table (join on: Videos.pid = Performances.id)
  • {{Video}} - Cargo template declaring the table, and also used for creating entries to that table
  • {{cxvl}}, {{cytv}} - additional templates for creating entries
  • link to more relevant things…
• Song - basic information about the songs themselves
  • {{Song}} - Cargo template declaring the table, and can also be used for creating entries to that
  • {{Infobox song}} - the usual template to create an entry, used on the song's article page
  • link to more relevant things…
• Literals - a technical mapping of values to literals to aid the construction of a rating for videos based on performance type, and video duration and quality
  • {{cLiteral}} - Cargo template declaring the table, and also used for creating entries to that
  • link to more relevant things…

Queries / presentation functions

Besides the generic Cargo query page, there are some templates and Scribunto module functions that support extraction and presentation of data from the database.

• {{SongsTable}} - used in the Songs article to present a list of all songs and their performances
• {{FilteredPerformanceOverviewTables}} - used to present filtered performance listings, e.g. useed in the "On TV" and "Live concerts" articles.
• Module:Performances:createTable() function - used in the above template, and also on its own on Pages like Performances.
• link to more relevant things

Databases/tables being considered

There are many other things that could be "turned into" databases or addtional tables:

• YouTube channels
• Other social media pages
• Other websites
• References (i.e., published articles, etc.)
• Timeline events (this is starting to be implemented)
• Locations/venues
• Companies/organizations
• People (musicians, etc.)
• Recordings (i.e., things that are "released" and possibly can be purchased)
• Video meta data (this is currently available as JSON data)

See also User:Dcljr/Ideas and User:Most2dot0/Ideas for more thoughts along these lines.