Re: AW: Simple Database Architecture Suggestions Please

[Tintin <19...@googlemail.com>]

Thank you Olaf (sorry for the delay in replying) your reply was very helpful.

It is looking like PHP and MySQL is the best option for me. I've got to get
my head around how they talk to each other and allow data to flow from MySQL
to Flex objects. I'm unsure if I need (or should consider) a framework like
Zend or WebOrb to assist. It may be determined by my client's corporate
server restrictions.

Out of curiosity, as Flex matures under Apache's watch what is the way
forward for data-centric web applications? I can see clear trends in the
Microsoft space such as ASP.NET MVC and Entity Framework, I wondered where
Flex is heading and who is investing in cooperating with Flex developers to
provide well integrated data connectivity.

Regards

Chris



--
View this message in context: http://apache-flex-users.2333346.n4.nabble.com/Simple-Database-Architecture-Suggestions-Please-tp7726p7828.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.

Re: AW: Simple Database Architecture Suggestions Please

[Javier Guerrero García <ja...@gmail.com>]

Hi Tintin:

Do you need CRUD operations to be commanded from within your flex app, or
just "read-only" data?

If it's the latter, I would recommend you three incredible simple choices:

1. Use MS SQL "FOR XML" statement (6 chars), make an ASP that just executes
the query "FOR XML" (one line), invoque that ASP from your flex app with an
HTTP service with result="e4x" (one line) and just have fun with ecmascript
:)

2. If your data model allows it, use just plain simple CSV/JSON files for
the database, use a fairly simple PHP to grep/filter your results (2 lines,
1 to read the CSV, and 1 to grep it), and use flex builtin JSON.parse /
split("\n",split(",", ... )) (one line) in the result event on your flex
http service (one line) within the app.

3. Keep it in MySQL, use a simple PHP to query the database, return the
result using json_encode/implode("\n",implode(",",$result)), and back to
option 2 :)

I'm not sure if there's a MySQL equivalent for option 1, but if so, you
could also go for it :) If you keep everything one-line simple (without one
dozen frameworks and database abstraction layers inbetween), you will
develop and enhance the app faster and better in the future :)

Just my 2 cents :)


On Tue, Sep 2, 2014 at 6:21 PM, Tintin <19...@googlemail.com>
wrote:

> Thank you Olaf (sorry for the delay in replying) your reply was very
> helpful.
>
> It is looking like PHP and MySQL is the best option for me. I've got to get
> my head around how they talk to each other and allow data to flow from
> MySQL
> to Flex objects. I'm unsure if I need (or should consider) a framework like
> Zend or WebOrb to assist. It may be determined by my client's corporate
> server restrictions.
>
> Out of curiosity, as Flex matures under Apache's watch what is the way
> forward for data-centric web applications? I can see clear trends in the
> Microsoft space such as ASP.NET MVC and Entity Framework, I wondered where
> Flex is heading and who is investing in cooperating with Flex developers to
> provide well integrated data connectivity.
>
> Regards
>
> Chris
>
>
>
> --
> View this message in context:
> http://apache-flex-users.2333346.n4.nabble.com/Simple-Database-Architecture-Suggestions-Please-tp7726p7828.html
> Sent from the Apache Flex Users mailing list archive at Nabble.com.
>

Re: AW: AW: Simple Database Architecture Suggestions Please

[Tintin <19...@googlemail.com>]

Hello Olaf

Thank you very much for your comprehensive reply.

I did start using Flash Builder to develop my earlier Flex projects but I
have since switched to IntelliJ (by JetBrains) which I really like. I need
to establish if my client's server has, or could have installed, any Zend
software which may influence my development path.

AMF, from what I have read so far, does seem to provide very efficient
communication between the client and the server. I like your suggestion to
install just the Zend_AMF module, I will look into this more.

I no nothing about Node.js (this project is opening my eyes to all sorts of
technologies which is refreshing). Another subject to research sufficiently
to establish if I should rule it out or not!

I may take you up on the offer to contact you, what method is most
convenient with you?

Regards

Chris



--
View this message in context: http://apache-flex-users.2333346.n4.nabble.com/Simple-Database-Architecture-Suggestions-Please-tp7726p7843.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.

AW: AW: Simple Database Architecture Suggestions Please

[Krüger, Olaf <OK...@edscha.com>]

Hi,

> Out of curiosity, as Flex matures under Apache's watch what is the way forward for data-centric web applications?
There was a corporation with Adobe and Zend that created the "Flashbuilder for PHP", an approach to provide additionally IDE functionality including code generation to simplify Flex/PHP development.... but it's discontinued I think.
http://www.adobe.com/devnet/flash-builder/articles/flashbuilder-php-part1.html

Moreover there're some "outdated" open source projects with the goal to speed up the PHP/Flex development process, e.g.:
http://fredericbournival.com/sphex/
(Google with words like "PHP, Flex, ORM, Doctrine" to find other approaches)

>I'm unsure if I need (or should consider) a framework like Zend or WebOrb to assist. It may be determined by my client's corporate server restrictions.
If you'd like to connect your backend via AMF you should I think.
But these libraries are just PHP classes. Using Zend, there's no need to deal with the complete Zend framework, just consider the Zend_AMF module.
If you've questions regarding PHP/MySQL feel free to contact  me.

As an alternative to the venerable PHP/MySQL perhaps you 'd like to take a gander to hip technologies like node.js and noSQL databases (If your data model allows it)  ;-)
http://www.rivellomultimediaconsulting.com/node-js-for-flash-and-flex-introduction/
http://docs.mongodb.org/ecosystem/drivers/node-js/

Connect your AS3 application directly to  MongoDB  (Don't know if this project is still active):
https://code.google.com/p/jmcnet-full-mongo-flex-driver/


Olaf






Meet Edscha at IZB in Wolfsburg,
14.10.-16.10.2014; Hall 7, Stand 7219!
[Meet Edscha at IZB; Hall 7, Stand 7219!]<http://www.izb-online.com/>

________________________________

Edscha Holding GmbH
Sitz der Gesellschaft: Remscheid
Registergericht: Wuppertal, HRB 22889
Geschäftsführung: Francisco J. Riberas Mera, Francisco López Peña, David Vázquez Pascual, Torsten Greiner, Markus Kirchner, 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.