Login | Register
My pages Projects Community openCollabNet

Discussions > dev > MySQL and other sql patch > Reply to message

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

Reply to message

2020-03-13: This site is going to be decommissioned and shut down very soon. Please copy and archive any data you wish to keep ASAP

* = Required fields
* Subject
* Body
Send reply to
Author (directly in email)
Please type the letters in the image above.

Original message

Author Frank Sweetser <fs@wpi.edu>
Full name Frank Sweetser <fs@wpi.edu>
Date 2003-07-07 16:03:24 PDT
Message I've attached a patch which adds a new db_type, 'sql'. I started out by just
copying db/postgres/ and then hacked it up to work with either mysql or
postgresql based on a new config var, 'db_driver'. It should still work just
as before with postgresql, though I've only really tested it with mysql so far.
In addition, it should make it pretty easy to add other sql drivers without too
much copying of code.

I only made minimal changes to the actual sql queries. The only bits I did
really have to change were capitilization of table names (mysql is case
sensetive, while it appears that postgresql is not) and a slightly differing
distinct syntax.

Whadya think?

Frank Sweetser fs at wpi.edu
WPI Network Engineer