advertisement

FlexCamp London

50 %
50 %
advertisement
Information about FlexCamp London

Published on August 28, 2008

Author: marcocasario

Source: slideshare.net

Description

Send me a mail if you want me to send you the demos for this presentation (http://casario.blogs.com)
advertisement

Marco Casario CTO – Comtaste http://casario.blogs.com

Who I am FlexCamp London CTO of Comtaste , RIA Development, Consulting and Training firm www.comtaste.com My Books AIR Cookbook Flex Solutions: Essential Techniques for Flex 2 and Flex 3 Developers Advanced AIR Applications My Blog and my contacts http://casario.blogs.com http://blog.comtaste.com

CTO of Comtaste , RIA Development, Consulting and Training firm

www.comtaste.com

My Books

AIR Cookbook

Flex Solutions: Essential Techniques for Flex 2 and Flex 3 Developers

Advanced AIR Applications

My Blog and my contacts

http://casario.blogs.com

http://blog.comtaste.com

AIR Cookbook Cook-off FlexCamp London Qualify for the Adobe AIR Cookbook Cook-off contest to celebrate the upcoming publication of the Adobe AIR Cookbook . Submit your best solutions to common AIR coding challenges for a chance to win: One pass to the Adobe MAX 2008 conference in San Francisco, and US$500 in O'Reilly books Every English-language Adobe Developer Library (ADL) book published by O'Reilly Media Five O'Reilly Media books of the winner's choice Community choice award: US$350 in O'Reilly Media books to the winner of the top-rated recipe during the contest period

Qualify for the Adobe AIR Cookbook Cook-off contest to celebrate the upcoming publication of the Adobe AIR Cookbook .

Submit your best solutions to common AIR coding challenges for a chance to win:

One pass to the Adobe MAX 2008 conference in San Francisco, and US$500 in O'Reilly books

Every English-language Adobe Developer Library (ADL) book published by O'Reilly Media

Five O'Reilly Media books of the winner's choice

Community choice award: US$350 in O'Reilly Media books to the winner of the top-rated recipe during the contest period

Agenda FlexCamp London We’ll talk about best practices using SQLite support in AIR with Flex I’ll show examples on : Create and open a database Synchronous and Asyncronous operations Insert records Display records Display records in a hierarchical mode Using SQL statements from an XML file Using the DAO Pattern We will move very quickly  I have only 20 min

We’ll talk about best practices using SQLite support in AIR with Flex

I’ll show examples on :

Create and open a database

Synchronous and Asyncronous operations

Insert records

Display records

Display records in a hierarchical mode

Using SQL statements from an XML file

Using the DAO Pattern

We will move very quickly  I have only 20 min

Demos FlexCamp London STOP TALKING DEMO NOW

DAO FlexCamp London Data Access Object is an object that provides an abstract interface to some type of data storage

Data Access Object is an object that provides an abstract interface to some type of data storage

DAO FlexCamp London Data Access Object is an object that provides an abstract interface to some type of data storage mechanism It provides some specific operations without exposing details of the database public function SalesManager() { sqlConnection = SQLManager.getConnection( "flexcamp" ); } public function getContact(contactId:int):SalesManagerVO { return getItem( "SELECT * FROM STUDENTS WHERE CONTACT_ID=? , studentID) as SalesManagerVO; }

Data Access Object is an object that provides an abstract interface to some type of data storage mechanism

It provides some specific operations without exposing details of the database

public function SalesManager()

{

sqlConnection = SQLManager.getConnection( "flexcamp" );

}

public function getContact(contactId:int):SalesManagerVO

{

return getItem( "SELECT * FROM STUDENTS WHERE CONTACT_ID=? , studentID) as SalesManagerVO;

}

DAO FlexCamp London Benefits of using DAO (as given by Sun): The benefits of using data access objects is the relatively simple and rigorous separation between two important parts of an application which can and should know almost nothing of each other, and which can be expected to evolve frequently and independently. Changing business logic can rely on the same DAO interface, while changes to persistence logic do not affect DAO clients as long as the interface remains correctly implemented.

Benefits of using DAO (as given by Sun):

The benefits of using data access objects is the relatively simple and rigorous separation between two important parts of an application which can and should know almost nothing of each other, and which can be expected to evolve frequently and independently.

Changing business logic can rely on the same DAO interface, while changes to persistence logic do not affect DAO clients as long as the interface remains correctly implemented.

What I don’t like FlexCamp London Inconsistency in the AIR and Flex APIs SQL does not use IResponder but it uses events and Responder as an argument FILE only uses events RPC (in Flex SDK) uses events or the IResponders class (with AsynchToken class)

Inconsistency in the AIR and Flex APIs

SQL does not use IResponder but it uses events and Responder as an argument

FILE only uses events

RPC (in Flex SDK) uses events or the IResponders class (with AsynchToken class)

Best Practices FlexCamp London Open a SQLConnection at the application startup (avoid delays when running statements) Use only one SQLStatement (with parameters) Execute the statements within an explicit transaction Do not concatenate user input into statement text to secure your app When embedding a SQLite DB into the AIR package the ApplicationFolder is read-only. So, copy the DB in a different folder (using the copyTo method)

Open a SQLConnection at the application startup (avoid delays when running statements)

Use only one SQLStatement (with parameters)

Execute the statements within an explicit transaction

Do not concatenate user input into statement text to secure your app

When embedding a SQLite DB into the AIR package the ApplicationFolder is read-only. So, copy the DB in a different folder (using the copyTo method)

we make it RIA Marco Casario CTO – Comtaste http://casario.blogs.com

Marco Casario CTO – Comtaste http://casario.blogs.com

Add a comment

Related pages

FlexCamp London ’08 – Sign Up Now | .: Blog.FlashGen.Com ...

If you are interested in learning more about Flex, are free from 2pm-8pm on 28th August 2008 and are in London (or can get there) then this is for you.
Read more

FlexCamp London, Aug 28th, 19/08/08, [Ux]

FlexCamp London, Aug 28th Writing about web page http://www.flexcamp.co.uk/ I really want to go to Flex Camp London but I can’t ...
Read more

Flex Camp London 28/08/08 - forum - developer Fusion

thought this event may be of interest Registration for Flex Camp London 08 is now open! www.flexcamp.co.uk Flex Camp London 08 is a FREE, community-run ...
Read more

FlexCamp - Adventures in Public Speaking | FlexMonkey

FlexCamp is a free - as in beer - Flex event being held in London on August 28. It has some great speakers, including representatives of Adobe, Tribal and ...
Read more

Flash Camp London ’09 Registration Open | .: Blog.FlashGen ...

Flash Camp London ’09 Registration Open. By Mike Jones ... (if FlexCamp London ’08 was anything to go by places will fill up fast). ...
Read more

FLEXCAMP DEVELOPMENT | Sjælland, Grevinge

★ Flexcamp Development ★ C/o Cc Camping Og Marine A/s, Grevinge, Sjælland ★ Development, Undervisningsforskning
Read more

Our Camps | Seaton Hackney Stables

SHS FlexCamp™ Seaton Hackney offers a Flexible Camp Program any day of the year! ... You are here: Home » Our Camps. Search. News & Press.
Read more

Alex Fell | LinkedIn

Alex Fell. Software Development Manager at YouView TV Limited. Location London, United Kingdom Industry Information Technology and Services
Read more