derby embedded for small sites viable?

[MB <di...@gmail.com>]

Could Apache Derby 10.5.x in the embedded form be an interesting viable
alternative to, for example MySQL / PostgreSQL and similar?

The requirements are about 100 concurrent users, content being text,
images, a *smaller amount* of audio files and later possibly video
files, 4 areas with 1-10 articles in each and an administrative
interface requiring login. Surely Derby 10.5.x or later could perform
such a small site well in Tomcat 5.5.x or similar?  

All this probably running in a virtual unix server somewhere. 

What are your experiences with embedded derby after publication?

Can Derby sustain Blobs well or would I better off just using the file
system? I need to personalize some of the given URL's to files in blob-
form per user, but I guess that could be done no matter what is used.


/MB

Re: derby embedded for small sites viable?

[Rick Hillegas <Ri...@Sun.COM>]

Hello,

This sounds like an application which is well within Derby's 
capabilities. Hopefully you'll get more concrete advice from someone who 
has written a similar application.

Regards,
-Rick

MB wrote:
> Could Apache Derby 10.5.x in the embedded form be an interesting viable
> alternative to, for example MySQL / PostgreSQL and similar?
>
> The requirements are about 100 concurrent users, content being text,
> images, a *smaller amount* of audio files and later possibly video
> files, 4 areas with 1-10 articles in each and an administrative
> interface requiring login. Surely Derby 10.5.x or later could perform
> such a small site well in Tomcat 5.5.x or similar?  
>
> All this probably running in a virtual unix server somewhere. 
>
> What are your experiences with embedded derby after publication?
>
> Can Derby sustain Blobs well or would I better off just using the file
> system? I need to personalize some of the given URL's to files in blob-
> form per user, but I guess that could be done no matter what is used.
>
>
> /MB
>
>
>