Re: PHP is NOTa Bloated Kludge, end of discusion?
| From: | Richard Lynch | Date: | Fri, 05 Oct 2001 19:51:50 +0000 |
| Subject: | Re: PHP is NOTa Bloated Kludge, end of discusion? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70189@lists.php.net to get a copy of this message | ||
> >OK, true. But, this is necessary if you want PHP to automatically
> >connect to different DBs.
> >A plus to portability and a minus to... (to what?)
The first minus is to performance -- You route through more and more layers
of functions as you add databases and functionality.
The next minus is feature-set -- If you *really* want platform-independence,
you are stuck with SQL92 (more-or-less). The '92' stands for 1992, which is
63 years old technology in doggie-years. :-) The point is that at that
time, even an automatically incrementing ID field wasn't agreed on! Writing
high-performance platform-independent SQL is virtually impossible. You'll
be giving up every advance in database technology since 1992.
Your other option is to write your own SQL parser to de-construct SQL and
re-build it in a platform-specific way... Of course, there's always ODBC,
which is more-or-less standard and in some cases has decent performance...
But it's not a no-brainer uniform cross-platform reasonable-performance
answer.
--
WARNING richard@zend.com address is an endangered species -- Use
ceo@l-i-e.com
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm