Light-weight SQL server for Linux/Windows?

Question

Hello

SQLite is fine as a single-access database, but it gets risky when used by more than one user at a time. MySQL, Firebird, PostgreSQL etc. are more difficult to deploy and are simply overkill for my use.

Ideally, I'd like a compact, single-EXE server meant to run on low-spec hardware (eg. 128MB RAM, 256MB flash RAM) that would be as easy to work with as SQLite, and is available for Linux (and Windows, so I can use the same code client-side in case customers prefer a regular PC.)

Do you know of an application that fits those requirements?

Thank you.

Answer 1

You might try looking at Apache Derby (http://db.apache.org/derby/). It's Java, so it'll be portable and it's definitely lightweight.

Answer 2

Give Firebid a try. It's crossplatform, lightweight and databses consists of single file.

Answer 3

Thanks guys. I find the Firebird documentation a bit daunting for a newbie, and Java is too heavy for my use.

Too bad no one came up with a SQLite server that can just be dropped on a host and launched at boot time.