I am working with an archive institution which has a large repository (papers,
manuscripts, photos, objects). They curretlymanage their archive collection
on an ACCESS 3.0 database and need to migrate to a better platform. Much
of their database is about managing their workflow (tracking accessions,
inventory, reporting on statistics on reference usage, etc.). Since it will
mostly be for internal usage (although their website will use it as a backend
for collection searching), what programing language and/or open source
technologies are most flexible and popular right now in the library/archive
world? They have customized their current database too much to
accommodate to a "off-the-shelf" type package.
I am new to the Code4lib site and your advice is much appreciated.