LauraleeDooley
asked on
Coldfusion vs. PHP
This is a question that has been raised in this forum before, but the postings were in 2003. Both worlds of CF and PHP have changed since then. So here goes ...
I'm a ColdFusion programmer who who spent the past 5 years as the sole programmer on our organization's main website.
We have hired other junior programmers for specific project-related websites. Some of them work in PHP and one of our key project sites has moved over to the LAMP platform.
The system we've created in ColdFusion MX not only runs our Website, but runs parts of our Intranet, a backend home-grown CMS, online tracking and data analysis tools, and several other applications. Plus we have a few project sites coded in CFMX. We use a lot of stored procedures in our SQL Server 2000 database and use cfloops in much of our output.
Now, there is a groundswell from the PHP programmers to move our site over to the LAMP platform as we consider revising our site and adding a true CMS. Up to this point, I've been open to potentially developing a migration path to PHP, but right now I'm under the gun to get a site facelift/revision done by the end of September 2006 AND a CMS tool in place to support some of the new features in this site facelift/revision. I've been looking at keeping things in ColdFusion/SQL Server 2000 and adding CommonSpot CMS (which I understand supports ColdFusion and PHP) with FuseTalk (for the forum/blogging elements).
However, there is still push for me to move from CFMX/SQL Server to PHP/MySQL.
I'm a CF programmer and database engineer. Apart from that, I've taken Basic and Perl (years ago), and have (of course) worked with XHTML, XML, and Javascript. I'm willing to learn PHP, but haven't been convinced that this is the way to go at this point given the potentially high cost of conversion as we will have to pay someone to convert all our site elements (one person can't do it all efficiently) -- seems like funds for this should be used to develop content for our users, not for making a platform shift.
I may be preaching to the choir, but I would like your thoughtful input ...
I'm a ColdFusion programmer who who spent the past 5 years as the sole programmer on our organization's main website.
We have hired other junior programmers for specific project-related websites. Some of them work in PHP and one of our key project sites has moved over to the LAMP platform.
The system we've created in ColdFusion MX not only runs our Website, but runs parts of our Intranet, a backend home-grown CMS, online tracking and data analysis tools, and several other applications. Plus we have a few project sites coded in CFMX. We use a lot of stored procedures in our SQL Server 2000 database and use cfloops in much of our output.
Now, there is a groundswell from the PHP programmers to move our site over to the LAMP platform as we consider revising our site and adding a true CMS. Up to this point, I've been open to potentially developing a migration path to PHP, but right now I'm under the gun to get a site facelift/revision done by the end of September 2006 AND a CMS tool in place to support some of the new features in this site facelift/revision. I've been looking at keeping things in ColdFusion/SQL Server 2000 and adding CommonSpot CMS (which I understand supports ColdFusion and PHP) with FuseTalk (for the forum/blogging elements).
However, there is still push for me to move from CFMX/SQL Server to PHP/MySQL.
I'm a CF programmer and database engineer. Apart from that, I've taken Basic and Perl (years ago), and have (of course) worked with XHTML, XML, and Javascript. I'm willing to learn PHP, but haven't been convinced that this is the way to go at this point given the potentially high cost of conversion as we will have to pay someone to convert all our site elements (one person can't do it all efficiently) -- seems like funds for this should be used to develop content for our users, not for making a platform shift.
I may be preaching to the choir, but I would like your thoughtful input ...
ASKER
Has MySQL support for stored procedures and does it have a good interface for writing and running on-off SQL Queries within the database? I had heard in the past that it wasn't as robust as SQL Server 2000. But that was about a year ago and I'm sure things may have changed.
Yes, MySQL does now have support for stored procs.
And they have a nice free tool http://www.toadsoft.com/downld.html Called Toad.
And they have a nice free tool http://www.toadsoft.com/downld.html Called Toad.
Information on Stored Procs http://www.digitalpropulsion.org/Programming/Stored_Procedures_in_MySQL_5_0
Also, I know its not free, but I have heard good things about this: http://www.convert-in.com/mss2sql.htm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
We use a combo of CF (BlueDragon actually) and MySQL. This is working quite well for us. For you example I would recomend this route for you as well. Since your app is already in CF, all you would have to update is the SQL parts. Given the time table that you have listed, this might be the best way to meet your deadline.
-73Spyder