This is a feature request: i'm a big fan of Libre Office and would always use it if possible, but i am in the situation now where i need to build a database of documents that my organization has published in the past. To do so, i wish to make a database of names, titles etc for each document. BUt i also wish to upload each document into the database, so that the file is easily shareable to different people and copiable to different hard drives. Unless i've missed it, this is not possible in Base. It IS possible in Access, so I;m working with that now, but hence the feature request:)
@Rik : you can store binary data in your embedded database, but if you do that with embedded hsqldb ODB, the database will become unwieldy (memory management issues) and error prone over time (you also need how to figure out how to display the PDF, but this is technically possible).
Ideally, the PDFs should be stored separately in a file store, and a path URL to each one stored in the database. This will reduce portability though, as the path to the PDF store would have to be identical on each machine (and the store transferred along with the ODB file).
Whilst I can agree to the request for enhacement, given the current environment surrounding embedded database files, I doubt that this is going to change any time soon.
This issue has been around since embedded hsqldb in an ODB file was first developed, hence inherited from OOo.