Little more of what cloudscape is :
Cloudscape/Derby us used widely
http://wiki.apache.org/db-derby/UsesOfDerby
Find more about derby from
http://db.apache.org/derby/index.html
* Derby has a small footprint -- about 2 megabytes for the base
engine and embedded JDBC driver (include the jar file in your java
application..you have fully functional database engine running inside
your application which need zero admin tasks)
* Derby is based on the Java, JDBC, and SQL standards.
* Derby provides an embedded JDBC driver that lets you embed Derby
in any Java-based solution.
* Derby also supports the more familiar client/server mode with the
Derby Network Client JDBC driver and Derby Network Server.
* Derby is easy to install, deploy, and use.
I have heard Derby handles database sizes more than 50 GB in size with
out much problems.
Some comparison between Open Source datbase performance from
http://wiki.apache.org/apachecon/Us2...eSessionSlides
Derby outperforms MySQL on disk-based databases
----Derby has 100% higher throughput than MySQL
MySQL performs better on small main-memory
databases
----Update-intensive load: Derby has 20-50% lower
throughput
----Read-intensive load: Derby has 50% lower throughput
PostgreSQL performs best on read-only databases, and
has lowest throughput on update-intensive databases
Regards,
Kiran
Serge Rielau wrote:
news.ozemail.com.au wrote: Anyone using Cloudscape in production? Is it a viable platform or are IBM
just dreaming?
Derby/Cloudscape is embedded in various IBM products including Websphere
(I think WAS).
Viable begs the question "for what?" It's embedded Java. It does not
really compete with mySQL or postgres or any of the big commercial vendors.
Derby is one step up from e.g. Sybase anywhere (mobile device) and one
step down from e.g. DB2 Express C (full function, optimizer, multi user,
...).
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab