It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Lightweight Database Recommendation Anyone? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Lightweight Database Recommendation Anyone?" Watch "Lightweight Database Recommendation Anyone?" New topic

Lightweight Database Recommendation Anyone?

Steve Wood
Ranch Hand

Joined: Jan 08, 2003
Posts: 137
Does anyone have a recommendation for a light-weight database. I don't really need the full-on features of SQL Server and as I'm building a desktop application, I don't want the weight either. Is there something like MS Access that I should know about. I don't need the coding features in Access, just the tables.
As I come from a Microsoft background, I was just wondering if there is a good alternative.
Any advice would be great.
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
hsqldb is probably an excellent fit for your needs. You can use it either as a server or as an embedded database within your application. Open source, has been around for quite a while, and as a database it's certainly no enterprise RDBMS but you may well find it to perform heaps better than Access. The license is quite nice and certainly won't be an impediment to commercial use.
- Peter
[ February 08, 2003: Message edited by: Peter den Haan ]
John Dunn
Ranch Hand

Joined: Jan 30, 2003
Posts: 1108
You may also want to check out MySQL and InstantDB. MySQL is probably a bit medium sized, but popular enough to have books in Barnes and Noble.
I used InstantDB - now SimpleDB - to convert a db system from Access to SQLServer. InstantDB could read in text and also allow for SQL functionality. It was easier to update then SQLServer so it turned out to be a perfect stepping stone.
If it isn't free, it may be cheap and worth a look. You'll have to do the research though, as my knowledge of it is out-of-date.
I'd use MySQL, if only b/c the user-base is so large.

"No one appreciates the very special genius of your conversation as the dog does."
Steve Wood
Ranch Hand

Joined: Jan 08, 2003
Posts: 137
Thanks a lot. I'll have a look at your recommendations.
All the best,
I agree. Here's the link:
subject: Lightweight Database Recommendation Anyone?
It's not a secret anymore!