[Trac] Re: querying across projects

[Neil Gower]

> From: Gary Oberbrunner <garyo at genarts.com>
> 
> Russ Brown wrote:
> 
>>> Neil Gower wrote:
>>> 
>>
>>>>> I started poking around with WikiMacros to try to generate a list of 
>>>>> tickets across several projects. ...
>>
>>> 
>>> Something I've posted about before...  :-)  Once trac can be run with a 
>>> Postgres database engine (and without moving your existing trac 
>>> databases away from sqlite), you could potentially create a special 
>>> 'aggregate' trac installation that runs on Postgres using the DBI-Link 
>>> extension, which allows you to make any external data source (including 
>>> a sqlite database) appear as a table in the Postgres database.
> 
> 
> I've been lurking on this list, waiting for the day when trac can support 
> multiple projects (or subprojects, I'd like a full hierarchy but that's not 
> *so* important) with merged timeline and milestones and all that goodness. 
> That's the one thing stopping me from moving my group to trac right now.

Thanks for the feedback guys.  To clarify, I would also love to see some 
kind of built-in multiple-project support in Trac, but for now I would 
be happy to know how to access the data for one project from another, in 
Python.

I don't need anything fancy, I'm quite content to have to do it at the 
Python level in a WikiMacro using SQLite.  I imagine that for a Trac 
developer, this would be really easy... hence my post.  Any Trac 
developers lurking here?  :-)

Thanks,


Neil.