[peter0conor]

Good morning,

I' m in the process to unify several book databases that I have, and create a master library database which could be more robust for corruption and last long independently of which operating system I use in the future. To be honest, I prefer a reliable book database which is stable than a database with faster performance. For those of you how have longer experience with book databases, could you please give me your recommendations about the following?

- How many files or books should I have as a limit before creating a second library?
- Should I keep the files compressed (i.e. rar, or zip) or uncompressed as pdf, epub, mobi. etc?
- Should I create a structure by folders (i.e. authors) and sub-folders (i.e. titles) with the different book formats (i.e. pdf, mobi, epub, etc) all together or should I just leave all files together in a flat structure with only one parent folder?
- Should I rename book files with a longer but more meaningfully name (i.e. Dan Brown - The Davinci Code), or use short names (i.e. Davincicode.pdf) avoiding spaces or symbols to make it more difficult to get corrupted?
What should I do to maintain the configuration files that keep my customizations (i.e. tags, covers, new columns, etc)
- Should I use specific hard drive to keep my database and access it remotely or locate the database in the same location where my OS?
Thanks for your time and support,
Sincerely,
Peter