It is my understanding that storing binary blobs like photos or videos is discouraged in LO Base. Rather, we should store the location of a file.
In my use case, I will likely want to have a single-user database as I am dealing with a scenario where not everyone is in the same office so using MySQL or similar database is not ideal. With the single-user database, I would have a subfolder in the folder where the database is located. That folder would contain the files that need to be referenced in the database. It could be photos, videos, or other kinds of documents. I will want to set this up so that I can store a filename and then be able to instruct the form how to retrieve it. If it is a photo or video, I would like to be able to display it in the form. If it is another kind of document, I would want to somehow have the OS launch the appropriate application for that type of file.
Where can I find information on how to go about this? In the past, I have had experience with Paradox, Access, and Filemaker. So the basic ideas of setting up a database and using a form editor make sense. But I have not had a need to add references to other files until now. Since my co workers have varying OS’s, I thought I would try Base to see if I can put something together for our group.