Flexqueries.org

Flex is great, and I like it very much.

But according to Adobe's last whitepaper concerning the Flash platform, especially on mobile devices, especially++ on Apple's devices, I decided to move to HTML5, CSS and Javascript (prototype and scriptaculous powered).

I've been building and testing my own framework for almost one year. I just need a little cleanup before opening definitely the sources; it'll be done soon.

If you're interested, you can go there : http://dirtymarmotte.net (my french blog).

There is an online bookmarking application, build on the framework there : http://audacious.dirtymarmotte.net . Nobody can register, I'm the only allowed person to add bookmarks there. But you can contact me if you're interested into the sources, I'll give them with pleasure.

A wiki (in french for the moment) is available here : http://wiki.dirtymarmotte.net

Anyway, I think I'll be back on flexqueries.org because the concept is nice :)

Before going further in the tutorial, it's better to organize things and make the application modular. By modular, I mean the use of Flex modules, and the ability to load them from a main menu, pass parameters between modules...

The goal is to make each module as independant as it can be.

Here you go !

In this new tutorial article, I show how to apply modifications to our access rights matrix.

To achieve this, I used the SqlTransaction components. As its names tells, it allows us to execute several SQL statements in one transaction, and automatically rollbacks if a statement fails.

The tutorial has grown. You can follow it to build this access matrix : http://demo.flexqueries.org/useraccess.

The next step will be "implement the possibility to modify group access"

Well finally I'm going to restart this blog from scratch (only the blog, not the project!). So, here is the concept of Flexqueries.

Adobe Flex is a great framework, and Flex Builder a nice environment (I'm talking about FB4). My initial problem was to access a database a SIMPLE WAY from this wonderful environment. An option was to use coldfusion. But it's proprietary and unavailable on standard, cheap hosting platforms. PHP is.

So, I decided to implement my own Flex database environment, that is PHP friendly.

Flex + SQL queries = Flexqueries !

The server side is written in PHP. It uses adodb library to access the database, so many many interfaces are available. Basically, the server receives the query to execute (with its parameters), executes the SQL and returns the response formatted.

Response is then processed by the client side (Flex) and is available using easy-to-understand methods. Data can also be directly bound to fields like TextField, DateField, TextArea, RichTextEditor, and any kind of field we can imagine.

Well done, I almost lost my content after upgrading... I just have to rebuild everything now... Yeah.