From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 12073 invoked from network); 10 Mar 2004 05:28:31 -0000 Received: from unknown (HELO monty-python.gnu.org) (199.232.76.173) by sources.redhat.com with SMTP; 10 Mar 2004 05:28:31 -0000 Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.30) id 1B0wFc-0005B6-CH for listarch-gnats-devel@sources.redhat.com; Wed, 10 Mar 2004 00:27:28 -0500 Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.30) id 1AzSX7-0006Nm-7Y for help-gnats@gnu.org; Fri, 05 Mar 2004 22:31:25 -0500 Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.30) id 1AzSWJ-000653-DO for help-gnats@gnu.org; Fri, 05 Mar 2004 22:31:07 -0500 Received: from [207.17.137.64] (helo=colo-dns-ext2.juniper.net) by monty-python.gnu.org with esmtp (TLSv1:DES-CBC3-SHA:168) (Exim 4.30) id 1AzSWF-00061J-VB; Fri, 05 Mar 2004 22:30:32 -0500 Received: from merlot.juniper.net (merlot.juniper.net [172.17.27.10]) by colo-dns-ext2.juniper.net (8.12.3/8.12.3) with ESMTP id i263UKBm038650; Fri, 5 Mar 2004 19:30:20 -0800 (PST) (envelope-from hatzis@juniper.net) Received: from juniper.net (ssh3.juniper.net [207.17.136.47]) by merlot.juniper.net (8.11.3/8.11.3) with ESMTP id i263UFo88948; Fri, 5 Mar 2004 19:30:15 -0800 (PST) (envelope-from hatzis@juniper.net) Message-ID: <40494528.6070802@juniper.net> Date: Wed, 10 Mar 2004 05:28:00 -0000 From: Mel Hatzis User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: help-gnats@gnu.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: Yngve Svendsen - Sun Norway , Hans-Albert Schneider , "Andrew J. Gray" , Lars Henriksen Subject: database backend for GNATS X-BeenThere: help-gnats@gnu.org X-Mailman-Version: 2.1.2 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/msg00126.txt.bz2 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