3 ms·
Ask HN: Tool for Mac, create database from filesystem
I need a tool that can recursively scan a folder on a Mac and create a relational database (could be SQLite, postgres, mysql, etc) containing the file attributes for all the files and folders found. I haven't seen any tool that does exactly this and was curious if the HN crowd knew of one.
- colburnmh 5y agoYou could try using find(1) to display the results and use that to capture the results, and then use cut(1), sed(1), or awk(1) to convert that to a CSV that could be loaded into your database of choice: find . -print -ls | awk ... > /tmp/foo.txt Not sure if that gives you what you want, but it's a relatively fast way to get to what you want, I think.
- beamatronic 5y agoFor starters, I want all the output from stat() Additionally for images, I would include the EXIF information It would all go into a relational DB so it can be queried with SQL
- slater 5y agoMaybe Automator can help? https://support.apple.com/guide/automator/welcome/mac https://support.apple.com/guide/automator/welcome/mac