Slashdot Mirror

← Back to Stories (view on slashdot.org)

Embedded SQL Databases?

Posted by Cliff on from the small-fast-and-reliable dept.

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."

8 of 19 comments (clear)

  1. Interbase by fm6 · · Score: 4, Informative

    I don't know much about embedded DBs. I do know that Borland (for whom I work) sells Interbase, mainly as an embedded database. I have it running on my Linux box, and its footprint and maintenance needs are both quite small. It's a full-featured multi-threaded relational DB. Open Source, of course!

  2. Another possibility by elefantstn · · Score: 3, Informative

    Enhydra makes a database called
    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?

    --
    If it ain't broke, you need more software.
  3. Sybase SQL Anywhere by platos_beard · · Score: 3, Informative

    ...or whatever the hell they're calling it now.
    Also not free, but it does Windows, Windows CE, Linux, and they have an "Ultralight" version for embedding.

    --
    What's a sig?
    1. Re:Sybase SQL Anywhere by JWanderer · · Score: 2, Informative


      This product has worked well on our projects, and Sybase has been good about delivering bug fixes on all platforms.

  4. Cloudscape sounds perfect by wmshub · · Score: 4, Informative
    Your description of needs is almost word-for-word how Informix (now IBM) describes Cloudscape. A quote from the cloudscape info page:
    Cloudscape is a full-function database that requires zero administration, is scalable and secure. These features allow Cloudscape to deliver a lower total cost of ownership to customers who want to anonymously embed databases into their Java-based applications.

    It is not free, but it's not outrageously expensive either. I believe that it costs in the low hundreds of dollars.

  5. JDataStore by billr · · Score: 3, Informative

    Take a look at JDataStore from Borland. They claim it's inexpensive, and it's designed for exactly what you want.

    look here

    Good luck!

    --
    I've finally found the off by one erro
  6. tinySQL - open source, 100% Java by bjepson · · Score: 3, Informative

    Have a look at tinySQL - it's open source (LGPL), and 100% Java. It is an extensible SQL engine that has a JDBC driver. It started out life as a quick hack, but it's improved significantly thanks to the contributions of others. The most recent version is usually available in CVS, but there is a fairly recent tarball and jar file up there.

    Enjoy,

    Brian

  7. SQLite by tawaste · · Score: 2, Informative

    If you just need SQL for one app, take look at SQLite. It's not client-server db, but SQL provided on top of gdbm files.