[Trac] querying across projects

[Russ Brown]

Neil Gower wrote:
> I started poking around with WikiMacros to try to generate a list of 
> tickets across several projects.  The projects are all hosted on the 
> same server, as described here:
> 
> http://projects.edgewall.com/trac/wiki/TracMultipleProjects
> 
> I know I'm fighting the system a bit here, since each Trac project is 
> really independent of the others.  However, given that I control all of 
> the projects, it seems like I should be able to set up db connections to 
> each of the databases, and aggregate the data in the macro.
> 
> I'm hoping someone could jump start the process a bit by helping me 
> figure out how to set up those connections from within a macro.
> 
> Any tips are much appreciated!
> 

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. You could 
set up links to all of your other trac database and incorporate them 
into views using UNION, which your aggregate trac installation would 
then see as one database.

There would of course be issues with duplicate IDs, but they can 
probably be worked around.

 From what I've been able to gather, a working Postgres database driver 
for Trac is maturing nicely.

Link to the DBI-Link project:

http://pgfoundry.org/projects/dbi-link/


> Cheers,
> 
> 
> Neil.
> _______________________________________________
> Trac mailing list
> Trac at lists.edgewall.com
> http://lists.edgewall.com/mailman/listinfo/trac
>