On: SQLite the only database you will ever need in mos...

[joshspankit]

Use filename as your primary key and folder structure as “table”

Though, if you are doing a lot of joins your application is probably a better fit for a graph database instead of a “relational” one anyway