> My preference (and it seems to be fairly efficient), is to continue with
> the standard design pattern of storing metadata (file-path, etc) in the
> database and storing the file in the filesystem. You can them make
> programatic references much easier.
Thank you. I used too mostly this is the approach with other frameworks.
I just wondered if Cayenne has some better support for this common scenario.
>> The second one seems to be the most efficient, but than the entire
>> transaction support is lost :(.
>
> Not sure what you mean by "transaction support", so I can't comment on
> this.
I mean that in the case of a file system based approach, where the
metadata is in the database, the operations on files are not guarded by
transactions, nor can they be process in the same Cayenne transaction
like on the metadata of those files. So when problems occur during
editing, deleting, etc. the system is not consistent and can't be really
rollbacked.
Thank you,
Joseph.
This archive was generated by hypermail 2.0.0 : Sat Mar 21 2009 - 18:42:06 EDT