CODEWITHSUNDEEP
linuxdatabasewindowssqlite
Gulbahar
Gulbahar

Reputation: 5537

Light-weight SQL server for Linux/Windows?

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?

Upvotes: 6

Views: 27591

Answers (4)

Anupam Maiti
Anupam Maiti

Reputation: 1610

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

Upvotes: 2

Alex
Alex

Reputation: 1008

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

Upvotes: 0

curious slab
curious slab

Reputation: 1160

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

Upvotes: 6

Stefan Mai
Stefan Mai

Reputation: 23939

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.

Upvotes: 1

Related Questions