3 ms·
> Pulling the metadata—file names, sizes, file types, file owners, creation dates—into a SQLite database felt like a great way to start understanding the size a
by NicoJuicy 5y ago
> Pulling the metadata—file names, sizes, file types, file owners, creation dates—into a SQLite database felt like a great way to start understanding the size and scope of what had been collected so far.
I would:
- sync the GDrive locally
- setup "search anything service" from voidtools
Voila. A super fast programmable index of the files.
If you want to dump it to SQLite, go ahead.
Ps. Applicable to Dotnet
Note: file owners wouldn't be known.
- simonw 5y agoIn my case the Google Drive folder that was shared with me has about half a TB in it, so going via the API seemed like a better option!
- NicoJuicy 5y agoAgreed :p
- nijave 5y agoIf you have a lots of files in Google Drive, this can take a significant amount of time or you may not be able to sync it locally. I push incremental backups & disk images without a retention period to Google Drive (it's unlimited storage) so there's quite a bit of data shoved in there It's pretty easy to get rate limited so it could take days or weeks to build an index (so having a tool that talks to the API is generally more reliable)