Re: database backend for GNATS
Pankaj K Garg <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.gnats.general |
|---|---|
| Organization | Zee Source |
| Message-ID | <[email protected]> |
Ditto. I'm going to be looking into this in the near future, and am really excited about this new development from Mel. Bugzilla has been gaining a lot of popularity, and I think one of the reasons might be its use of a DB backend. Pankaj Yngve Svendsen wrote: > Mel, > > just so you don't lose heart from the lack of response. > > This looks extremely useful and is something I have been wanting for a > long time. Unfortunately, I am too tied up at the moment to be able to > look at this as closely as it deserves. I hope to be able to play with > it closer to summer. > > Again, thanks for what is likely to be the most important GNATS > development for a very long time. > > - Yngve > > > Mel Hatzis wrote: > >> >> I've been working on extending GNATS to support various backend >> datastores. It is my hope that this work can be rolled into >> (or perhaps become the basis for) GNATS 4.1 or whatever the next >> release may be (GNATS 5.0?). >> >> To date, I have successfully completed the implementation >> of a version of GNATS which can be configured to run with >> an Oracle backend. I have managed to roll this out at the >> company where I work where it has met with much success. >> >> If you are interested in evaluating this work, you can download >> it (and review the related documentation) from: >> >> http://professional.juniper.net/gnats/ >> >> The approach I've taken is to separate out all the functionality >> associated with access to the GNATS PR data repository into >> a separate library....essentially creating a clean interface >> between GNATS and it's data store. The front-end utilities >> and applications such as Gnatsweb are unaffected...they >> continue to work exactly the same. >> >> Currently, there are two back ends: the standard flat-file >> repository, and an Oracle-based backend. We have been using >> the Oracle version at Juniper for six months, with tens of >> thousands of PRs and hundreds of users. >> >> The work is based on a snapshot of the 4.0 beta 2 source, though >> all subsequent patches have been incorporated...so all the work >> that went into GNATS 4.0 is included. As of today, all patches to >> the CVS version of GNATS have been included in this project. >> >> It is my hope that this work will be extended to support >> additional SQL datastores such as MySQL and PostgreSQL. >> I believe that this could now be accomplished without >> expending a great deal of effort. I'm willing to provide >> a template to anyone interested in pursuing this endevour >> to get this work underway. >> >> -- >> Mel Hatzis >> >> >> _______________________________________________ >> Help-gnats mailing list >> [email protected] >> http://mail.gnu.org/mailman/listinfo/help-gnats > > > > > > _______________________________________________ > Help-gnats mailing list > [email protected] > http://mail.gnu.org/mailman/listinfo/help-gnats > -- Pankaj K Garg [email protected] 1684 Nightingale Avenue 408-373-4027 Suite 201 408-733-2737(fax) Sunnyvale, CA 94087 http://www.zeesource.net