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 <1955.mille.mig...@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.
>
