CODEWITHSUNDEEP
javasqldatabase
rid
rid

Reputation: 63442

Small footprint embedded Java SQL database

I'm looking for an embedded SQL database for Java, with a small footprint. Something like SQLite, but it should be pure Java. So far I've seen HSQLDB, H2 and Apache Derby, but they're not what could be called small footprint. Ideally, the database I'm looking for would be embeddable in a J2ME application.

Is there something like this?

Upvotes: 6

Views: 6197

Answers (4)

Pablo Grisafi
Pablo Grisafi

Reputation: 5047

You may try http://www.jepstone.net/tinySQL/.

Pros:

  • It is small (93k!)
  • It is embeddable
  • It uses DBF or text files files to store data, so they are easy to read.

Cons:

  • It is an old unmaintained project
  • It is not designed to work in j2me, but since it can work in JDK 1.1.8 it won't be hard to make it work in j2me. Of course you will have to change some code from using RandomAccessFile to FileConnection and stuff like that, but at least you wont need to mess with generics related code.
  • It is not very fast, because it does not use indexes, so you need to try and see if it is fits yuor needs
  • It is not feature complete, just gives you a small subset of SQL

Upvotes: 2

mnicky
mnicky

Reputation: 1388

You can also look at:

This list is something I just found on the internet (http://www.coderanch.com/t/230853/JME/Mobile/List-Database-ME) and some of the listed products seems abandoned, but I thought that maybe it can be helpful...

Upvotes: 2

Omnaest
Omnaest

Reputation: 3096

Take a look at HSQLDB or H2DB

or possibly a light key value based database like jdbm2

Upvotes: 15

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181270

Yes, there is an Apache project for that called Apache Derby.

Upvotes: 4

Related Questions