VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Apr 12, 2009, 06:55 AM
Anonymous Anonymous is offline
Junior Member
 
Join Date: Apr 2009
Posts: 11
Default Several database-related questions

1. Could you please provide a complete dump of your database (except usernames and password hashes, of course) for offline use? It would help to have a portable snapshot of VGMdb for multiple purposes; for example it feels more intuitive to locally execute select query in the console or a script, rather than receive html from your server and (visually or programmatically) parse resulting page. Even better if it were regularly updated (public API might help, yet it would still require internet access to use and make one feel guilty about needlessly loading your server).
2. Correct me if I'm wrong, but it seems to me you are storing some supplementary track data as text blobs (Notes), rather than separate fields in DB. If the reverse were true it would make much more sense because it would be possible to:
a) indicate which tracks were used to create any particular remix track (think touhou) and search on these relations,
b) have per-track composers, arrangers and performers (and search on these relations).
Is this functionality in plans?
3. Any ETA for sample precision track lengths?
4. Same for .cue import/export?
(3. and 4. are somewhat related)
Reply With Quote
  #2  
Old Apr 13, 2009, 02:38 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

1. I aim to set up a public API (returning XML) for this; at 12k entries the database isn't actually that large, so I think we can handle the load.
2. (a) and (b) are both planned. ETA should be sometime in May.

Everything hinges on the database restructuring really; (3) and (4) would be implemented in tandem with (2).
Reply With Quote
  #3  
Old Apr 20, 2009, 02:16 PM
Anonymous Anonymous is offline
Junior Member
 
Join Date: Apr 2009
Posts: 11
Default

Is your new database schema already defined?
Reply With Quote
  #4  
Old Apr 20, 2009, 07:51 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

For the most part, yes. I'll put together something next week for you guys to look over.
Reply With Quote
  #5  
Old Apr 21, 2009, 06:26 AM
Anonymous Anonymous is offline
Junior Member
 
Join Date: Apr 2009
Posts: 11
Default

Thanks. May I suggest to add two more fields in the physical compact disc table, namely left- and right-channel dynamic range (floating point)? While probably not as important factor in VGM as it is in other music, DR compression is a beast worth fighting everywhere.
There is a tool that takes a CD wav image as an input and outputs a numerical value in dB that is indicative of the perceived album dynamic range. Of course their choice of loudness metric is rather arbitrary, but at least it gives something to start from. I think it'd be nice to include this data (probably a single value that is the average of both channels, rounded to 1 decimal place, in javascript) in album page to let users know what they could possibly be getting.
Reply With Quote
  #6  
Old Apr 21, 2009, 03:50 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Sounds good, I'll add that in.
Reply With Quote
  #7  
Old May 23, 2009, 12:48 PM
Anonymous Anonymous is offline
Junior Member
 
Join Date: Apr 2009
Posts: 11
Default

Um, not to nag, but... any progress?
Reply With Quote
  #8  
Old May 23, 2009, 01:01 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

I've put it on hold while I work on the podcast section, which should be done by Sunday.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Romanization Questions whatkind Questions and Comments 5 Feb 9, 2018 07:11 AM
Questions about Foobar Spirit_Chaser Miscellaneous Discussion 2 Sep 21, 2014 12:59 PM
VGM related Wallpapers ritsukai Video Game Music Discussion 1 Nov 6, 2012 01:58 AM
Few questions regarding the database Meudeujeu Questions and Comments 3 Aug 4, 2011 07:10 AM
Bug? Collection related BahamutZ Questions and Comments 1 Feb 20, 2008 08:39 PM