Ask HN: Tool for Mac, create database from filesystem

2 pointsbeamatronic4 years ago3 comments

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 4y

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.

beamatronicOP4y

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

slater 4y

Maybe Automator can help?

https://support.apple.com/guide/automator/welcome/mac

Comments