simple, lightweight database for Java?

Thread view:

bobajobrob@gmail.com - 24 Sep 2006 18:30 GMT

I'm looking for a lightweight database for storing a large but not huge
quanities of indexed or keyed data. It must be able to create, retreive
update and delete records. I don't need a relational database or SQL,
just something simple and lightweight. The ability to defines columns
would be useful. GPL/other open source would be nice. Does anyone have
any suggestions or recommendations?

Rob

Reply to this Message

Thomas Kellerer - 24 Sep 2006 18:33 GMT

bobajobrob@gmail.com wrote on 24.09.2006 19:30:

> I'm looking for a lightweight database for storing a large but not huge
> quanities of indexed or keyed data. It must be able to create, retreive
> update and delete records. I don't need a relational database or SQL,
> just something simple and lightweight. The ability to defines columns
> would be useful. GPL/other open source would be nice. Does anyone have
> any suggestions or recommendations?

What is "lightweight" for you? In terms of usage, memory footprint, download
size, library size?

Is non-SQL a requirement? If not, have a look at Apache Derby
(http://db.apache.org/derby) or HSQLDB (http://www.hsqldb.org).

Thomas

Reply to this Message

David Segall - 24 Sep 2006 19:21 GMT

>I'm looking for a lightweight database for storing a large but not huge
>quanities of indexed or keyed data. It must be able to create, retreive
>update and delete records. I don't need a relational database or SQL,
>just something simple and lightweight. The ability to defines columns
>would be useful. GPL/other open source would be nice. Does anyone have
>any suggestions or recommendations?

If "lightweight" is the primary concern then you may want to choose a
file organisation that would not normally be described as a database.
Google for "random access" or "indexed sequential". However it is
unlikely that you will save much time, disk space or memory by not
using a database so I would suggest you choose one of those listed at
<http://database.profectus.com.au#Java>. It will provide all the
features you need now and may need in the future. It will also allow
you to use tools like Open Office Base
<http://www.openoffice.org/product/base.html> and iReport
<http://www.jasperforge.org/sf/projects/ireport> to view, print and
change your data and its underlying structure.

Reply to this Message

bobajobrob@gmail.com - 25 Sep 2006 11:29 GMT

> If "lightweight" is the primary concern then you may want to choose a
> file organisation that would not normally be described as a database.
[quoted text clipped - 7 lines]
> <http://www.jasperforge.org/sf/projects/ireport> to view, print and
> change your data and its underlying structure.

Thanks, I think Berkely DB will be suitable. Its transactions may be
useful. l I've also written my own "indexed sequential" data store that
I may expand.

Rob

Reply to this Message

simple, lightweight database for Java?

Free Magazines