Java DB in the JDK, and SQL in desktop applications

; Date: Tue Jul 18 2006

Tags: OpenJDK

There was a little "discussion" about the inclusion of Java DB into the JDK. I was on vacation and didn't read it too deeply.

At least a) it's only in the JDK, and it's the JRE download size that's more of an issue than is the JDK download size ... b) it's not in rt.jar but instead a separate directory in the JDK ...

What struck me, though, is the idea that a database is only suitable for server side applications. And that a database is only suitable for Java EE usage. Well...

Generally I think that's a very limited viewpoint. A database is a general data storage system, and it's suitable to a wide array of applications.

For example .. an email client (e.g. Columba) might want to include a full text search engine (e.g. Lucene). Lucene, for example, uses an SQL database to store its indexing. Hence, Columba, if it used Lucene, would need an SQL database. The general form of that use case is .. any application that deals with a large set of text files might well want to store full text indexing of those text files.

There's many other kinds of applications where a database might be a good idea. For example iPhoto doesn't necessarily require a database, but one could be useful. An MP3 player might store its association of playlists to songs using a database.

What triggered writing this posting is the announcement here: (web.archive.org) Meta Tracker is a powerful desktop-neutral first class object database, tag/metadata database, search tool and indexer.

Source: (web.archive.org) weblogs.java.net

About the Author(s)

(davidherron.com) David Herron : David Herron is a writer and software engineer focusing on the wise use of technology. He is especially interested in clean energy technologies like solar power, wind power, and electric cars. David worked for nearly 30 years in Silicon Valley on software ranging from electronic mail systems, to video streaming, to the Java programming language, and has published several books on Node.js programming and electric vehicles.