Ask HN: Tool for Mac, create database from filesystem | Hacker News Reader

Ask HN: Tool for Mac, create database from filesystem

2 pointsbeamatronic3 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.

View on HN

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.

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

Maybe Automator can help?

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

Reply on news.ycombinator.com