Hi, I own a business and through the business, I have amassed a large collection of training information and other things in the form of cds. For ease of access, I have ripped all my cds to mp3 format and stored them on my computer. This is not illegal and I have permission to do so. Here is my problem, my mp3s can be categorized in several different ways and a lot of them appear in different spots, for instance 1 particular mp3 can be found in a particular series, but also in a special promo pack meaning that I have the same file in 2 different places making my filesystem a total mess. In some cases, I have the same file in 6 different places. This is very inefficient and takes up a lot of space on several hard drives when you count in backups. I am looking for a way to add each new file only once and have some kind of front end that I can tell it all the categories said file fits into and then be able to use said front end to search files via drop downs. A filtering system of sorts. This would allow me to have only one instance of each file, but it would show up in multiple filters. Once that is working, I want to privately (only available to those with credentials) publish this to the web with the same front end look. I am told that a database is the way to go, but I have never worked with databases before. Is there a "gui" database program I could use for this purpose? I hope this makes sense and I am hoping you can point me in the correct direction to do what I am looking to do. Thanks in advance for your support, Dave.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.