MMD > Archives > July 1997 > 1997.07.27 > 06Prev  Next


Database Software for Music Collections
By Bob Billings

As Meta Brown points out, almost any database program will do the job
-- it's just a matter of whether the existing templates will be
satisfactory.  Or how much work one can or is willing to do to set
it up the way he wants.

Some programs are quite easy to customize, such as one I ran into a
few years back called "ORGANIZE! Your Collection."  I think it was a
shareware program.  Another one is DataEase.  Both of these guide even
the neophyte quite well in setting up the database the way he wants.

Microsoft Access is easy to set up if one makes use of its "Wizard".
I don't like Wizards because I usually need to customize.  There are also
a number of SERIOUS database programs, such as FoxBase, but it takes a bit
of time to become skilled at using them.

One thing to think about is how one wants to retrieve and organize the
data.  Putting the data in is easy, but getting it out in a useful form
is not as easy as one thinks.  OYC was a disaster in this area, but
DataEase is fairly good.  Access is a little fussy to set up, but can be
good.

Years ago I set up our database in dBase III+.  It took a lot of
programming effort to make it do what we wanted, and it does it very
well.  Today's programs are a lot easier to work with, but our system
still does what we want and is rock-solid robust.  Our largest database
has over 10,000 entries.  Using search algorithms we can locate any
entry in that database in less than 5 seconds.

Over the years I have created a number of routines that can be called
with a few keystrokes.  (Gee, I kinda feel like I might be describing
how easy it was to build a log cabin using an axe, adze and saw!  It does
make me appreciate how technology has advanced.)

Bob Billings



(Message sent Sat, 26 Jul 1997 22:05:03 -0700 , from time zone -0700.)

Key Words in Subject:  Collections, Database, Music, Software

Related by Subject:
1997.07.27.06 (This article) - Database Software for Music Collections
2026.02.16.01 - Pipe Organ Patents In Bibliographic Database
from Jean-Yves Galipienso
2021.12.31.01 - IAMMP Piano Roll Database Public Domain Updates
from Skip Klosz
2015.11.17.05 - Seek Ampico Roll Database File
from Michael Fellenzer
2013.08.05.08 - Database of Scanned Music Rolls
from Roderick Sprattling
2013.08.05.09 - Database of Scanned Music Rolls
from Julie Porter
2013.08.04.07 - Database of Scanned Music Rolls
from Marshall Jose
2013.08.04.08 - Database of Scanned Music Rolls
from Julian Dyer
2013.08.04.09 - Database of Scanned Music Rolls
from Warren Trachtman
2013.08.03.01 - Scanned Roll Database
from Mike Walter
2011.12.04.01 - Piano Roll Database Software
from Duaine Hechler
2010.01.28.03 - Piano Roll Database Program & Windows 7
from Spencer Chase