Embedded SQL Databases? 19
kumquat asks: "We are creating a desktop version of a java web application that currently uses MySQL. What small footprint SQL databases would you recommend embedding into applications? I'm looking for: zero maintenance, small footprint, runs in multiple platforms (Windows, Unix, Linux). Low cost or free would be a bonus. Freshmeat turned up a couple of possibilities: hysqldb and Mckoi SQL."
Interbase (Score:4, Informative)
Another possibility (Score:3, Informative)
InstantDB which is small, embedable, and Java. It's cheap, but not free. It used to be Free, and if you look around, you can find copies of the Free version around still (I'm not sure if they're maintained anymore). In reality, though, I'm not sure why you wouldn't go with hsql, which is just as good, just as embedable, and Freer. Is there something wrong with hsql that is making you look elsewhere?
Sybase SQL Anywhere (Score:3, Informative)
Also not free, but it does Windows, Windows CE, Linux, and they have an "Ultralight" version for embedding.
Re:Sybase SQL Anywhere (Score:2, Informative)
This product has worked well on our projects, and Sybase has been good about delivering bug fixes on all platforms.
Cloudscape sounds perfect (Score:4, Informative)
It is not free, but it's not outrageously expensive either. I believe that it costs in the low hundreds of dollars.
Virtual tables? (Score:2)
Re:Cloudscape sounds perfect (Score:3, Interesting)
Maybe instead of an SQL database, a slightly more low-level, Berkeley DB library type solution might work for you.
bdb! (Score:2, Interesting)
JDataStore (Score:3, Informative)
look here [borland.com]
Good luck!
tinySQL - open source, 100% Java (Score:3, Informative)
Enjoy,
Brian
SQLite (Score:2, Informative)
Re:SQLite (Score:1)
no complaints so far with hsqldb (Score:1)
java SQL JDBC/ODBC bridge. (Score:1)
and it doesnt have any size either since its part of the jdk.
Try Mimer SQL (Score:2)
http://developer.mimer.com [mimer.com]
runs on Windows, Unix, Linux and VMS
Client/server. Multiuser.
Supports Embedded SQL, ODBC and JDBC
Advanced optimistic transaction control
High level of SQL standard conformance
Stored procedures
/per@mimer.se
For any questions, feel free to ask me