Some notes from a cool meeting at RH today
by Greg DeKoenigsberg
Had a good chat with Adrian Likins, Steven Salevan and Luke Macken today
about what a "music collaboration server" might look like. Here's a whole
firehose full of notes. To Adrian/Steven/Luke, this'll probably mean more
-- but any questions, feel free to ask. :)
We're getting together again here in Red Hat HQ to brainstorm more about
possible clients on Thursday. For those of you on the list who aren't
from around here, apologies, and we'll start filling in gaps soon.
--g
=======================================================================
The Four Steps
--------------
1. EXPORT TOOLS AND RULES. Figure out how to get output from every major
music production tool into a simple, common format. If it's tools that
plug in to GarageBand/Steinberg/Logic, great. If it's a 20-step HOWTO for
each of those tools, great. The end result: wav/midi files, per track,
that can be easily shared.
2. DEFINE COMMON METADATA FORMAT. Rough database schema follows.
3. REPOSITORY FOR METADATA. Ditto.
4. UPLOAD TOOLS. We need some simple way of getting "sharable" data into
the system initially.
The WAG at Schema
-----------------
user
email varchar
password varchar
asset
(a superclass, subclassed per asset type)
id varchar (md5sum)
creator_id fk (user.email)
license_id fk (license table)
uri varchar
creation_date date
music_asset
(a subclass of asset, we thus leave the possibility of video/clipart/etc.)
asset_id fk (asset.id)
lyric_id fk (lyric.id) (nullable)
type? (midi/wav/loop/etc?)
key? varchar?
tempo? varchar?
bpm? int?
others?
lyric
id varchar (md5sum)
author fk (user.email)
authored_date date
song
id varchar (md5sum)
producer_id fk (user.email)
uri varchar
production_date date
song_tracks
song_id fk (song.id)
track_id fk (music_asset.asset_id)
track_parent
track_id fk (music_asset.asset_id)
parent_id fk (music_asset.asset_id)
Other stuff:
tagging schema for songs and tracks
--g
-------------------------------------------------------------
Greg DeKoenigsberg || Fedora Project || fedoraproject.org
Be an Ambassador || http://fedoraproject.org/wiki/Ambassadors
-------------------------------------------------------------
17 years, 8 months