A friend of mine - a typical babyboomer - has a very extensive music inventory, especially a lot of compilation albums. He used to maintain a database software program called Reflex. Every time he bought a new compilation album he entered all artists and titles of the songs on that album.
The result is a database with one entry per song that he owned. The entry has three headers: title, artist and location. He mostly buys new compilation albums because they contain one or multiple songs that he likes. The database is used to check whether he already has an album that contains that song. He also uses it to check which album he needs to retrieve whenever he wants to listen to a specific song that he knows he owns.
So, I managed to run a DOS emulation on my server to run his old software. With this software, I succeeded in extracting a CSV file that contains all three values for every entry (title, artist, location/album). What I need now is modern software. I need to be able to inject the current database (CSV), and subsequently he can keep track of his inventory (search, update, delete). If possible, he would like the possibility of checking the database from his iPhone.
If you are familiar with software that has these functionalities, please let me know.
Thanks in advance!