Posted March 22, 2020
So here is a topic I often think about. Being a digital hoarder, and an organisation freak, I always reassess how I am organising my backups. So this is twofold, actual storage organisation and then tools to work with that.
Actual storage:
So, I currently have two sections, with the following folder structure:
Games
<first letter>
<series> - optional
<game name> [<year>] [platform]
<store>
Docs
Mods
Patches
Multimedia
Film
<film name> [<year>] [<tags>]
Music
<artist>
<album>
Tv shows
<show name>
Season <x>
Music videos
<name>
So this seems to work ok, am debating on wether or not to divide up movies etc. to use first letter like games. Anyone else have their own setup that they want to show? I find it is far easier to work with a fixed folder structure programmatically.
Tools:
For the last couple of years I have been using collectorz game library. It’s ok but it’s subscription based and closed. Have looked at a few things over the years but nothing seems to fit my requirements. Launchbox looks nice, but no import of metadata, also no direct access. Excel, it’s really not a database and using it as such will corrupt your data eventually.
So I think I will go with a two pronged approach. In the immediate future have sqlite studio as a front end for an SQLite database, perhaps build some tools to work with the folder structure (eg check what is in dB matches what is on disc, maybe md5 checks etc.). Then later on will build my own front end (when I have some free time) and incorporate the various tools into it.
What do others use?
For my purpose, I have a list of requirements which hasn’t helped:
Offline
Open backend
Ability to run tools, or script in the system
Not a proprietary client
Just interested what others do.
Actual storage:
So, I currently have two sections, with the following folder structure:
Games
<first letter>
<series> - optional
<game name> [<year>] [platform]
<store>
Docs
Mods
Patches
Multimedia
Film
<film name> [<year>] [<tags>]
Music
<artist>
<album>
Tv shows
<show name>
Season <x>
Music videos
<name>
So this seems to work ok, am debating on wether or not to divide up movies etc. to use first letter like games. Anyone else have their own setup that they want to show? I find it is far easier to work with a fixed folder structure programmatically.
Tools:
For the last couple of years I have been using collectorz game library. It’s ok but it’s subscription based and closed. Have looked at a few things over the years but nothing seems to fit my requirements. Launchbox looks nice, but no import of metadata, also no direct access. Excel, it’s really not a database and using it as such will corrupt your data eventually.
So I think I will go with a two pronged approach. In the immediate future have sqlite studio as a front end for an SQLite database, perhaps build some tools to work with the folder structure (eg check what is in dB matches what is on disc, maybe md5 checks etc.). Then later on will build my own front end (when I have some free time) and incorporate the various tools into it.
What do others use?
For my purpose, I have a list of requirements which hasn’t helped:
Offline
Open backend
Ability to run tools, or script in the system
Not a proprietary client
Just interested what others do.