Thanks Beau, Apart from the concerns that you have pointed out, we saw another concern around connection leak (each client needs a connection). So this is what we ended up doing. 1. Hourly Cron job on database server which spits out the xml (straight from mysql) and ftp to a secure location. 2. Flex client read those secure files and parses them and draws the charts and datatable in dashboard with configurable refresh rate.
Shailesh Now, Test Management <http://www.getzephyr.com> is a breeze. --- In [email protected], "Beau Scott" <[EMAIL PROTECTED]> wrote: > > 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 >
