Login | Register
My pages Projects Community openCollabNet

Discussions > dev > MySQL and other sql patch

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

current
Discussion topic

Back to topic list

MySQL and other sql patch

Reply

Author Frank Sweetser <fs at wpi dot edu>
Full name Frank Sweetser <fs at wpi dot 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
Attachments

« Previous message in topic | 1 of 11 | Next message in topic »

Messages

Show all messages in topic

MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-07 16:03:24 PDT
     Re: MySQL and other sql patch jwbernin John Berninger 2003-07-07 17:32:38 PDT
         Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 05:50:35 PDT
             Re: MySQL and other sql patch jwbernin John Berninger 2003-07-08 06:04:49 PDT
                 Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 06:12:06 PDT
                     Re: MySQL and other sql patch jwbernin John Berninger 2003-07-08 06:46:05 PDT
                     Re: MySQL and other sql patch hunterm Hunter Matthews 2003-07-08 09:26:44 PDT
                         Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 10:28:41 PDT
                             Re: MySQL and other sql patch hunterm Hunter Matthews 2003-07-23 13:49:08 PDT
                                 Re: MySQL and other sql patch Frank Sweetser <fs at WPI dot EDU> Frank Sweetser <fs at WPI dot EDU> 2003-07-23 13:51:48 PDT
             Re: MySQL and other sql patch Hunter Matthews <thm at duke dot edu> Hunter Matthews <thm at duke dot edu> 2003-07-08 09:23:08 PDT
Messages per page: