← Back to context

Comment by crazygringo

2 months ago

You can put tens of thousands of files in a single file lots of ways that are expressly designed for that. You don't need SQLite for that.

So why would you want to use SQLite for that is my question? Mounting a database or a table as a filesystem doesn't make much sense to me. There's a very poor fit between the two paradigms. What does a subdirectory mean in a database? What does a foreign key or set of columns mean in a filesystem?

4 comments

crazygringo

Reply
euroderf  2 months ago

Maybe you misunderstand the scenario. An SQLite DB can have records where each record contains a path. This column can be used to emulate a hierarchical tree-type filesystem. There's a few different ways to represent the path information, and the parent-child connectivity among records.

  • crazygringo  2 months ago

    Ok. Again, why? Why would you want to use a relational database as a filesystem rather than a file format explicitly designed for that, for mounting?