What techniques are available for filtering collections of objects when using zodb?

Posted by Omega on Stack Overflow See other posts from Stack Overflow or by Omega
Published on 2010-04-15T02:27:05Z Indexed on 2010/04/15 2:33 UTC
Read the original article Hit count: 229

Filed under:

ephemeral-data

As the title says: What techniques are available for filtering objects when using zodb?

The equivalent in SQL terms would be something like filtering results by a date range. Or only returning rows with a particular value set in a column.

If I had a series of blog posts and only wanted ones done in the past month, what would I have to do? Is there any way to optimize these kinds of "queries"? My gut tells me iterating over all the objects in a relationship simply to perform a test is less than optimal.

Related posts about zodb

Is there a primary key concept in ZODB for objects

as seen on Stack Overflow - Search for 'Stack Overflow'
I wanted to know if we can have a unique identifier for all objects that are stored in ZODB >>> More
How to implement Persistent List or Persistent Mapping in ZODB

as seen on Stack Overflow - Search for 'Stack Overflow'
One to many relationships not working in ZODB as list is mutable.They say solution is Persistent Mapping or Persistent List or BTree.Can someone please tell me how is it exactly done >>> More
Get User Information from ZODB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am trying to get information out of my Plone site regarding Users. It is relatively easy to get info out of the portal_catalog. However, user info isn't in the portal_catalog. Can somebody tell me how to get user info out of the ZODB from my Plone site? Basically, I am looking to get back… >>> More
More interactive ZODB packing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Current ZMI management "Pack database" functionality is little rough. 1) Could it be possible to have some kind of progress indicator for web UI? E.g. one telling how many minutes/hours are left giving at least some kind of estimate 2) How does ZODB packing affect the responsivity of the site… >>> More
maintaining a large list in python

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to maintain a large list of python pickleable objects that will quickly execute the following algorithm: The list will have 4 pointers and can: Read\Write each of the 4 pointed nodes Insert new nodes before the pointed nodes Increase a pointer by 1 Pop nodes from the beginning of the list… >>> More

Developer IT