Thursday Jan 24, 2008

The Three Database Musketeers: MySQL, PostgreSQL and Java DB

As you probably have heard already, Sun Microsystems has announced an agreement to acquire MySQL.

I have had several people asking me about my view on it and I thought I would offer it here, along with an analogy.

First of all, being part of the Database Technology Group at Sun, I'm very happy that Sun has entered into an agreement to acquire MySQL, the #1 open source relational database system.

Sun is one of the biggest open source contributors and it only made sense that eventually Sun would acquire MySQL to offer its users base various alternatives for their database needs.

Sun will now support 3 major database open source initiatives as MySQL, PostgreSQL and Apache Derby (Java DB).

As Jonathan Schwartz mentions it here in his blog, "This transaction increases our investment in open source, and in open source databases. And increases our commitment to Postgres - and the database industry broadly. The same goes for our work with Apache Derby, and our Java DB."

As far as the analogy with The Three Musketeers, I see these three databases as the database musketeers which are going to be working together, with each of them having very particular and unique capabilities that will satisfy various needs in the entreprise, such as embeddable Java store, data wharehousing, OLTP, Web 2.0, etc. Now I will let you guess who plays the role of D'Artagan and no, don't even go there with Richelieu ;-)

In reality, databases are not one size fits all and it is good to have choices and alternatives for the various applications' requirements out there. So the database musketeers's motto here won't be "One for all, all for one", but rather  "No one size fits all", otherwise one could end-up with something like this (joke aside).

Anyhow, here at Sun we're very excited in having MySQL being part of the adventure.

Tuesday Mar 06, 2007

Migrating Your Application to Use Java DB

In this article, a web application that was developed using the Pointbase database is migrated to use Java DB. The web application was originally developed in the NetBeans 4.1 integrated development environment (IDE).

Java DB is Sun Microsystem's supported distribution of the Apache Derby 100% Java database. IF you are using JDK 6, Java DB is included as part of this last one. You can also download the Sun Java System Application Server, which includes Java DB.

When registering the application server in NetBeans 5.5, Java DB will be automatically registered as well. Alternatively, you can download the Java EE 5 Tools Bundle, which includes both the NetBeans IDE and Sun Java System Application Server.. Java DB is fully transactional, secure, and compliant with the JDBC, SQL, and J2EE standards.

Wednesday Feb 14, 2007

Connecting a GUI to a Java DB Database with NetBeans IDE

This NetBeans tutorial contributed by Talley Mulligan guides you through the process of connecting the GUI of an application to a Java DB database. It shows how to add data-aware JDBC components to the GUI that will enable the program to interact with the database.

If you have not seen it already, there is also a "Working with the Java DB (Derby) Database in Netbeans 5.5" tutorial contributed by Brian Leonard.

Wednesday Feb 07, 2007

ActiveMQ graduates from Apache Incubator and uses Apache Derby

Apache ActiveMQ Open Source Message Broker has now graduated to become a top level project (TLP) at Apache! Congratulations to the ActiveMQ community!

To achieve high performance of durable messaging, ActiveMQ embeds and uses Apache Derby (configured by default), to allow for some very fast persistence via JDBC, coupled along with ActiveMQ's high performance journal.

Tuesday Jan 16, 2007

Java TV

Intriguing blog entry title eh? Well, no it's not a new product from Sun Microsystems, neither some TV that can run or deliver some Java...

It a is repository of video interviews around Java posted by, one of the biggest Java developers community in France.

Please note that a lot of the videos are in french but not all of them.

Most recently posted video interviews are of Marc Fleury (JBoss), Vincent Massol (XWiki) and myself (Java DB).




« February 2017