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 11, 2012, 04:55 AM
Alpha23 Alpha23 is offline
Junior Member
 
Join Date: Apr 2009
Posts: 7
Default Database structure used for VGMdb?

Hi there!
I was wondering what kind of database you are using for VGMdb. I'm collecting game music and I haven't found an easy way to archive the music in a database. Currently I'm just using a speadsheet which serves the main purpose but of yourse is extremely ugly.
Any suggestion on how to build my own database without too much trouble? Regarding databases: I've never worked with one but I'm a quick learner.
Thanks for your help!
Reply With Quote
  #2  
Old Apr 11, 2012, 05:13 AM
Cedille Cedille is offline
Senior Member
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,026
Default

I remember VGMdb uses LAMP (MySQL).
Reply With Quote
  #3  
Old Apr 11, 2012, 05:47 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,240
Default

Probably the easiest way to build your own archive would be to learn Python and use an SQlite database, which is also included in Python. That's what I use for personal archive/database projects.
Reply With Quote
  #4  
Old Apr 11, 2012, 12:10 PM
LiquidAcid LiquidAcid is offline
Trusted Editor
 
Join Date: May 2008
Posts: 1,644
Default

Quote:
Originally Posted by Secret Squirrel View Post
which is also included in Python.
Since when is that the case? AFAIK SQLite is a C library, which implements a KISS SQL DB.
These are seperate projects. SQlite isn't even hosted on the Python project server. I think you're mixing something up here.

EDIT: Ah, you probably mean the pysqlite bindings? Didn't know that they're building and shipping this module now by default.

Last edited by LiquidAcid; Apr 11, 2012 at 12:23 PM.
Reply With Quote
  #5  
Old Apr 11, 2012, 12:26 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,240
Default

Yeah, it's in, as of 2.5.

http://docs.python.org/library/sqlite3.html
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
GHMR-001: The Silver #01 STRUCTURE Dag Album Discussions 3 Dec 4, 2020 05:30 PM
The database is down Rrolack Questions and Comments 3 Dec 19, 2017 05:08 PM
New Submission to the Database VGMLover Video Game Music Discussion 2 Nov 5, 2017 09:14 PM
GHMR-005: The Silver #01 STRUCTURE MiLO Album Discussions 0 Mar 5, 2013 07:38 PM
VGMdb hosting GMR Online database Secret Squirrel News and Announcements 14 Nov 6, 2009 05:50 PM