request for new API function

Hi,

To find all files and folders that have a specific property set I need
to crawl the whole working copy and fetch the properties of each and
every item, then scan the returned property list for that property.
But WC-NG uses an SQLite db so this task should be much faster with a
lot less disk access.

I'd like to ask for a new API which would allow me to search the
database for properties much faster. Something like

svn_wc_propsearch()

with parameters:

* string to search for
* value indicating how the search is done (equal, contains, begins with,
... basically all the possible match functions SQLite offers)
* bool indicating whether the search is done on the NODES table or the
ACTUAL_NODE table
* callback function which receives the search results

The callback function would receive not just the properties and paths of
the items the found properties belong to, but also any information that
the table row contains (because when an information is available for
free, an API should return it to avoid forcing clients to call yet
another API to get that info - if clients don't need the info they can
just ignore it).

And while we're at it: new APIs to search for other columns in the NODES
and ACTUAL_NODE table would also be nice and useful:
* search for 'changed_revision' and/or 'changed_date': allows to show a
view with all files that haven't changed for a long time, or files that
have changed recently, or ...
* search for 'changed_author': allows to show a quick view of who
changed what last, gather statistics, ...
* search for 'depth' to quickly determine whether the working copy is
full or may be missing something
* search for 'file_external'

With such new APIs, clients could use the advantages of WC-NG too.

A lot of ideas I had couldn't be done before because it would have been
just too slow. But now with WC-NG and the database it would be fast enough.

Thoughts?

Stefan

-- 
        ___
   oo  // \\      "De Chelonian Mobile"
  (_,\/ \_/ \     TortoiseSVN
    \ \_/_\_/>    The coolest Interface to (Sub)Version Control
    /_/   \_\     http://tortoisesvn.net