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

Dale Bengston dbengston at tds.net
Thu Sep 11 14:51:42 MDT 2008


Correct. I am a SQL ignoramus. But FX does all that heavy lifting!

Dale


On Sep 11, 2008, at 3:37 PM, Joel Shapiro wrote:

> Great.  Then my next question is...
>
> Does using FX w/ SQL mean I don't need to learn much SQL?
>
> (how overly optimistic am I?)
>
> -Joel
>
>
> On Sep 11, 2008, at 12:33 PM, Dale Bengston wrote:
>
>> FX also works with Postgre. And with ODBC sources as well.
>>
>> Dale
>>
>>
>> On Sep 11, 2008, at 2:02 PM, Leo R. Lundgren wrote:
>>
>>> BTW! Look at PostgreSQL as well. It's a /very/ competent database,  
>>> and my personal preference.
>>>
>>> 11 sep 2008 kl. 20.58 skrev Dale Bengston:
>>>
>>>> A big, loud "Yes!"
>>>>
>>>> In fact, we have constructed our own PHP platform/framework in  
>>>> such a way that we can easily toggle the data source of an entire  
>>>> site from MySQL to FileMaker.
>>>>
>>>> We are doing far more MySQL projects than FileMaker at this  
>>>> point. If we are not building into an existing FileMaker  
>>>> installation, we almost always choose MySQL. It is around a  
>>>> zillion times faster than dragging XML out of FileMaker.
>>>>
>>>> Dale
>>>>
>>>> On Sep 11, 2008, at 12:45 PM, Joel Shapiro wrote:
>>>>
>>>>> Has anybody here ever used FX.php to connect to a MySQL data  
>>>>> source?
>>>>>
>>>>> Chris Hansen has said it's possible, and there's some basic  
>>>>> documentation in FXFunctions.pdf
>>>>>
>>>>> -Joel
>>>>>
>>>>>
>>>>> On Sep 11, 2008, at 10:00 AM, Michael Layne wrote:
>>>>>
>>>>>> I've spent a lot of time in both as well, and I tend to agree  
>>>>>> with Derrick.  With solutions that already exist in FMP, go for  
>>>>>> it with FX and get the benefit of PHP, but starting from  
>>>>>> scratch (and again, if it's primarily a web-based solution), I  
>>>>>> would go with MySQL every time.  As for any learning curve,  
>>>>>> there is one if you've never written in SQL, but there are so  
>>>>>> many examples, tutorials, even frameworks to help, that your  
>>>>>> resources are virtually unlimited.
>>>>>>
>>>>>> On a more detailed note, you use the FX class and syntax, etc.  
>>>>>> to communicate with FM, but once you get your results, what you  
>>>>>> do in PHP doesn't have to be wildly different from what you do  
>>>>>> after getting your results from a SQL statement... 2 different  
>>>>>> queries, but I have one app that uses MySQL for products, and  
>>>>>> FM for generating orders with those products, sometimes all in  
>>>>>> one file.
>>>>>>
>>>>>> SQL:
>>>>>> 	$q = "SELECT * FROM catalog WHERE vendor = '" .  
>>>>>> $_SESSION['vid'] . "'"; // display catalogs to begin product  
>>>>>> selection
>>>>>> 	$r = mysql_query($q,$connection) or die ("Unable to retrieve  
>>>>>> information from MySQL server: " . mysql_error());
>>>>>>
>>>>>> FX:
>>>>>> 	$q = new FX($ip, $port);
>>>>>> 	$q->SetDBData($fmdb,$lay);
>>>>>> 	$q->AddDBParam('sessionID',session_id()); // grab existing  
>>>>>> items from order items table
>>>>>> 	$r = $q->FMFind();
>>>>>>
>>>>>> RESULTS (FX):
>>>>>> 	foreach ($r['data'] as $l) {
>>>>>> 		// do something...
>>>>>> 	}
>>>>>>
>>>>>> RESULTS (MySQL):
>>>>>> 	while ($l = mysql_fetch_assoc($r)) {
>>>>>> 		// do something...
>>>>>> 	}
>>>>>>
>>>>>> HTH,
>>>>>>
>>>>>> Michael
>>>>>>
>>>>>> Michael Layne  |  9 degrees development  |  9degrees.com  |   
>>>>>> skype:laynebay
>>>>>>
>>>>>> On Sep 10, 2008, at 5:50 PM, Derrick Fogle wrote:
>>>>>>
>>>>>>> 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
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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



More information about the FX.php_List mailing list