Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Lightweight Database Recommendation Anyone?

 
Steve Wood
Ranch Hand
Posts: 137
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3252
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1108
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Steve Wood
Ranch Hand
Posts: 137
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot. I'll have a look at your recommendations.
All the best,
Steve
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic