Re: [PHP] PHP vs. ColdFusion

On Wednesday 29 June 2005 03:12, Rick Emery wrote:
> Quoting Jochem Maas <[email protected]>:
> > what is special about the MSSQL2K servers? do you have a lot of
> > stored procedures in it? stuff like that?
>
> Exactly; the past mentality has been "do everything through
> stored procedures", so we have a *lot*.

This is a very GOOD approach, and I sincerely wish more companies 
would read data via views and write it via stored procedures.  It 
makes things SOOOOOOO much easier on the DBA who doesn't have to 
chase down 15 application developers when he wants to change a 
table and have everybody update at once.

I invite you to explore PostgreSQL (http://www.postgresql.org).  It 
features all of the advanced stuff that you might expect that 
imitation databases like MySQL don't, such as views and stored 
procedures, it's own procedural language based on Oracle's PL/SQL 
and a wide variety of others, actually has data integrity and 
reliability, and in many cases is faster than MySQL (excepting if 
your tables are very basic, you don't join much, and care less 
about the data being 100% accurate).

IMNSHO, MySQL gives a bad name to the open source community simply 
because of it's popularity.  It is certainly nowhere near the level 
of Microsoft SQL or PostgreSQL.

For the record, you can run PHP on a linux/unix host just fine, 
using the freetds library (and optionally unixodbc) to communicate 
with your Microsoft SQL servers.  ODBC makes for more 
simplified/controlled connection management, whereas direct linking 
against the client libraries is higher performance.

Cheers,
-- 
Casey Allen Shobe | http://casey.shobe.info
[email protected] | cell 425-443-4653
AIM & Yahoo:  SomeLinuxGuy | ICQ:  1494523
SeattleServer.com, Inc. | http://www.seattleserver.com