What are the best practices when referencing to a file (in a bucket) in the database?
Here are the three ways I have tried:
1. Creating a text column with the full path to the file
2. Creating a text column with only the name of the file
3. Creating a foreign key column referencing the storage schema and the objects table
Also, when dealing with multiple files, should I just reference the folder they are in, or should I create a text[] column referencing each one?
I am feeling overwhelmed by the options, would love an informed opinion.
1. Creating a text column with the full path to the file
2. Creating a text column with only the name of the file
3. Creating a foreign key column referencing the storage schema and the objects table
Also, when dealing with multiple files, should I just reference the folder they are in, or should I create a text[] column referencing each one?
I am feeling overwhelmed by the options, would love an informed opinion.
