my dog learned polymorphism*
The moose likes JDBC and the fly likes Lightweight Database Recommendation Anyone? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Lightweight Database Recommendation Anyone?" Watch "Lightweight Database Recommendation Anyone?" New topic
Author

Lightweight Database Recommendation Anyone?

Steve Wood
Ranch Hand

Joined: Jan 08, 2003
Posts: 137
Hi,
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.
Thanks,
Steve
Peter den Haan
author
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
slicker
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.
http://www.mysql.com/
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.
http://www.simpledb.org/
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,
Steve
 
Consider Paul's rocket mass heater.
 
subject: Lightweight Database Recommendation Anyone?
 
Similar Threads
new to database question
Bench Press
Data Structure for display in JTree?
Data Structure for displays in JTree?
how can java connect to Access?