this is a good idea. which one is faster: returning the image as a stream or a direct link to a physical file in the file system?
Onno Scheffers-3 wrote: > >> >> Hi, >> your understanding is correct, photos are under protected folders. and >> the >> scaling will be a problem, but do you think it is good to store photo in >> the >> database's blob field? and every rendering requires copying from database >> to >> a temporary file? > > > > You can spool the data from a BLOB straight back to the client without > having to store it in a file first. You don't even need to fully load it > into memory. Im using Hibernate + PostgreSQL in my projects. Here's a > short > example of a StreamResponse that returns a binary stream from a Blob. > > public InputStream getStream() throws IOException { > [...] > Blob blob = // SOME_RECORD.getData(); > if(blob == null) { > [...] > } > try { > return blob.getBinaryStream(); > } catch (SQLException e) { > [...] > } > } > > Storing binary data in blobs makes a lot of things easier and we've never > had any problems with it so far. You can always setup a database > replication > scheme to increase the database performance if you have an awful lot of > visitors. > > regards, > > Onno > > -- View this message in context: http://www.nabble.com/t5%3A-protecting-data-from-public-access-tp23959208p23965764.html Sent from the Tapestry - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org For additional commands, e-mail: users-h...@tapestry.apache.org