• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Lightweight Database Recommendation Anyone?

 
Ranch Hand
Posts: 137
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
author
Posts: 3252
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
slicker
Posts: 1108
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot. I'll have a look at your recommendations.
All the best,
Steve
 
I've been selected to go to the moon! All thanks to this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic