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

2 of 19 comments (clear)

  1. bdb! by sinator · · Score: 2, Interesting

    There's always Berkely DB: It's not particularly full featured, but it's fast, reasonably robust, portable, and can maintain referential integrity (technically, if you reduce your relations to BCNF, they're all binary relations anyway).

    --
    Three Step Plan:
    1. Take over the world.
    2. Get a lot of cookies.
    3. Eat the cookies.
  2. Re:Cloudscape sounds perfect by ameoba · · Score: 3, Interesting

    A friend of mine works for a company that started a project with Cloudscape, and from what he's told me, it's worse than working with flat text files. I can't remember the details of the project, but based on what he told me, cloudscape is -not- the place to look for your answers.

    Maybe instead of an SQL database, a slightly more low-level, Berkeley DB library type solution might work for you.

    --
    my sig's at the bottom of the page.