From: OFeem1987@teleworm.us   
      
   DFS wrote this post by blinking in Morse code:   
      
   > Here's some Python code I wrote to capture file metadata (name,   
   > location, date created, date modified, and size) in a SQLite database.   
   >   
   > Then I created some views you can run to learn more about your files and   
   > folders. And you can write your own queries of course.   
   >   
   > The program will create a 'filecapture.sqlite' database file in the   
   > folder from which the code is run, but you can pass in whatever   
   > directory you want to capture.   
   >   
   > On Windows, on my mid-range computer, the program processes:   
   > 11.4K files in  823 folders in  1.1 seconds   
   > 26.8K files in  255 folders in  2.6 seconds   
   > 60.0K files in 4397 folders in  8.6 seconds   
   > 90.6K files in 6760 folders in 13.5 seconds   
   > 440K files and 57K folders didn't finish in minutes so I shut it down.   
   >   
   > The major slowdown is one cartesian/update query - used to summarize   
   > data in all subdirectories - for which I haven't been able to figure out   
   > a decent workaround.  A cola 'Big Swinging Dick' award will be given to   
   > whoever can fix this speed issue.  Look in the code for 'cartesian   
   > query', and at view v_Temp.   
   >   
   > Tested on Windows and Linux/WSL.   
   >   
   > usage examples:   
   > $ filecapture.py  /home/dfs/computer/hardware   
   > $ filecapture.py  /movies/porn   
   >   
   > code file: https://filebin.net/d726wbjyc20gd29d   
   > (link expires in 6 days)   
   >   
   > screenshots of database objects and sample rows:   
   > https://imgur.com/a/qAhTflV   
   >   
   > Enjoy!   
      
   Thank you for your Linux advocacy.   
      
   --   
   How sharper than a serpent's tooth is a sister's "See?"   
   		-- Linus Van Pelt   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)