[FX.php List] How different is FX from MySQL
Joel Shapiro
jsfmp at earthlink.net
Thu Sep 11 15:03:21 MDT 2008
COOOOL!!
As someone who couldn't even qualify yet as a SQL ignoramus, I've
gotta look into this...
Dale: Do you think looking at the SQL Functions section in
FXFunctions.pdf (PerformSQLQuery, SetDataKey, SetSelectColumns,
SQLFuzzyKeyLogicOn) will be enough to get me started? Will using
those functions w/ FM-like FX functions allow me to do things like
FMFind, FMEdit, FMNew w/ data stored in MySQL?
(& Leo: yes, learning SQL is on my list of things to do... ah, but
when? ;-)
Thanks,
-Joel
On Sep 11, 2008, at 1:51 PM, Dale Bengston wrote:
> 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
>
> _______________________________________________
> 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