Anyone using Cloudscape in production? Is it a viable platform or are IBM
just dreaming?

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

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

On Fri, 21 Apr 2006 18:50:36 +0800, "news.ozemail.com.au"
<pfinnegan@ozemail.com.au> wrote, quoted or indirectly quoted someone
who said :

>Anyone using Cloudscape in production? Is it a viable platform or are IBM
>just dreaming?

It is also available as the open source Derby. That is probably the
more popular version.

see http://mindprod.com/jgloss/sqlvendors.html
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Roedy Green <my_email_is_posted_on_my_website@munged.invalid > wrote:

>On Fri, 21 Apr 2006 18:50:36 +0800, "news.ozemail.com.au"
><pfinnegan@ozemail.com.au> wrote, quoted or indirectly quoted someone
>who said :
>
>>Anyone using Cloudscape in production? Is it a viable platform or are IBM
>>just dreaming?
>
>It is also available as the open source Derby. That is probably the
>more popular version.
>
>see http://mindprod.com/jgloss/sqlvendors.html
Small update to your list. Cloudscape is now free and, as far as I can
tell, differs from Derby only in that the manuals have the IBM logo on
the cover and you can buy support for it from IBM. Sun have renamed it
Java DB and also offer paid support.

"Roedy Green" <my_email_is_posted_on_my_website@munged.invalid > wrote in
message news:v4di4299l3umed0juiae63ls7bednsal4a@4ax.com...
> On Fri, 21 Apr 2006 18:50:36 +0800, "news.ozemail.com.au"
> <pfinnegan@ozemail.com.au> wrote, quoted or indirectly quoted someone
> who said :
>
> >Anyone using Cloudscape in production? Is it a viable platform or are
IBM
> >just dreaming?
>
> It is also available as the open source Derby. That is probably the
> more popular version.

Indeed.

During a Java course, several years ago, we have used Cloudscape as a simple
to use, easy to setup database.

I can't vouch for a production environment, but after what I've seen from
Cloudscape then, I'd say it's a pretty good database. Easy to use, it does
the job it's supposed to do etc... For small projects, it would be more than
adequate.

Just as long as you don't expect the speed or amount of handled data an
Oracle database (for example) would give you, you'll do fine.

Best regards,

JC
--
http://jcsnippets.atspace.com/
a collection of source code, tips and tricks

> I can't vouch for a production environment, but after what I've seen from
> Cloudscape then, I'd say it's a pretty good database. Easy to use, it does
> the job it's supposed to do etc... For small projects, it would be more
> than
> adequate.
> JC

The Cloudscape database is used to power SonicMQ in a production
environment.
http://www.sonicsoftware.com/products/sonicmq/index.ssp


AMO