cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joseph Schmidt <>
Subject Re: How to map/model files?
Date Sat, 21 Mar 2009 22:41:10 GMT
> 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 

Thank you,

View raw message