Re: can PHP give MySQL the missing relational properties?

Justin Patrin <jpatrin@pnicorp.com> · Tue, 28 Oct 2003 09:59:34 -0800

I've written a system which does the delete stuff at least. It deals with 
the foreign keys for you. (Note that you could easily use the functions 
in the program for your own uses, that's what it's for.)

http://rdbedit.sf.net

I ought to put up some screenshots and such, but I have such a hard time 
trying to relate what my program does....

Morten Gulbrandsen wrote:
MySQL as database for PHP,

Hello Programmers,

MySQL is performing very fast and runs rock stable under high load,
But it is not ANSI SQL compatible.

I have an interesting thread about this issue under
Newsgroups: comp.databases.theory

Subject: Re: Is mySQL a RDBMS?
This also contains SQL code incompatible to the present version of MySQL.

My question is: can PHP give MySQL the missing relational properties?

Is it possible to remedy the limitations of MySQL concerning
FOREIGN KEYS?
Actions,
REFERENCES
and triggers

through PHP?

ON DELETE SET DEFAULT
For instance: I think could be solved through additional coding,
But what about the other missing SQL statements?

REFERENCES
ON DELETE CASCADE
ON UPDATE CASCADE

I feel the basic database functionality has to be
Implemented without PHP, PHP is an interface between the relational
database,
the web server and the browser and is
Not suited to code beyond the limitations of any relational database.

Is this correct ?

In other words,
has anyone succeeded in implementing an SQL RDBMS solely in PHP ?

Yours Sincerely

Morten Gulbrandsen

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php