Home  >  

Simple Server Backends for Flex Database Applications

Author photo
AddThis Social Bookmark Button

Developing Rich Internet Applications that access databases always require a complex infrastructure in the background. The same applies to Flex.
Really?
What if data can be sent to the server in form of SQL queries without compromising security? This would certainly come with many benefits but also challenges and risks:

Benefits:

  • Server backend can be static and does not have to be modified for new applications
  • Developers can focus entirely on the frontend/GUI which saves a tremendous amount of time
  • New database applications can be created in hours or a few days even by novices
  • No complex infrastructure required

Challenges/Risks:

  • Server has to do session management so that users have to be logged in and authorized to be able to send SQL queries and receive its results
  • Server has to filter queries that delete tables or databases
  • Server has to filter queries to prevent SQL injection attacks (which certainly applies to other applications as well)
  • Access rights to enable/disable sections of an application are handled on the client
  • Access rights to permit access to data records is handled by the database

I would conclude that if the risks are being closely evaluated and appropriate steps are initially taken to implement solutions it is possible to create Flex (and other RIA) applications without any backend development for new projects at all.

At Comparatio we developed an Open Source framework that solves this task. The framework can access many different databases - even at the same time within the same application.
Everything is based on templates so that lists and forms look and work consistently across the entire application.
You can download the system and check out demos at www.comparatio.com . Any feedback is greatly appreciated!

Read more from Jan Poehland. Jan Poehland's Atom feed

Comments

1 Comments

Ka Wai Cheung said:

We're doing something very similar with the X2O Framework (www.x2oframework.com). It lets you create an object-relational data model through a web app. Then, it generates a remotely-hosted server-side infrastructure and AS3 value objects for a Flex or Flash app.

Since the entire platform is generated, all the connective parts are done for you. There's no SQL code, server-side code, integrating with a WSDL or having to parse data on the Flex side...you get to do read-writes on the generated value objects without having to go behind-the-scenes.

Please check it out...let me know your thoughts! http://www.x2oframework.com.

Leave a comment


Tag Cloud

iPad

What's your take on the iPad? (Putting aside the Flash/iPad flame war)

Answer

Latest Features

Recommended for You

@InsideRIA on Twitter

Archives

  • Or, visit our complete archive.  

About This Site

Welcome to the premiere community site for all things RIA sponsored by O'Reilly Media and Adobe Systems Incorporated.