[freeside-devel] 1.4.0pre7

[Dave Burgess]

ivan wrote:

> On Wed, Dec 26, 2001 at 02:55:53PM +0100, Titus Hanke wrote:
> > Hi,
> > I do not think, that dropping mysql support is a good idea.
>
> If you don't think so, then you should get together with the other MySQL
> users and contribute support.
>
> Me, I only have so many hours in the day, and if I can take advantage of
> standard SQL features supported by PostgreSQL to improve Freeside more
> quickly, that's the best solution for the project and my customers.  I can
> spend my time working around MySQL's lack of standard SQL features, or I
> can spend my time improving Freeside by working on top of a robust RDBMS.
>
>

On the MySQL split -

What mechanism do you see putting in place for the differences in the database
structures?  A Conf.pm change, or something a little more heuristic (if
"SELECT" A fails, try "SELECT" B)?

The reason I ask is because the following SELECT "select max(version()) from
agent" will give you the MySQL Version number.  We know that the sub-select
queries don't work in anything older than 4.1, and work in the current
PostgreSQL release, so is there a way to use that information to 'prepare' the
select accordingly.  Basically, the old select (as slow as it was) worked
adequately under the old MySQL version, so we should (I'd think) be able to
programatically decide which select we were going to use.  If you just leave
the old select structure in place and add 'improved' selects for newer DBMS
versions, we'd be in good shape.



> See the URL referenced below for details on the queries that need to be
> rewritten for MySQL.  Alternately, you might look into whether or not
> subqueries are supported in MySQL 4.0 or 4.1.
>

Sub-selects are scheduled for inclusion in 4.1, but they may make an early
appearance in 4.02 (if the rumor mill is right).

>
> > There are
> > too many ISPs out there using mysql and NOT offering psql...
> > I guess you might use a great part of your community if you decide to
> > drop mysql support.
> >

I don't think it matters.

I prefer MySQL, but that's no stinging indictment of PostgreSQL.