simple, lightweight database for Java?

[bobajobrob]

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

 

[Thomas Kellerer]

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

 

[David Segall]

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.

 

[bobajobrob]

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.

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