Backup Manager

I have been working on a side project which I am still debating the name of called Backup Manager. I am currently using this program to index and keep track of all my files inside my backup drives.

Usually I buy two HDD drives, one for the backup and one for the backup of the backup, and they are usually around 2 to 8 TB in size, the poor man's RAID1 configuration. As I am an enjoyer of borrowing things permanently, and sharing them around using the internet, I have a lot of data.

Features:

• Recursively index all the files from a directory and store them in an H2 database for querying access.
• Recursively compare two directories and show the differences between them either in the console or in a report TXT file.
• Validate a directory against an H2 database and show the differences.
• Export an Excel file of the H2 database for easy viewing.

Additionally, it can copy over missing and different files from one directory to another while comparing. All of these features are simple and easy to use, and most importantly all I need to happily maintain order of where I keep what.

The database stores files in a single table with the following columns:

• id - ID of the DB entity (autogenerated)
• name - File name with the file extension
• hash - CRC32 hash of the file for integrity checks
• path - Full path from the root of the indexed directory
• type - MIME type of the file as reported by Apache Tika
• created - Timestamp when the file was indexed
• updated - Timestamp when the file was re-index (file changed)

Currently, the program has one known issue and that is that it does not remove files from the database when they are deleted from the disk. This is a feature I plan to add in the future, but for now, I am happy with the way it works. I can always run the program again to re-index the files in a new DB.

And if you are asking me why I didn't use a multitude of other programs for indexing. Well it is fun writing this piece of software. The project is available on my GitHub