[Gllug] MySQL Woes

[Jackson, Harry]

> -----Original Message-----
> From: Paul Brazier [mailto:pbrazier at cosmos-uk.co.uk]
> 
> Try PostgreSQL. I've not used it but I believe it does more of the
> "proper" SQL RDBMS stuff than MySQL.
> 
> I think MySQL is for when you want speed and aren't so worried about
> referential integrity etc.

I am trying to create an application that can be used with any database. If
MySQL is going to be one of these and it will because of its popularity in
the GNU world then the application code will have to enforce referential
integrity. This means that if we enforce the integrity at the application
level do we duplicate the rules at the Postgres back end or not. Personally
I wouldn't because it will be duplication of effort but we will end up with
a top heavy application that is already suffering with scalability issues.

Postgres is a ODBMS not an RDBMS. Not entirely sure what the implications
are as far as design are concerned but I imagine it would be a bit
different.

Harry 
To keep it a little on topic, I cannot believe that I have become a victim
of an open source applications popularity.




*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20020612/20ee24e9/attachment.html>