[Yum-devel] Sqlite improvements

seth vidal skvidal at phy.duke.edu
Tue Jan 18 22:30:02 UTC 2005


On Wed, 2005-01-19 at 08:29 +1000, Menno Smits wrote:
> > What matching capabilities does sqlite offer? Is it just sql 'like'
> > matches or anything else?
> 
> Sqlite has the LIKE operator and also a "GLOB" operator. Here's a 
> section from the docs:
> 
> --------------------------------------
> The GLOB operator is similar to LIKE but uses the Unix file globbing 
> syntax for its wildcards. Also, GLOB is case sensitive, unlike LIKE. 
> Both GLOB and LIKE may be preceded by the NOT keyword to invert the 
> sense of the test. The infix GLOB operator is identical the user 
> function glob(X,Y).
> --------------------------------------
> 
> Could this be useful?
> 

yes, it could well be - but of course - if all else fails we can just
iterate the db - it'll take a while  - but it won't use much memory :)

-sv





More information about the Yum-devel mailing list