2 ms·
> As my app matured, I found that I often wanted hierarchical folder-like functionality. Rather than recreating this mess in db relationships, it was easier to
by raverbashing 2y ago
> As my app matured, I found that I often wanted hierarchical folder-like functionality. Rather than recreating this mess in db relationships, it was easier to store the path in sqlite and work with it in Python. E.g. `os.listdir(my_folder)`
This makes total sense and it is also "frowned upon" by people who take a too purist view of databases
(Until it comes a time to backup, or extract files, or grow a hard drive etc and then you figure out how you shot yourself in the foot)
- Kalanos 2y agoTo make it more queryable, you can have different classes for dataset types with metadata like: file_format, num_files, sizes