Light-weight SQL server for Linux/Windows?

Question

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?

Answer 1

Another option is HSQLDB. It's light, fully Java and multithread. I used in personal projects with very good results.

Answer 2

Try H2,Its a Java based SQL database engine.....

• Very fast, open source, JDBC API
• Embedded and server modes; in-memory databases
• Browser based Console application
• Small footprint: around 1.5 MB jar file size

Answer 3

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 4

Give Firebird a try. It's cross platform and lightweight. Databases consist of single files.