[Trac] querying across projects

[Gary Oberbrunner]

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.

It seems like multiple projects *could* be implemented in a single sqlite 
database, right?  All you'd need is a Projects table and each thing that's 
part of a project (ticket etc.) just gets a project_id (defaults to 0 which is 
the special legacy "default project").  Then adjust some sql queries and 
templates, and voila.  But I bet it's really harder than that.  I know there 
are issues re: what wiki links mean if there are multiple repositories and so 
on; those might have to be massaged.  But it seems doable.  (We have a single 
svn repo for all projects anyway.)

I wish I had time to spend on it -- trac is so nice in all other ways! 
Anyway, I just wanted to pipe up and say that this is our #1 feature request.

-- Gary