On Fri, May 31, 2002 at 10:01:34AM -0500, Ryan Hatch wrote:
> -------------------------------------------------
> THE PROBLEM:
> -------------------------------------------------
> MySQL alone cannot represent a complex data-structure.
>
> Re-modeling of MySQL data is required in Perl, PHP, Java,
> etc.
One wonders why each of these applications has such intimate knowledge
of your table schemes, or mysql, or even SQL in general.
If your environment warrants it (and I'd say four different platforms
is good enough) you might do good to hide the database behind an abstraction
layer. This being the only layer that talks to mysql for the purpose of
providing primitives that the rest of your business logic (all of the perl,
java, php, vb scripts) depend on. When you update table structure, you simply
need to change the abstraction layer instead of all of your scripts.
If you want to pitch it to management, just say "XMLRPC!" until their
ears bleed.
--
Michael Bacarella | Netgraft Corporation
| 545 Eighth Ave #401
Systems Analysis | New York, NY 10018
Technical Support | 212 946-1038 | 917 670-6982
Managed Services | [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
