Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Is it better to use off-the-shelf websites, or write my own?

by mtomkins (Initiate)
on May 30, 2000 at 19:13 UTC ( #15409=categorized question: print w/replies, xml ) Need Help??
Contributed by mtomkins on May 30, 2000 at 19:13 UTC
Q&A  > CGI programming


My task is to develop and implement a system for bug reporting on our corporate website. I have been working with a simple text database, it adds/searches/modifies/deletes via a neat little HTML interface... my problem is that there needs to be two levels of security; user and admin. The user inputs the problem they encountered, it is automatically stamped with the date it was entered as well as a key number, a priority level of 0, an "assigned to:" of "nobody" and a "fix:" of "none". Now I need a way for an administrator to get in there and modify the priority, assignment, and fix of these problems. Any help would be appreciated.

Answer: Is it better to use off-the-shelf websites, or write my own?
contributed by neshura

The general answer on this one is always "Don't write this one yourself". Having had more than my share of experience with this issue, I can say that this is not always the correct answer. I have written and currently am in the process of writing v2.0 of an equivalent application for work flow tracking and reporting. There are times to use an off-the-shelf product, and times when you really need to write your own (which is where these commercial packages originally come from anyway).

First, there are number of really excellent applications out there for bug tracking, time tracking, work tracking. You can assume that an open source version is going to be much better than a shrink-wrap version, for one simple reason -- feature bloat. Because every company has different needs, the shrink wrap versions NEVER fit perfectly and almost always are impossible to tweak. I happen to really like Keystone, from Stonekeep Consulting, because it is free for small departments, it is easy to set up, and it is built on PHP with a mysql database. (I like PHP almost as much as perl, for different reasons)

Second, if you test a couple of packages, and you find that they don't fit your needs, then by all means, write one yourself. This is the route I took, and my department could not be more delighted. I learned a couple of things though -- interview the users before you start writing the application, map the flows/processes out early on, work out the logic -- in short, design, design, design!! Then, make sure your boss is 100% behind you (we did our programming in secret as a surprise gift for our manager -- we're just lucky it worked out well). KISS and get yerself a frozen feature set, and your life will be made much easier.

To answer your specific question, I have a set of named permissions in my database -- Administrator, Developer, Project Manager, Client, etc.
Every time a ticket is retrieved from the database the current user's permission level is also available. If a field on the form is read-only at the user's level of permissions, then only the value in the database is printed. If the user has read-write permission (like the Administrator) then the equivalent popup box or text box or whatever is printed to the screen so that the user can modify it. The code is not the cleanest, but that's why I said design before code earlier :-) Lots of stuff got tacked on later.

Hope this extensive ramble helps you out some.

Answer: Is it better to use off-the-shelf websites, or write my own?
contributed by mikfire

Don't write this yourself. Please. There are many hidden issues in this problem - I speak from way too much experience. There are many more levels of authority than you think. There are the people authorized to enter problems, the people authorized to assign problems, the people authorized to answer them and the people authorized to close them. Of course, you also have the people authorized to authorize people.

Having solved all of those, you then need to worry about database corruption which will happen when using flat files. After you have solved this, there are a hundred more hurdles to jump. And then, when you are all done, you will never escape it. It will hang about your neck like a dead albatross. You will be supporting this thing for years.

Please, trust me. Find something else somebody has written and abuse that. DO NOT WRITE THIS FROM SCRATCH!

In this light, I direct you to Freshmeat's development/bug tracking section. There are a few good choices in there, including several that have both web front ends and command line front ends. Many of them have been used and tested extensively. Several of them are free.

Mik - who is still working off therapy dollars from a PTS

Answer: Is it better to use off-the-shelf websites, or write my own?
contributed by turnstep

Even though I am usually the last one to jump on the "don't re-invent the wheel" bandwagon, I feel that mikfire is correct - a good bug reporting system can get very complex very fast. At the very least, modify one of the existing ones heavily to your particular uses. A nice one to use is bugzilla:

(it's number one in the list referenced above) It's almost free (uses the MPL, an ugly cousin of the GPL) and definitely has had lots of real-world testing. I also highly recommend GNATS, which is GPLed.

Answer: Is it better to use off-the-shelf websites, or write my own?
contributed by hacker

There's always Mantis.

I've been using it on my sites for quite some time on SourceFubar, the public CVS hosting service I run and manage. Go ahead and log in as Guest and poke around.

You can find the main site for Mantis on Sourceforge.

Please (register and) log in if you wish to add an answer

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others browsing the Monastery: (3)
    As of 2020-08-03 12:57 GMT
    Find Nodes?
      Voting Booth?
      Which rocket would you take to Mars?

      Results (27 votes). Check out past polls.