HACKER Q&A
📣 beamatronic

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 Accepted Answer ✓
You 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.

👤 slater