Re: [REQADM-Users-L] REQADM moved to SourceForge

[Steve W. <st...@al...>]

Tom Helbekkmo wrote:
> So, if I read you correctly, the move from the Athena database to a
> "real" RDBMS with SQL didn't make it in time, and will be a task for
> the user community?  Has anyone started?  I'd like to a) get 1.3 up
> and running, and then b) start rewriting the database access code as
> soon as possible...

Yes, actually, I've already started writing a MySQL replacement for it.
Not only should this speed up REQADM and make it easier to set up, but
I'm considering ditching all the weird little support services and scripts
which keep REQADM in sync with your organization's user list, and just
document a couple of MySQL tables and say "Just do whatever you need to
do to keep these tables up to date on your end, and REQADM will read them."

That way, there's no reason you'd need to shut down REQADM's server for
maintenance each night, and the installation and maintenance of the
system gets even easier.

This is a somewhat involved change, though, because currently the 
ticket data are stored in ASCII flat files, with a subset of their
attributes in the DBMS.  In the SQL version, REQADM will store the
entire ticket data properly in database tables.  This means that all
the code currently in the clients (request object) to parse out and
reconstruct that ASCII format will go away, and they'll just send and
receive ready-to-use data structures.

--steve
-- 
Steve Willoughby     | "It is our choices... that show what we truly 
<st...@al...>  | are, far more than our abilities."
                     |     --Albus Dumbledore, in Harry Potter and the 
                     |            Chamber of Secrets, by J. K. Rowling