Stream directly from/to database?
Stream directly from/to database?
- Subject: Stream directly from/to database?
- From: Fredrik Lindgren <email@hidden>
- Date: Mon, 15 Feb 2010 08:28:03 +0100
| Hi,
I would like to stream a file directly to/from a database without creating an intermediate NSData in memory. I found the post below from 2003 by the late David Teran.
Does anyone have any pointers to this library?
If not, are there any alternatives?
/Fredrik
Hi,
we are very please to announce that we just released our OpenSource streaming framework for WebObjects 5.2 which enables to stream -directly- from the client into the database and from the database to the client using EOF and JDBC. WebObjects 5.2 introduced streaming featuers but nothing to stream into the database. Its still the old EOF way: use a NSData object which is OK for small blobs but impossible for large ones. Our ResourceStreamer solves this and some other frequent problems when dealing with large data.
Features:
- Transparent streaming of files into and out of the database without using EOF to store NSData objects in the database. This dramatically reduces the memory usage from a WebObjects application when one uses large binary objects, no matter if they are images or excel files or zipfiles.
- Connection pooling of JDBC Connections which are used to stream into and out of the database
- Java Interface BlobEntity with some simple methods which should be implemented by an EOEnterpriseObject in order to use the streaming features
- StreamingResourceURL: a replacement for WOImage, WOResourceURL and WOHyperlink with streaming capabilities
- DownloadInputStream : a java.io.InputStream subclass which streams a BLOB right out of the database including caching features in filesystem
- A Delegate interface to allow downloads based on the WORequest and WOSession which wants to access a StreamingResourceURL.
- A Delegete interface which informs about a finished download including statistic data like start and end time, total number of bytes and transfered number of bytes.
- An example application that uses FrontBase to stream out of and into the database.
The delegates enable you to create an application that allows downloading a file only once but as you can check if a download was complete you might allow 100 incomplete downloads until this 'modem user' was finally able to download your 300 MB commercial file ;-)
ResourceStreamer is published under LGPL which is suitable for commercial projects (its NOT GPL!). If you are unable to use LGPL'ed software: the software is also available under a commercial license.
API documentation:
http://www.cluster9.com/C9ResourceStreamer/doc/api/index.html
Framework Demoapplication sourcecode and javadoc documentation (Mac OS X ProjectBuilder projects, Devtools December 2002) download at:
http://www.cluster9.com/C9ResourceStreamer/c9rs.tgz (268 kBytes)
Please contact if you have any question.
Cheers, David
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden