From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 17622 invoked from network); 24 Mar 2004 16:33:48 -0000 Received: from unknown (HELO monty-python.gnu.org) (199.232.76.173) by sources.redhat.com with SMTP; 24 Mar 2004 16:33:48 -0000 Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.30) id 1B6BK0-00007P-EB for listarch-gnats-devel@sources.redhat.com; Wed, 24 Mar 2004 11:33:40 -0500 Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.30) id 1B6AY8-0005Gz-Ka for help-gnats@gnu.org; Wed, 24 Mar 2004 10:44:12 -0500 Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.30) id 1B6AOM-00033E-Ov for help-gnats@gnu.org; Wed, 24 Mar 2004 10:34:38 -0500 Received: from [207.217.120.126] (helo=turkey.mail.pas.earthlink.net) by monty-python.gnu.org with esmtp (Exim 4.30) id 1B69jW-0002Q1-AX; Wed, 24 Mar 2004 09:51:54 -0500 Received: from h-68-164-91-197.snvacaid.dynamic.covad.net ([68.164.91.197] helo=acm.org) by turkey.mail.pas.earthlink.net with esmtp (Exim 3.33 #1) id 1B69jF-0006LP-00; Wed, 24 Mar 2004 06:51:37 -0800 Message-ID: <4061A111.8080904@acm.org> Date: Fri, 26 Mar 2004 13:20:00 -0000 From: Pankaj K Garg Organization: Zee Source User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, ja MIME-Version: 1.0 To: Yngve Svendsen References: <40494528.6070802@juniper.net> <406144D2.3030207@sun.com> In-Reply-To: <406144D2.3030207@sun.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: help-gnats@gnu.org, Lars Henriksen , Hans-Albert Schneider , "Andrew J. Gray" , Mel Hatzis Subject: Re: database backend for GNATS X-BeenThere: help-gnats@gnu.org X-Mailman-Version: 2.1.4 Precedence: list Reply-To: gargp@acm.org List-Id: General discussion about GNU GNATS List-Archive: List-Post: List-Help: List-Subscribe: , Sender: help-gnats-bounces+listarch-gnats-devel=sources.redhat.com@gnu.org Errors-To: help-gnats-bounces+listarch-gnats-devel=sources.redhat.com@gnu.org X-SW-Source: 2004-q1/txt/msg00175.txt.bz2 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 >> Help-gnats@gnu.org >> http://mail.gnu.org/mailman/listinfo/help-gnats > > > > > > _______________________________________________ > Help-gnats mailing list > Help-gnats@gnu.org > http://mail.gnu.org/mailman/listinfo/help-gnats > -- Pankaj K Garg garg@zeesource.net 1684 Nightingale Avenue 408-373-4027 Suite 201 408-733-2737(fax) Sunnyvale, CA 94087 http://www.zeesource.net _______________________________________________ Help-gnats mailing list Help-gnats@gnu.org http://mail.gnu.org/mailman/listinfo/help-gnats