In my MAX session called “Liberate your Data with AIR”, I presented different approaches to access local data using the SQLite database access API in AIR.
The list of approaches included:
- “SQL in View”
- Data Access Object (DAO) pattern
- Using an Object Relational Mapping (ORM) framework
I demonstrated a version of inSync (a simple contact management application) built with each of these approaches. I’m dedicating one blog post to each approach. This first post is focused on the “SQL in View” approach. To spice things up just a little bit, inSync also demosntrates how to take a picture of a contact using your webcam and store it in the SQLite database as a blob.
Install inSync Local SQL Edition:
NOTE: this application uses the same skin and overall context as a sample I posted previously to illustrate offline data synchronization using LCDS, but the implementation is entirely different: No LCDS here… just local data access.
Click here to download the source code. You can also right-click the app and select View Source to view the source code and download the application.
Using the “SQL in View” approach, you embed SQL statements as needed in View components. In this example the ContactForm component has create, update, and delete methods with the appropriate embedded SQL statements to insert, update, and delete a contact in the database. This approach works for quick prototyping, but is generally a bad practice. When you mix view logic and data access logic in the same component, neither the view logic, nor the data access logic is reusable: you can’t reuse the view with a different way to access your data, and you can’t reuse your data access logic with a different view.
I provide this approach here as a quick way to get acquainted with the database access API in AIR. For real life implementations, a more partitioned approach such as the DAO pattern or an ORM framework is of course highly recommended. Stay tuned for an example of approaches 2 and 3.
5 Comments
Hey Chris, this is definitely a great idea! One could also put additional info beside the pic.
hej, I am using AIR and SQLite to develop some small app.
I created db in sqliteSpy created all tables there and connected to it asynchronously. all selects statement that are not using group by or left join are executed well.
OTHERWISE looking with debugger sqlresult.data seems to have all data I selected but when I try to trace them or assign to my valueobject all I have are null-s or NaN-s.
I have posted the problem on 2 user group few days ago without respons
http://groups.google.com/group/flex_india/browse_thread/thread/1da40062e78b32a6#
maybe you can help me
I am all new to this, but have to create a directory in AIR, i was wondering if “insync” completely open source and can be used for commercial app. I do not know what are the copyright guide lines for this?
Hey Chris, this is definitely a great idea! One could also put additional info beside the pic.
şk pğ hk
2 Trackbacks
[...] first version of our contact management application introduced us to the database access API in AIR. However, the lack of “application [...]
[...] Object (ContactDAO). This separation of concerns represented a major improvement compared to our first approach. The remaining limitation we identified was the amount of SQL we had to write [...]