Hi,
>>>> 3) A nice set of SQL queries to return message, parts, threads,
>>>> folders based on $criteria (search, id, folder, etc)
>>>
>>> I guess Matteo's working on that…
>>
>> Right, but this is where I want to see the AOX schema "imporove"... In
>> ways like adding persistant tables for threading, which are updated by
>> triggers as new messages are delivered, etc. Documented queries that
>> show how to use CTEs, ltree, etc to get threaded views, good FTS support
>> (with indexes and triggers managing them), etc.
>
> +1.
>
> I just didn't understand how much your proposal fit into current work :)
I'm looking into it. The link I've previously sent will most likely
return a 500 error for the time being.
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/