From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 20762 invoked from network); 24 Mar 2004 08:22:16 -0000 Received: from unknown (HELO monty-python.gnu.org) (199.232.76.173) by sources.redhat.com with SMTP; 24 Mar 2004 08:22:16 -0000 Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.30) id 1B63dv-0006e8-L6 for listarch-gnats-devel@sources.redhat.com; Wed, 24 Mar 2004 03:21:43 -0500 Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.30) id 1B63dl-0006dZ-SU for help-gnats@gnu.org; Wed, 24 Mar 2004 03:21:33 -0500 Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.30) id 1B63dC-0006RV-Vy for help-gnats@gnu.org; Wed, 24 Mar 2004 03:21:31 -0500 Received: from [192.18.98.34] (helo=brmea-mail-3.sun.com) by monty-python.gnu.org with esmtp (Exim 4.30) id 1B63dC-0006QV-CY; Wed, 24 Mar 2004 03:20:58 -0500 Received: from phys-lego-1.Norway.Sun.COM ([129.159.112.5]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id i2O8Kmp9026387; Wed, 24 Mar 2004 01:20:51 -0700 (MST) Received: from sun.com (atum15 [129.159.112.215]) by phys-lego-1.Norway.Sun.COM (8.12.10+Sun/8.12.10/ENSMAIL,v2.3beta1412) with ESMTP id i2O8KlIS025565; Wed, 24 Mar 2004 09:20:47 +0100 (MET) Message-ID: <406144D2.3030207@sun.com> Date: Wed, 24 Mar 2004 09:32:00 -0000 From: Yngve Svendsen User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mel Hatzis References: <40494528.6070802@juniper.net> In-Reply-To: <40494528.6070802@juniper.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Lars Henriksen , Hans-Albert Schneider , "Andrew J. Gray" , help-gnats@gnu.org Subject: Re: database backend for GNATS X-BeenThere: help-gnats@gnu.org X-Mailman-Version: 2.1.4 Precedence: list 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/msg00173.txt.bz2 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