Asql , What it means for developers
Categories: ASQL
I really think ASql is the most underrated , unnoticed actionscript library ever. Asql basically eliminates the middle tier in "most" web applications. The middle tier can be Coldfusion, Dot Net , or anything that is being used to communicate to your database to fetch query's and get results. This means two things, 1) If you are developing a small database interactive application and you don't know PHP,and you don't want to pay for Coldfusion hosting on your web host then ASQL is a godsend. Another thing (I am not sure about this) is that this will effectively speed up your query's, because instead of flex having to communicate to coldfusion, coldfusion cfcs processing the request to the database and then the database returning the results to the method called by Coldfusion, then the method doing what it is suppose to do, and finally returning what the user wanted back to flex, instead of this process , using ASQL Flex only has to communicate to the database and the database returns the data, after the AVM2 is so fast that it can do the processing of the query in a jiffy.
What I want to do with ASQL is help the developer (Mooska) out and make it much better, I have started modifying the code (ASQL IS OPEN SOURCE!), however i really want to get involved in this project. If the developer of ASQL is reading this then comment and well get in touch (If you want).
Links
http://asql.mooska.pl/
What I want to do with ASQL is help the developer (Mooska) out and make it much better, I have started modifying the code (ASQL IS OPEN SOURCE!), however i really want to get involved in this project. If the developer of ASQL is reading this then comment and well get in touch (If you want).
Links
http://asql.mooska.pl/
Posted by Faisal at 5:35 PM | Link | 7 comments
Subscription Options
You are not logged in, so your subscription status for this entry is unknown. You can login or register here.
Re: Asql , What it means for developers
As I talk with mooska most PITA in this project is sending large BLOBs over flash sockets. You can't get info about it's progress, so with large data you're in (_!_) ;)
Posted by maliboo on January 4, 2008 at 6:40 PM
Re: Asql , What it means for developers
Hello
Asql lacks of good betatests and small modifications. Right now I lack od time, to move it on, so project stays as it was. Feel free to mail me, I was going to put it on google code, so might do so if you wish.
Asql lacks of good betatests and small modifications. Right now I lack od time, to move it on, so project stays as it was. Feel free to mail me, I was going to put it on google code, so might do so if you wish.
Posted by mooska on January 4, 2008 at 6:54 PM
Re: Asql , What it means for developers
Yup, i sent you an email, looking forward to your reply :D
Posted by Faisal on January 4, 2008 at 8:18 PM
Re: Asql , What it means for developers
I think the reason many people aren't using it is that without a middle tier, surely direct communication/authentication with a database means a security risk as the databases username/password are contained within the (decompilable) swf?
Posted by Mike D on January 5, 2008 at 9:00 AM
Re: Asql , What it means for developers
Sure, but you can always set restricted access for such kind of "public" user... R/O for eg.
Posted by maliboo on January 5, 2008 at 6:55 PM
Re: Asql , What it means for developers
You can also encrypt the swf, I am not sure if flex builder doesnt even allow encrption, but when you have your swf , import it into Flash cs3 and publish the swf with encryption on.
Posted by Faisal on January 5, 2008 at 7:06 PM
Re: Asql , What it means for developers
There is no way I am letting anybody on the internet connect directly to my database server.
Posted by Tom Chiverton on January 7, 2008 at 12:00 PM