Currently I am working on a database for my album collection (mainly CDs and vinyl records). I am storing everything in a rather elaborate hash of hashes. I've got several routines set up right now that will allow me to add a new entry, modify an existing entry and then when I am done dump everything to a file (the file gets read in and populates the hash whenever the script starts.
What I am wondering is if there might not be a better way to do what I am doing, something perhaps more efficient? I've been toying with the idea of playing around with MySQL (since I've got that on my Linux box). Suggestions for things I might look at or try? I'd rather make big changes earlier on, before I spend a lot of time inputting information. Any comments would be appreciated.
Thanks in advance.