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.246.n4.nabble.com/Simple-Database-Architecture-Suggestions-Please-tp7726p7828.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.
