Jump to content
  • Advertisement
Sign in to follow this  
tebriel

[java] "Lightweight" Free Java Database

This topic is 4966 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Anyone know of any alternatives from MySQL for use on a Windoze system? There's something called "Mini SQL" but it doesn't really support JDBC. (There is supposedly a JDBC driver for it but I have yet to discover where it is if it still exists.) Even if there is I'm not sure "free hobby use" is really covered in the license anyway. If possible I'd like something that's easily (and freely) distributable that isn't going to take a DBA (exaggerating) to install to other systems (think: very simple install). Is MySQL really the closest thing to a VERY basic functionality database out there? (Only for doing selects, inserts, deletes, and not much else...)

Share this post


Link to post
Share on other sites
Advertisement
There are quite a few of these some are reasonably fully-featured. All have less configuration effort than using a separate server process (like MySQL etc), and may have lower overhead for queries (although of course, they may be less well optimised for large databases or complex queries).

The ones I know about are

Hypersonic (may be closed-source / restricted now) - there is an open source fork of it (it was fairly complete before this fork was made)

Cloudscape / Derby - originally closed-source owned by IBM, they've now open-sourced it as "Derby" or something.

Daffodil - another one

Mark

Share this post


Link to post
Share on other sites
Thanks, I'll check those out.

I've kept looking and managed to find this possible goldmine:

http://cbbrowne.com/info/rdbmssql.html

Not sure how many of these will work easily with Java but it's a long enough list!

Share this post


Link to post
Share on other sites
I like hsqldb.

Quote:

HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements. It offers a small (less than 100k in one version), fast database engine which offers both in-memory and disk-based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets) and a number of demonstration examples.

Share this post


Link to post
Share on other sites
Guest Anonymous Poster
Yeah, if you want a lightweight and easy-to-abuse database, you can't go far wrong with HSQLDB. Really small, easy to understand, simple deployment of data files. It might not have all the power of MySQL, Oracle, Sybase etc, but it'll do everything most people want.

--cfmdobbie

Share this post


Link to post
Share on other sites
Haha, I just came here to say that I decided to use hsqldb (sourceforge project).

It's definitely what I was looking for!!!

(I think this is the open-source version of Hypersonic mentioned above by the way--that's how I found it.)

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!