Stores file metadata wastefully
For any given backup, most of the metadata for each file is likely to be the same, but we store them separately for each file system entry.
Of the metadata we store, the following is likely to be duplicated among many files:
kind: FilesystemKind,
mode: u32,
uid: u32,
gid: u32,
user: String,
group: String,
We could have a new table, common_file_metadata
, where we store every unique set of metadata listed above, and then store a row number into the common table for each file, as well as any metadata not in the common table.
This might let us make the size of the generation SQLite database smaller. Needs experimenting.