HN Explorer

Ask HN: Tool for Mac, create database from filesystem

2 points by beamatronic ↗ HN
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.

3 comments

[ 4.3 ms ] story [ 22.1 ms ] thread
colburnmh
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.
beamatronic
For 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