(My)SQL in Flex - any good libraries?

views:

answers:

+1 Q:

(My)SQL in Flex - any good libraries?

Hello!

I need to develop a small Flex application that needs to access a MySQL database. Since I have little experience in server-side Java, PHP programming I would prefer to use a library/framework that allows me to write SQL queries in ActionScript/MXML.

After a bit of research, I have come across two 3rd party libraries, AS3FlexDB(free) and Adobe Flex Connector for MySQL(45$). Initial tests with AS3FlexDB are promising, but I'm a bit afraid that I'll start to work on the project only to find out that I need a full-fledged back-end after all.

Do any of you have experience with these tools? If so, are they stable enough for production? Are there any such libraries for other relational databases(PostgreSQL in particular)?

Thank you!

Lawrence

+1 A:

this and CRUD like this and read this
AS SQL Lib and another one CRUD
and final happiness

Eugene 2010-09-02 11:23:29

Thank you, these are useful.

Lawrence 2010-09-02 11:34:10

+1 A:

Flex is a UI Framework and is not designed for database interaction. I strongly recommend you reconsider the approach and learn a server side language. You'll thank yourself in the long run.

that said, another option is FlexSQL. This is the first time I've heard of the two you mentioned.

I have no idea why people keep building these libraries. It's like trying to use a screwdriver and nails together. It is, in theory possible but better tools exist.

www.Flextras.com 2010-09-02 11:24:24

I realize that I will eventually have to learn a server-side language and look forward to that, but I need to develop a prototype in a few days for this project, thus the dreaded shortcut. Thanks for the tips!

Lawrence 2010-09-02 11:33:43

If it is just a prototype; prototype it with fake data. I strongly encourage against going down the route you're going down. is it quicker to drive in a nail with a screwdriver? Or to learn how to use a hammer?

www.Flextras.com 2010-09-02 12:58:11

I will definitely consider learning PHP if the prototype gets picked up and evolves into a real app. I will have to see if "faking data" is acceptable at this stage. Thanks again!

Lawrence 2010-09-02 13:20:07

go to the side of AMF serialization and imho BlazeDS too, cause using java you'll save your time. :)

Eugene 2010-09-02 14:50:34

ansaurus

tags:

views:

answers:

(My)SQL in Flex - any good libraries?

related questions