[FX.php List] How different is FX from MySQL

[Derrick Fogle]

Conversely, I've had almost the opposite experience. Working with  
MySQL as a backend DB to PHP is extremely simple and straightforward,  
and there are some very robust libraries - or frameworks - for it. The  
only thing you lose that makes more code in PHP is the fact that the  
database doesn't do calculations for you. I'll take that tradeoff for  
the speed: MySQL is so much faster as a DB than FMP, it's hard to even  
come up with a figure. Think thousands of times faster, maybe more.

FX.php is an invaluable tool and a godsend if you've already got  
something running in FMP and need to extend it to the web. But the  
code is more verbose than MySQL. And with the experience I've got in  
both PHP and FMP, I find it roughly equivalent to tackle a logic  
problem in one vs the other. Filemaker's solution always seems to be  
"yet another field"; PHP is a much bigger and dynamic sandbox, with  
some really robust functions.

If I have the need for a workgroup DB that doesn't necessarily have to  
be web-based (i.e. everyone is on the same LAN in the same office),  
I'll pick FMP and extend a few small portions to the web with FX.php  
if needed. But if I have an application that needs to be web-based  
(and that means just about any geographically diverse group of users),  
I wouldn't even think of staring in FMP except as a modeling tool.  
It's just too slow, and there's that functionality "wall" you hit with  
FMP that just doesn't exist in a PHP/MySQL web app.

Just my US $0.00...


On Sep 10, 2008, at 1:23 PM, John Funk wrote:

> You do not need FX to connect to MySql.
> There are many sites dedicated to this. PHP and MySQL work very well  
> together.
> My 2 cents: I converted a site from MYSQL to FX/FileMaker and the  
> resulting code is far simpler.
> John Funk
>
>
> On 9/10/08 1:13 PM, "Josh Shrier" <joshshrier at gmail.com> wrote:
>
>> I have been offered a couple of projects to do PHP with a MySQL  
>> database. I have become pretty fluent with FX. Can someone tell me  
>> what the learning curve would be from FX to MySQL.
>>
>> Thanks,
>>
>> Josh Shrier
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick