I would also appreciate any recommendations for
database software.
In addition to GCstar, which is an application you run on your
workstation, there are some open source collection management tools
aimed at museums and the like. Most of the latter probably require some
server side support. A few examples are listed here:
https://www.oedb.org/ilibrarian/5-free-and-open-source-tools-for-creating-d…
De