Peter Ondruska wrote:
you should have a look at Hibernate or Toplink or similar tool if you
want to _minimize_ SQL. however you will most probably come to a point
where you cannot avoid SQL.
Hey,
just to clarify my needs. I'm not trying to avoid using SQL/JDBC because
I have a problem with using it. I'm trying to avoid using it because
there is an unacceptable overhead involved with using it (for my purpose).
I'm just looking for a lightweight solution where I can store bytes
(key->value pairs) and create a few indexes on the data.
Cheers
Kasper
On 11/24/06, Kasper Nielsen <[EMAIL PROTECTED]> wrote:
Hi,
I'm evaluating Derby for a project of mine. I really would like to avoid
using SQL and just use Derby as a binary store. Is this possible?
My data consists of key -> value pairs where the keys are uniformly
distributed 160 bit numbers and the values are byte arrays.
For now, I need to support 2 basic queries
* Give me the value mapping for the key K or null if it doesn't exist.
* Give me a map of (key->value) for the key range of key_start to
key_end.
I had a look at the org.apache.derby.iap.store packages but wasn't quite
sure where to start.
Cheers
Kasper
