Providing direct access to your DB via a flex app over the web is extremely insecure, even in “safe intranents” – you’d be surprised what bored employees are capable of.
Best approach is to use a thing service layer, possibly something like FlexCRUD(http://flexcrud.riaforge.org/blog/index.cfm/2007/5/5/Updated-to-ver sion-03-in-SVN) , it’s a little out of date and I personally have no experience with it, but have heard of some people using it with success. Honestly, even if you go the route of AMFPHP or a simple SOAP webservice layer (like PEAR’s Services_Webservice package), it’s really easy to create a service for your specific needs. AMFPHP is probably the easiest in the long term as it doesn’t require you to do a lot of XML parsing to access your data. However it is a bit more work up front. Setup is easy, but you have to create VO’s on both sides. Services_Webservice is just a standard SOAP wrapper for PHP. A little more involved to setup as it doesn’t have a default service broker (though it’s not hard to make one) but doesn’t require VO’s, but like I said, you have to parse through the XML in your client – not that it’s hard. Both methods involve creating PHP classes with public methods as your service interfaces. With AMFPHP you simply put these classes in the amfphp/classes directory. Services_Webservice you extend the Webservice class and load it through your broker. Hope this helps, Beau From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Mangal Sent: Monday, March 03, 2008 4:57 PM To: [email protected] Subject: [flexcoders] Access MySQL directly from Flex client I need to quickly put together a dashboard where the data will come from mysql. I would like to eliminate middile layer (if possible). The only mysql connector <a href='HYPERLINK "http://www.bobjim.com/2007/03/16/mysql-access-in-adobe-flex/"http://www.bob jim.com/2007/03/16/mysql-access-in-adobe-flex/'> article </a> I came across doesnt have any source code. So I am concluding that this is not possible (yet). I am looking for next best options (thinest possible middle layer, possibly Ruby/Groovy/perl/python?) =>Security and scalability are not of concern (as its within our safe intranet for a very small set of users). No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.3/1308 - Release Date: 3/3/2008 10:01 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.3/1308 - Release Date: 3/3/2008 10:01 AM
<<image001.jpg>>
<<image002.jpg>>
