You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@flex.apache.org by Arne Broedel <ar...@googlemail.com> on 2013/08/25 17:33:21 UTC
Preferred way of connecting to MySql
Hello,
I have a Flex Application that is running on Desktop with AIR and a Sqlite
database.
No I want to change it to work in the browser as a webapplication using
MySql.
What is the most common/easiest/fastest/flexible way to to this.
Would you prefer for example php with amfphp/zendamf or better prefer php
with json?
The flashbuilder datawizard and most adobe tutorials use zendamf but as far
as I know it wont be maintained anymore.
Or would you suggest to use Java, Hibernate...?
Something totally different?
My knowledge of PHP and Java is equally low I would guess.
Thank you
Re: Preferred way of connecting to MySql
Posted by Arne Broedel <ar...@googlemail.com>.
thank you all.
Many different ways to go.
I will definitely give weborb a try.
2013/8/26 Krüger, Olaf <OK...@edscha.com>
> Hi,
> I'm using ZendAmf for a long time, but unfortunately it's not part of
> ZendFramework2 and it seems that ZendAmf is not maintained anymore.
> But the ZF1 version still runs without problems!
>
> Another alternative could be AmfPHP.
> This could be interesting for you:
> http://www.silexlabs.org/136374/the-blog/amfphp-survives-zend-amf/
> http://www.silexlabs.org/amfphp/
>
> Olaf
>
>
> -----Ursprüngliche Nachricht-----
> Von: Arne Broedel [mailto:arne.broedel@googlemail.com]
> Gesendet: Sonntag, 25. August 2013 17:33
> An: users@flex.apache.org
> Betreff: Preferred way of connecting to MySql
>
> Hello,
> I have a Flex Application that is running on Desktop with AIR and a Sqlite
> database.
> No I want to change it to work in the browser as a webapplication using
> MySql.
> What is the most common/easiest/fastest/flexible way to to this.
> Would you prefer for example php with amfphp/zendamf or better prefer php
> with json?
> The flashbuilder datawizard and most adobe tutorials use zendamf but as
> far as I know it wont be maintained anymore.
> Or would you suggest to use Java, Hibernate...?
> Something totally different?
> My knowledge of PHP and Java is equally low I would guess.
>
> Thank you
>
> ________________________________
>
> Edscha Holding GmbH
> Sitz der Gesellschaft: Remscheid
> Registergericht: Wuppertal, HRB 22889
> Geschäftsführung: Francisco J. Riberas Mera, Juan Maria Riberas Mera,
> Francisco López Peña, David Vázquez Pascual, Torsten Greiner, Mario
> Eikelmann, Hans-Peter Schulz und Volker Weiss
>
> Vertretungsberechtigt sind nur Geschäftsführer und schriftlich
> Bevollmächtigte.
>
> Solely Managing Directors or employees with a written proxy have got power
> of representation.
>
> Der Inhalt dieser E-Mail einschließlich etwaiger beigefügter Dateien ist
> vertraulich und nur für den Empfänger bestimmt. Sollten Sie nicht der
> bestimmungsgemäße Empfänger sein, ist Ihnen jegliche Offenlegung,
> Vervielfältigung, Weitergabe oder Nutzung des Inhalts untersagt. Bitte
> informieren Sie in diesem Fall unverzüglich den Absender und löschen Sie
> die E-Mail einschließlich etwaiger beigefügter Dateien von Ihrem System.
> Vielen Dank.
>
> The contents of this e-mail including any attachments are confidential and
> may be legally privileged. If you are not the intended recipient, any
> disclosure, copying, distribution or use of its contents is strictly
> prohibited, and you should please notify the sender immediately and then
> delete this e-mail including any attachments from your system. Thank you.
>
AW: Preferred way of connecting to MySql
Posted by Krüger,
Olaf <OK...@edscha.com>.
Hi,
I'm using ZendAmf for a long time, but unfortunately it's not part of ZendFramework2 and it seems that ZendAmf is not maintained anymore.
But the ZF1 version still runs without problems!
Another alternative could be AmfPHP.
This could be interesting for you:
http://www.silexlabs.org/136374/the-blog/amfphp-survives-zend-amf/
http://www.silexlabs.org/amfphp/
Olaf
-----Ursprüngliche Nachricht-----
Von: Arne Broedel [mailto:arne.broedel@googlemail.com]
Gesendet: Sonntag, 25. August 2013 17:33
An: users@flex.apache.org
Betreff: Preferred way of connecting to MySql
Hello,
I have a Flex Application that is running on Desktop with AIR and a Sqlite database.
No I want to change it to work in the browser as a webapplication using MySql.
What is the most common/easiest/fastest/flexible way to to this.
Would you prefer for example php with amfphp/zendamf or better prefer php with json?
The flashbuilder datawizard and most adobe tutorials use zendamf but as far as I know it wont be maintained anymore.
Or would you suggest to use Java, Hibernate...?
Something totally different?
My knowledge of PHP and Java is equally low I would guess.
Thank you
________________________________
Edscha Holding GmbH
Sitz der Gesellschaft: Remscheid
Registergericht: Wuppertal, HRB 22889
Geschäftsführung: Francisco J. Riberas Mera, Juan Maria Riberas Mera, Francisco López Peña, David Vázquez Pascual, Torsten Greiner, Mario Eikelmann, Hans-Peter Schulz und Volker Weiss
Vertretungsberechtigt sind nur Geschäftsführer und schriftlich Bevollmächtigte.
Solely Managing Directors or employees with a written proxy have got power of representation.
Der Inhalt dieser E-Mail einschließlich etwaiger beigefügter Dateien ist vertraulich und nur für den Empfänger bestimmt. Sollten Sie nicht der bestimmungsgemäße Empfänger sein, ist Ihnen jegliche Offenlegung, Vervielfältigung, Weitergabe oder Nutzung des Inhalts untersagt. Bitte informieren Sie in diesem Fall unverzüglich den Absender und löschen Sie die E-Mail einschließlich etwaiger beigefügter Dateien von Ihrem System. Vielen Dank.
The contents of this e-mail including any attachments are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then delete this e-mail including any attachments from your system. Thank you.
Re: Preferred way of connecting to MySql
Posted by Stephen C <st...@stephenjc.com>.
I originally wrote a restful api with php and mysql to interface with my
air app via XML. It was easy enough to write. I have recently moved to
parse.com as my cloud db.
Thank You,
Stephen C
-All of my email addresses go to the same place
-Save Paper, think before you print
-PGP Public Key<https://docs.google.com/file/d/0B0JeFeQj5XjkZC0talFuRExyc0E/edit?usp=sharing>
On Sun, Aug 25, 2013 at 11:33 AM, Arne Broedel
<ar...@googlemail.com>wrote:
> Hello,
> I have a Flex Application that is running on Desktop with AIR and a Sqlite
> database.
> No I want to change it to work in the browser as a webapplication using
> MySql.
> What is the most common/easiest/fastest/flexible way to to this.
> Would you prefer for example php with amfphp/zendamf or better prefer php
> with json?
> The flashbuilder datawizard and most adobe tutorials use zendamf but as far
> as I know it wont be maintained anymore.
> Or would you suggest to use Java, Hibernate...?
> Something totally different?
> My knowledge of PHP and Java is equally low I would guess.
>
> Thank you
>
Re: Preferred way of connecting to MySql
Posted by Cortlandt Winters <co...@cortwinters.net>.
I'd look into using weborb <http://www.themidnightcoders.com/> for
something like this.
It's great glueware
In particular my first thought would be to
1) export your sqllite database as a schema for mysql,
2) then use their wizard to create a mysql database
3) they will generate and deploy both the server side code, which can be
java, .NET, PHP or rails, whichever you like, and generate the actionscript
to access the new services. I can only vouch for the java server side piece
personally, but it was a brilliant piece of work with a great interface.
You really don't even need to know java in order to create a nice backend
with it, but if you do you can add your own or other java services to it
easily as well. They will even generate a flex example app to show you the
syntax to use for the service.
4) then you need to copy and paste their generated code into your app and
reglue your calls from sqllite to use the service
5) and finally, if you need to maintain the data, have your flex app read
the sqllite database data and seed the new mysql database from the old data
via the new calls.
In fact if you want to transition to an html client some day in the
future. I believe they have an AMF bridge for javascript, so you can still
get the awesome performance of AMF that Peter is referring to.
It's not free, but they have very reasonable licensing and offer an amazon
cloud service.
Good luck with the transition.
On Sun, Aug 25, 2013 at 5:27 PM, Peter Ginneberge <p....@gmail.com>wrote:
> IMO, amf (remoting) is the way to go, simply because you get to send back
> and forth typed objects (DTO's, VO's) and no need to convert from one
> format to another (json to ActionScript, ActionScript to json, xml to
> ActionScript, ActionScript to xml etc..).
>
> regards,
> Peter
>
>
> ----- Original Message ----- From: "Arne Broedel" <
> arne.broedel@googlemail.com>
> To: <us...@flex.apache.org>
> Sent: Sunday, August 25, 2013 5:33 PM
> Subject: Preferred way of connecting to MySql
>
>
>
> Hello,
>> I have a Flex Application that is running on Desktop with AIR and a Sqlite
>> database.
>> No I want to change it to work in the browser as a webapplication using
>> MySql.
>> What is the most common/easiest/fastest/**flexible way to to this.
>> Would you prefer for example php with amfphp/zendamf or better prefer php
>> with json?
>> The flashbuilder datawizard and most adobe tutorials use zendamf but as
>> far
>> as I know it wont be maintained anymore.
>> Or would you suggest to use Java, Hibernate...?
>> Something totally different?
>> My knowledge of PHP and Java is equally low I would guess.
>>
>> Thank you
>>
>>
>
Re: Preferred way of connecting to MySql
Posted by Peter Ginneberge <p....@gmail.com>.
IMO, amf (remoting) is the way to go, simply because you get to send back and forth typed objects (DTO's, VO's) and no need to
convert from one format to another (json to ActionScript, ActionScript to json, xml to ActionScript, ActionScript to xml etc..).
regards,
Peter
----- Original Message -----
From: "Arne Broedel" <ar...@googlemail.com>
To: <us...@flex.apache.org>
Sent: Sunday, August 25, 2013 5:33 PM
Subject: Preferred way of connecting to MySql
> Hello,
> I have a Flex Application that is running on Desktop with AIR and a Sqlite
> database.
> No I want to change it to work in the browser as a webapplication using
> MySql.
> What is the most common/easiest/fastest/flexible way to to this.
> Would you prefer for example php with amfphp/zendamf or better prefer php
> with json?
> The flashbuilder datawizard and most adobe tutorials use zendamf but as far
> as I know it wont be maintained anymore.
> Or would you suggest to use Java, Hibernate...?
> Something totally different?
> My knowledge of PHP and Java is equally low I would guess.
>
> Thank you
>
Re: Preferred way of connecting to MySql
Posted by Matthew Weir <ma...@yahoo.com>.
I would use PHP with codeigniter framework and then return the result as JSON.