FWIW: If you find that you need something like this, consider using a different file storage product. Most likely, it's using SQLite and the schema is useful.

FWIW: If you find that you need something like this, consider using a different file storage product. Most likely, it's using SQLite and the schema is useful. I used to be the lead on Syncplicity, a desktop file synchronization product. All of the local state was in SQLite. Early versions of the desktop client kept the complete path to every file in the associated row in SQLite. Later versions kept the filename and foreign key to the directory row. Bittorrent Sync (I forget its new name) also used to use a SQLite database for local metadata. And, finally: It's not that hard to write a tool to recursively scan a folder and grab all the metadata of files. You can scan 1000s of files in a matter of seconds.