Cloudscape Gains Momentum 139
A reader writes: "There's been a lot of bits written recently about the growth of Open Source databases; as well as IBM's patent gift, as their release of the Java database Cloudscape. There's a contest running on SourceForge.net around Cloudscape; download and run with it." SF.net is part of OSTG, like Slashdot.
Java database ? (Score:5, Funny)
wouldn't it be quicker to print your data on paper and sort it by hand ?
Java zealot's response (Score:1, Funny)
Java is now no longer a technology to add bullshit to webbrowsers.
It is a mature (so says Sun), fast (so says Sun) and memory-conservative (so says Sun) platform which is platform-independent (so says Sun).
It is used in major companies and organizations for mission-critical and user-centric applications which leverage the power of the human resources and empower an increasi in return-on-investment.
Do you want to imply that the CEOs and CTOs of most major companies are *g
Re:Java zealot's response (Score:3, Informative)
Java *is* a mature language celebrating its 10th year in 2005. J2EE, as the sum of its collective parts (EJB, Servlets, JSP, RMI) has been around for 7 years. By industry standards, these are "old-timers".
Java is memory "conservative" (on a server), requiring far less RAM than the
Re:Java database ? (Score:5, Informative)
Hey, I like Java as much as anyone, but if you're looking for a fast, multi-platform, zero-administration database be sure to check out SQL Anywhere Studio [ianywhere.com]. The Developer Edition is completely free and runs on Linux, Solaris, Mac OS X, Netware and most flavors of Windows, including CE/PocketPC. See the description of what's in SQL Anywhere Studio [ianywhere.com] for details. (Note that some of you may remember SQL Anywhere as Watcom SQL.)
EricListen, folks: JavaScript is NOT Java! [ericgiguere.com]
But that is not embeddable (Score:5, Insightful)
Embedding a database in an application can be very useful, such as in a desktop GUI where you cannot rely on network communication or maybe don't want to bother with a client/server environment.
I'd certainly consider Java/Cloudscape for a desktop db-backed application over anything built in Access.
As always, fit the tool to the job, not the job to the tool.
Re:But that is not embeddable (Score:3, Informative)
I have found the ability to embed the database in the application exceptionally useful for a recent J2EE deployment we worked on.
I liked the idea of just being able to plop the org.apache.derby.jdbc.EmbeddedXADataSource class into my connection pool and have a database. I like that I can tell the suits that the database is built by IBM and that's all I hear about it. And I like that once this venture grows and starts to make more money I can switch fairly seemlessly to DB2.
It probably should not be cons
Re:But that is not embeddable (Score:2)
People mean different things when they say "embedded". Do you mean "embedded" as in actually part of the application, or do you mean "embedded" as in the database is a server process on the same device (no networking involved)? It wasn't clear from the post.
There are in fact two database technologies in SQL Anywhere Studio. First there is Adaptive Server Anywhere [ianywhere.com], the full-featured relational database that runs on all the platforms mentioned. Second is UltraLite [ianywhere.com], a small-footprint database for Palm OS and
Re:But that is not embeddable (Score:1)
Re:But that is not embeddable (Score:2, Interesting)
I completely disagree. I think most people think that SQL Anywhere is just used for client/server communication when in fact you can also easily use it for standalone use in embedded applications. In fact, I would argue that SQL Anywhere is far easier to embed than Cloudscape since you only need to deal with 2
Re:But that is not embeddable (Score:2)
Never again will I write an Access Forms application. I'd rather write it in a
Re:Java database ? (Score:1)
Re:Java database ? (Score:2)
To be proper, it's not javascript or Javascript, it's JavaScript [netscape.com]. Although really if everyone referred to it as ECMAScript [ecma-international.org] there would be less confusion.
EricRe:Java database ? (Score:2)
Re:Java database ? (Score:1, Informative)
They normally recomend DB2 for production but one of the latest products "Workplace Services Express" can only be used with the embedded Cloudscape.
The product is intended for SMB and scales upto 1000 users. And this is for Groupware/Document storage etc. http://www.lotus.com/products/product5.nsf/wdocs/w orkplaceservicesexpresshome/ [lotus.com]
It is fast (Score:2, Interesting)
Eh.. (Score:2, Insightful)
marketing?
Re:Eh.. (Score:2, Informative)
Well OK maybe not, but this is a fluff piece at best, self advertising at worst. Plus the prize is US only so it cuts out a lot if interest right away.
Nothing to see here, move along.
Re:Eh.. (Score:2)
"Test your skills with Java and Win an IPod - Take the Challenge for Java"
"Download the Newest Open Source Database. Easy to Learn and Use. Fast Download. Do It Now!" I hope Slashdot continues to post articles about their paid sponsors.
Wrong language, wrong thing. (Score:3, Insightful)
Isn't that a little bit like writing a Fast Fourier Transform [wolfram.com] in LISP?
There are lots of things that Java is perfectly suited for. Databases are not one of those things.
Re:Wrong language, wrong thing. (Score:5, Insightful)
Re:Wrong language, wrong thing. (Score:2)
On the backend, I'm a PostgreSQL/MSSQL guy.
Java IS NOT slow (Score:1)
Java IS NOT slow
If anything, the interface gives it a feeling of slow.
Re:Java IS slow (Score:2, Interesting)
The JVM initialisation time is waaay longer than the C runtime initialisation time on every platform I've tested, which makes short-running processes feel awful in Java.
Finally, whenever it becomes necessary to actually _do_ anything, the JNI must be crossed, and that's slow.
Phil
Re:Java IS slow (Score:1)
I can't take anyone seriously when they say the above.
The JNI is not slow...
Yes, it is. (Score:1)
To send a network packet in C: construct it in your program; call write(), which is a system call.
To send a network packet in Java: construct it in your program; call YadaYada.write(), which copies it across the JNI to a C module; C module calls write() which is a system call.
No matter how fast the JNI is, CROSSING IT WILL ALWAYS BE SLOWER THAN NOT CROSSING IT.
This is not a difficult concept. The JNI tax applies whenever you need to do anything which must be accomplished with a
Re:Yes, it is. (Score:4, Interesting)
JNI itself is a generic abstraction layer to the underlying operating system. It provides a mechanism whereby dynamic libraries not directly supported by the runtime engine can still be accessed by a Java application.
Threading, sockets and GUI are implemented via the native system libraries. AWT used to be very slow (as opposed to just being merely slow today) due to its own multi-layed abstraction. But at no time was JNI the conduit for these systems.
Further reading: http://java.sun.com/docs/books/tutorial/native1.1
Re:Wrong language, wrong thing. (Score:4, Insightful)
Re:Wrong language, wrong thing. (Score:2, Insightful)
Funny, I remember the 'it's too slow' argument being used against C++ 20 years ago.
Re:Wrong language, wrong thing. (Score:2)
Re:Wrong language, wrong thing. (Score:5, Informative)
I'm a Java developer, and have been almost from the very start of Java. While I tend to agree with you at first, I would like to point out some benefits of using Cloudscape.
Over the years I've had a few (small, hobby) projects, where I really felt the need for a database which did not need to be fast nor did it need to be huge. So I tried Cloudscape. And while it isn't the fastest around, it gets the job done.
The easiest part is that you can just bundle it with your application, without writing a single line of code!
I've tried MySQL, but I still need to install it prior to being able to run my application - no need for that with Cloudscape.
But, granted, it is not the fastest out there. If I need a *real* database, I just use Oracle.
2 points you are wrong on. (Score:3, Informative)
Now write a program in Java. Guess what, Java is not an interpretted language. It doesn't use some fluffy brightly coloured play-doh type bits, it uses regular ones, like cpp binaries.
Java compiled the byte code into executable form. Then it does some on the fly optimisation.
Java VM's can out-perform cpp over n cycles, where n is sufficient to overcome Java start times (seconds)
Secondly, FFT or a DCT in Java or cpp, I haven't seen benchmarks, but there are
Re:2 points you are wrong on. (Score:5, Funny)
Yes, and a well-supplied tortoise can out-distance a rocket over n years, where n is much longer than the rocket's burn time
Re:2 points you are wrong on. (Score:1)
Re:2 points you are wrong on. (Score:2)
Re:2 points you are wrong on. (Score:1)
Well done for showing your reading level (Score:2)
I will give you the meat of it:
[Java] doesn't use some fluffy brightly coloured play-doh type bits, it uses regular ones, like cpp binaries.
Not:
Unlike cpp binaries, which use bright fluffy ones and zeros, Java uses regular binary
Re:2 points you are wrong on. (Score:1)
I have about 27,000 sales reps that would disagree with you on that.
Re:2 points you are wrong on. (Score:2)
I have about 27,000 sales reps that would disagree with you on that.
I love it when they make your point for you
Re:2 points you are wrong on. (Score:2)
Re:Wrong language, wrong thing. (Score:2)
Slashdotters love broad, generalized statements. (oops) ;-)
I disagree with you completely. For example, simple embedded databases (see HSQLDB [sourceforge.net]) can be very useful. I know someone who's teaching an class with Java and wanted to touch on databases. A java-based database (in this case, HSQLDB can run in-process) is great for this. You don't have to install a huge server on your development system just to l
Re:Wrong language, wrong thing. (Score:3, Informative)
While Java and Python are the languages that I most frequently use, CL is a powerful tool - try it!
(*) with compiler type directives
Re:Wrong language, wrong thing. (Score:2, Informative)
Re:Wrong language, wrong thing. (Score:2, Informative)
http://home.comcast.net/~bc19191/blog/040308.html
RTFA please, both submitters and moderators (Score:2)
From the article:
Re:Wrong language, wrong thing. (Score:2)
Actually I think it is something Java has needed. Think of it as sort of MS Access for Java. There are lots of applictions where a small embedded data engine would be usefull. Sure you could do it in flat files, but why? A data engine just makes the development that much simpler and faster.
IF...... (Score:1)
Re:IF...... (Score:2, Interesting)
You can win an Ipod or TShirt only if you are US or Canada resident....are they trying to encorage inmigration? The rest of the world should not bother about using Cloudscape I assume...
Let's see, most people would need at least an hour to write a JDBC application to search the tables for some silly magic word. Most eligible contestants from the US and Canada who have the knowledge to write such an application make more than enough in one hour to buy an iPod and a T-shirt. So why should anyone even bothe
Re:IF...... (Score:2)
I'm lucky to see less than half that.
As usual (Score:3, Interesting)
I'm from Quebec ... and as usual, contents makers will not take the trouble of being compatible with Loto-Québec's rules. They are easy to follow, strangely... not a lot of stuff to fill in. It mainly is there to make sure we don't get screwed up
... and it also means everyone in the other countries will not be able to participate. Yeehaa
Re:As usual (Score:2)
Re:As usual (Score:1, Funny)
Re:As usual (Score:2)
with all this locator jumbo bungo you'd expect that they'd demand that they don't waste their adviews on indians.
Re:As usual (Score:2)
put simply, if they're citizens of united states of america or canada then they're not indian citizens.
What's in a name? (Score:4, Interesting)
Apache at the ASF (Score:4, Informative)
Beeing in the incubator does not yet mean it is a full blown ASF project - but that the ASF is in the process of ensuring that there is a healthy community around it, that all the legal paperwork, trademakrs, grants, copyrights and other interlectual rights are sorted out, that commiter license agreements are on file for each developer, etc, etc..
Once that is all in place (and getting a healthy long term community is hardest - the rest is just endless grunt work and digging through code and legal paperwork dotting i's and crossing t's) it'll leave the incubator and be a full blown process.
Feel invited to join and make this happen ;-)
Dw.
Spelling mistake in submission (Score:4, Funny)
Re:Spelling mistake in submission (Score:2)
Re:Spelling mistake in submission (Score:2, Funny)
Re:Spelling mistake in submission (Score:2)
Re:Spelling mistake in submission (Score:2)
Let's call the whole thing off...
I've written a review of this (Score:5, Informative)
As it happens I've already written a review of cloudscape; the google cache of it is here [google.com].
Brief summary: get the Apache version [apache.org]; reasonably full SQL92 syntax; performance OK; a bit lacking on security.
Re:I've written a review of this (Score:2, Interesting)
Actually, I think the biggest limitation [apache.org] is the 18 character names for constraints (et. al).
Re:I've written a review of this (Score:2, Funny)
Here is a swell idea! (Score:4, Interesting)
But seriously -- this is getting out of hand. If every single company, individual, etc. starts an open source project what does that accomplish? Nothing. It brings about 100 different alternatives to the market most of which would never be viable in a commercial environment.
News flash: devote time and effort to succesful projects that extend the reach of the open source community. Another open source database project is just well... another project.
Re:Here is a swell idea! (Score:2, Insightful)
C++ Databases and Open Source (Score:3, Informative)
Re:C++ Databases and Open Source (Score:1, Informative)
Code footprints:
Re:C++ Databases and Open Source (Score:2)
im wrong, aren't i???
Re:C++ Databases and Open Source (Score:1)
Re:C++ Databases and Open Source (Score:2)
Re:C++ Databases and Open Source (Score:3, Informative)
Re:C++ Databases and Open Source (Score:4, Informative)
Re:C++ Databases and Open Source (Score:2)
And, for the non-Java crowd here, PHP5 has SQLite bundled with it.
It seems that this can revolutionize how ISPs do hosting in the future, since its setup is much easier and low overhead.
We may see proliferation of applications running on SQLite in the future.
Re:C++ Databases and Open Source (Score:1)
Re:C++ Databases and Open Source (Score:1)
After research last weekend I decided on BDB as well, but am also going to download Apache Derby version of Cloudscape as well if I want to use triggers and stored procedures for an app.
rd
Re:C++ Databases and Open Source (Score:2)
Re:C++ Databases and Open Source (Score:1)
I did see SQLite in a list of open source databases, I believe. I am a longtime AS/400 RPG programmer and my focus was on record level access, not SQL.
BDB has the base architecture for what I want, and Derby being from IBM is worth taking a look at to modify to put in DB2/400 type record level access as well.
I have written business apps in SQL by accessing result sets with a cursor, but s
Re:C++ Databases and Open Source (Score:2)
Purpose (Score:3, Informative)
Re:Purpose (Score:2)
Not a difficult challenge (Score:1)
I thought it would be a great test of my increasing Java skills and maybe I'd learn more about transactions, stored procedures, etc.
Well, an hour later I'd got Cloudscape working, I'd unlocked the Magic Word and I was looking it up in the dictionary thinking "is it really a real word?"
If you can do SELECTs, it's quite a trivial 'challenge' I'm afraid.
Re:Not a difficult challenge (Score:1)
Re:Not a difficult challenge (Score:2)
If you step back and think about it for a minute, the goal here is to generate buzz, get developers to download the product and try it out, and have a small amount of "success" with it. Now all of a sudden, Cloudscape is on the radar of a large number of developers, and is more likely to be considered for use in upcoming projects.
Arrrrghh! (Score:3, Funny)
So how does it compare to the alternatives? (Score:2, Interesting)
Anyone find a decent article comparing the three yet?
The iPod prize pattern (Score:2)
That says something about Apple and iPod brand, no? That is also a great marketing for Apple and its iPod product! Jobs must be rubbing his hands...
Read the License (Score:1, Interesting)
I should note that I stopped there. I will unlikely ever download and use the product, regardless of usefullness.
IPod and IBM (Score:1)
This would have been a much better promotion if IBM had given away a free license for DB2 or something. Think about it, all the companies that want a license for DB2 check out cloudscape and see what it is all about because they want a license for DB2.
The License (Score:1)
Robocode (Score:2)
And still get wiped out..
My 0.02 USD (Score:1)
An embedded database is quite useful. Imagine the following scenario.
You're writing an application; say something that you want to sell or distribute on the net. Now, let's say you're program uses a heft amount of data and needs to perform complex searches against it. I'm not talking about free-text, but for columns whose values are between certain ranges or that follow a formula. Also, image that said information is relatively static.
Now, you could force all of your cu
Cloudscape is great for automated unit testing (Score:2, Informative)
Now, instead of needing to have a container up, or have a database running or similar, I can embed cloudscape (which is quite small, really), set up a group of in-memory tables with the state I need, execute a unit, then check the tables for correctness and destroy the database.
Shazam, database unit tests - no external dependencies.
A lot of people are mum
How does this compare to Hsqldb? (Score:2)
One nice thing is that you can download a version of Nukes that includes JBoss, Nukes, and even an embeded DB - Hsqldb. You can also use it with MySQL and Postgres if you like.
So does anyone know how Hsqldb compares with Cloudscape?
Downloading Nukes with an embedded DB is really nice to be able to play around with the system right away without any configuration work and is a good example of why an embedded
Object-Oriented Alternatives (Score:1)
Why would I handicap myself like that, when I don't need ad-hoc reporting and when no other system is going to share my data?
Why wouldn't I just use native Java objects?
See you, Klaus.
http://www.db4o.com/ [db4o.com] - The Leading Open Source Object Database
http://www.prevayler.org/ [prevayler.org] - Do You Still Use a Database?
Re:Object-Oriented Alternatives (Score:2)
Another option: db4objects (Score:1)
The runtime is a JAR that's about 300KB in size, with about a 1 meg memory footprint.
Companies like BMW and Bosch have chosen it to drive their automobiles and robots respectively.
The best way to get a feel for db4objects is to look at how simple the code is you get to write. For example:
To store a Pilot object:
It's not GPL, so I can't use it in my software. (Score:2)
So I'm going with McKoi.
Re:It's not GPL, so I can't use it in my software. (Score:1)
Re:It's not GPL, so I can't use it in my software. (Score:2)
cloud linings (Score:2)
Fondly I recall those halcyon days of tar, configure and make. Oh, what the heck, throw in a make check to see if all is well in the world, and to demonstrate just how to use the software (e.g. what environment variables to set).
But those days are gone. In this brave new java world [as IBM sees through its clouds] we're presented with a weird amalgum of GUI and CLI.