I know that Berkeley is'nt relational. But according to some informations I read in the berkeley FAQ you could implement the same behavior by implementing some of the scan stuff by yourself... Before I decided to use McKoi I also tried hsqldb (used by thaw) but it was much slower than McKoi, especially with COUNT queries and some other queries often used by Frost. According to the hsqldb forums they know about this issue, but there is still no solution.
I didn't found any other relational java database that runs in the same JVM as frost. Hence I came to the point to think about to use berkeley and to implement the 'relational' part by myself. I need no joins so I think this could be possible. What I need are queries that have more than one condition (AND/OR). On 3/25/07, Florent Daigni?re (NextGen$) <nextgens at freenetproject.org> wrote: > * bbackde at googlemail.com <bbackde at googlemail.com> [2007-03-25 19:41:27]: > > > I currently check if the berkeley db could be a replacement for McKoi > > db which is used by Frost. I'm not too happy with McKoi. > > > > But I still don't get the concept of berkeley db. I need queries like: > > give me the messages (aka. db keys) of all messages that are: > > - new (isnew=true) > > - valid (isvalid=true) > > - not older than X days (msgdate >= oldestDate) > > > > berkeley seems to access all stored object by key only (?). Do I have > > to implement the 'table scan' by myself? How can I learn about this, > > where are more complex examples (transition from sql to berkeley db)? > > > > BDB isn't a relational database. > > > If someone can help and assist me that would be such great :) > > You probably don't want to use BDB but a relational one. Have you ever > considered using the same as thaw ? > > NextGen$ > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFGBsVFU/Z/dHFfxtcRAi1cAJ9Cd9c1Npy4drDb3xDcChoix91xSgCfS91e > ahgU4sunO1/1XFFrTSJEPWQ= > =Jo9u > -----END PGP SIGNATURE----- > > _______________________________________________ > Devl mailing list > Devl at freenetproject.org > http://emu.freenetproject.org/cgi-bin/mailman/listinfo/devl >
