Re: Blobs in the DataContext

2010-05-31 Thread Andrus Adamchik
still not very clear to me. Thanks. -Mike From: Tore Halset To: user@cayenne.apache.org Date: 05/25/2010 07:58 AM Subject: Re: Blobs in the DataContext Hello. I tried to implement support for streaming blobs back in 2006. Sorry, but it never got completed. I still think it is a nice

Re: Blobs in the DataContext

2010-05-28 Thread MGargano
don't mind, about this as I quickly (i.e. panic-mode) try to cobble something together. I'm just learning cayenne so a lot of the internals are still not very clear to me. Thanks. -Mike From: Tore Halset To: user@cayenne.apache.org Date: 05/25/2010 07:58 AM Subject: Re: Bl

Re: Blobs in the DataContext

2010-05-25 Thread Tore Halset
Hello. I tried to implement support for streaming blobs back in 2006. Sorry, but it never got completed. I still think it is a nice feature. If you want to work on this issue, you might want to take a look at streaming_blob_try2.zip from https://issues.apache.org/jira/browse/CAY-316 Regards,

Re: Blobs in the DataContext

2010-05-25 Thread Andrew Lindesay
Hello Mike; > the architecture I inherited for this product bills the BLOBs in the DB as > a sort of "feature" that I don't see changing anytime soon. Currently we Can you perhaps use "raw rows" equivalent to get the data out so that it does not cache? > btw. Andrew, I remember you and your

Re: Blobs in the DataContext

2010-05-24 Thread MGargano
happens in the Cayenne internals when you create a new object in the context, commit it, and continue using the same context. btw. Andrew, I remember you and your LEWOstuff from wowodc... very cool "stuff"! :) Thanks. -Mike From: Andrew Lindesay To: user@cayenne.apache.org Date: 05/2

Re: Blobs in the DataContext

2010-05-23 Thread Andrus Adamchik
Some database products offer "streaming" to and from BLOBs which is one get-around for these problems. This means you can theoretically get away with not having to hold the whole hunk of data in memory at once. Yeah, I was wondering the same thing. Blob is an interface that you can imple

Re: Blobs in the DataContext

2010-05-21 Thread Andrew Lindesay
Hi there Mike; I'd have to agree with Ari there; small BLOBs (usually in a sub-table) work fine with an object-relational mapping system like Cayenne, but trying to use an object-relational technology for big BLOBs is generally troublesome owing to the cost of shifting those big hunks of data a

Re: Blobs in the DataContext

2010-05-21 Thread Aristedes Maniatis
On 22/05/10 7:27 AM, mgarg...@escholar.com wrote: I'm using cayenne to store large files in BLOBs as a process runs. The first step of the process is storing large files (~ 600MB) I'm sure others will chime in with similar thoughts: ORMs are not really designed for this type of workload. For

Blobs in the DataContext

2010-05-21 Thread MGargano
Hi, I'm using cayenne to store large files in BLOBs as a process runs. The first step of the process is storing large files (~ 600MB) and they are ending up in the DB just fine, then we run some tasks and get some output files, and then store the large output files (~ 500MB) to the DB.