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

[Gjermund Gusland Thorsen]

Ehh... I see three totally different scenarios, when to use FileMaker?
When you need GUI and business logic fast for a small/medium user environment.

When to use Filemaker and the web?
When you have a small/medium user environment that needs input from the web.

When to use MySQL and the web?
When you need dynamic data on the web fast.

ggt

2008/9/10 Derrick Fogle <derrick at fogles.net>:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>