db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Nielsen <n...@kav.dk>
Subject Re: Using Derby as a binary store
Date Fri, 24 Nov 2006 11:45:09 GMT
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.


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.


> On 11/24/06, Kasper Nielsen <news@kav.dk> 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

View raw message