1602/jugglingdb — Issue #19: "greater/less than" queries
Author: Madsn
Created: 2012-01-13 01:24:44+00:00
State: open

More of a discussion topic than an issue.
I notice that there is no support for advanced queries such as filtering where a specific column is greater/less than, and I appreciate your reasoning for this (issue #2 https://github.com/1602/jugglingdb/issues/2).

But this made me curious, is there any way to achieve the same effect without taking a large performance hit?

So let's take a simple django query that gets posts with pub_date >= someDate:
**Post.objects.filter(pub_date__gte=someDate)**

What would be the most efficient way to achieve the same effect when such queries aren't available?
Or would you tackle this issue in an entirely different manner?
Would needing this simply mean the application calls for a DMBS that supports this type of query?

Sorry if creating an issue is inappropriate for this, let me know if that is the case. Thanks