database backend for GNATS

database backend for GNATS

[Mel Hatzis]

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

Re: database backend for GNATS

[Yngve Svendsen]

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

Re: database backend for GNATS

[Mel Hatzis]

Thanks for your response.

I've had a little interest...based on my analysis of our web
server logs...but nowhere near as much as I was hoping. :-)

The SQL backend has actually turned out to be extremely useful.
Not only have we managed to perform some configuration changes
that would otherwise have been almost impossible, but we've
leveraged the work to setup views into our PR datastore,
allowing external vendors to access subsets of our PR data.

We're also about to setup a search engine (UltraSeek) which has
an Oracle interface, to provide token based searching of our
PR datastore. This will significantly enhance our PR search
capability by essentially providing us with a way to query across
all our multitext fields in next to no time.

I'll be eagerly awaiting your review.

Thanks again.

-Mel

On 03/24/2004 12:20 AM, Yngve Svendsen submitted:
> 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

Re: database backend for GNATS

[Pankaj K Garg]

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

Re: database backend for GNATS

[Andrew Gray]

Hi Mel,

> 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?).

Thanks for doing this work on extending GNATS and making it available.
Unfortunately I have not been committing enough time to GNATS to take
on rolling your work into the next version of GNATS.  I hope that by
stepping down as maintainer I will clear the way for a better new
maintainer to take this on.

> 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.

That sounds good.  Supporting a free software database such as MySQL
may be important in getting the changes accepted, since GNATS is a GNU
project.

-- 
Andrew Gray
GNU GNATS Maintainer




_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats