On Sun, Mar 25, 2007 at 07:41:27PM +0100, bbackde at googlemail.com wrote: > 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)
All possible with secondary indexes. > > 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)? You can create a secondary index on any property of the main tuples. > > If someone can help and assist me that would be such great :) We have had problems with BDB. Mostly being that when widely deployed, we get frequent reports of the database corrupting and it not being possible to open it because of a DatabaseException. This cannot be automatically rectified as it happens after the built-in recovery code executes. In Freenet we can recover from this by reconstructing the database from the content which is stored separately (we use the database as an index). > > Thanks. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: Digital signature URL: <https://emu.freenetproject.org/pipermail/devl/attachments/20070327/f7862c1a/attachment.pgp>
