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
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 ]
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."
Joined: Jan 08, 2003
Thanks a lot. I'll have a look at your recommendations. All the best, Steve