Is it possible to directly access MySql databases through an Adobe AIR/Flex
application?
If not, what is the next best alternative?
Mysql – Accessing thesql from Adobe flex/AIR
adobeairapache-flexMySQL
Related Topic
- Difference between Adobe AIR and FLEX
- Mysql – Create new user in MySQL and give it full access to one database
- Mysql – Duplicating a MySQL table, indices, and data
- Actionscript – How to pass “Null” (a real surname!) to a SOAP web service in ActionScript 3
- MySQL error code: 1175 during UPDATE in MySQL Workbench
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
I'd have to disagree (though respectfully!) with Abdullah that building an ODBC client into AIR would "cause wierd problems and open up security issues" -- that's often how it's done (e.g., Java and .NET, both of whose runtimes package various ODBC clients) -- but both posters are right: the only way's coding some sort of a service interface into your AIR application (using Flex classes like WebService, HTTPService, and so on) and a complementary server-side interface (e.g., REST via PHP, which would then connect up with your MySQL database). For simple apps, it can be a bit of a pain, but for the moment, that's all we gots. :)
Best of luck!