360|Flex slides for “AIR SQLite: An optimization conversation”

Posted August 22, 2008 5:16 pm
Filed under: AIR, Articles by Paul, Flex, Frameworks, local SQL database, Presentations, Projects, SQL, Tutorials

Updates (Oct. 30, 2008): The video of my presentation has been posted, so I added a link to it at the bottom of this post. Also, I just learned about another AIR-based SQLite admin tool which looks interesting, so I added it to the list of resources even though it’s obviously not discussed in the presentation.

As I mentioned briefly before, this week I presented at the 360|Flex San Jose (August 2008) conference. My presentation was titled “Adobe AIR SQLite: An optimization conversation.” As I mentioned in the presentation, the term “optimization” could mean a few different things — for example, optimization meaning improving performance, or optimization meaning improving developer productivity. While my presentation focused mostly on the first type of optimization, I included suggestions for tools, libraries, and strategies that fall in the “developer productivity” type of optimization as well.

Anyway, as always I’m happy to make my presentation materials available. Here are the slides (with some notes) from my presentation:

“Adobe AIR SQLite: An optimization conversation” slides (PDF in .zip - 504kb)

I don’t really have any specific code examples, apart from what’s in the slides, so there’s no “source code” download. However, I did link to a lot of external tools and resources (including a few of my own). To save you the trouble of digging into the PDF, here are the links:

Tools

Cristophe Coenraets’ “SQLite Admin”
My tool for testing queries
“Lita” by David Deraedt (I learned about this one after the presentation, so it’s not discussed in my slides/video, but I thought it’d be worth mentioning anyway.)

Application architecture/patterns/libraries

SQLite MXML wrapper classes (Peter Elst)
Data access layer (Brandon Ellis)
asqlib SQL statement generator (Miran Loncaric)
“Command” classes (me) as demonstrated by my AddressBook sample application
AIR ActiveRecord source and blog post explaining its usage (Jacob Wright)
AIR SQLite Cairngorm services (Eric Feminella)
Connection and statement pools, mentioned (with source code) in the article User experience considerations with SQLite operations (Daniel Rinehart)

Finally, as you may have heard, Adobe sponsored the recording of every presentation at 360|Flex, and they’re all going to be made available free of charge via a channel in Adobe Media Player. They’re rolling them out in phases, and mine isn’t available yet. When it is, I’ll update this post with the video as well. Update: the video is now available on Ted Patrick’s blog as well as in Adobe Media Player.

In the mean time, 360|Flex was full of awesome presentations. I wasn’t able to get to all the ones I wanted to see, due to conflicts and me trying to finish up preparation for my presentation. So I’m going to be spending some time watching many of those videos as well. If you’d like to see the videos, Ted Patrick has posted instructions on his blog:

How to view 360|Flex San Jose 8/08 session videos in Adobe Media Player

Comments/trackbacks are closed for this post.

9 Comments so far

August 23rd, 2008 at 12:51 am
The Warp is reported to have said:

Sydney Opera House Vector360|Flex slides for ‚ÄúAIR SQLite: An optimization conversation‚ÄùAIR Tip 13 - Number of Lines in a Text File New Gumbo Specs posted: Gumbo Text Primitives (TextBox, TextGraphic, and TextView) Microsoft Photosynth
November 9th, 2008 at 1:38 pm
For Evolution On AIR - Toutes les applications et l‚Äôactualit?© d‚ÄôAdobe AIR en un seul blog is reported to have said:

session de Paul Robertson sur la manipulation des bases de donn?©es ?† l‚Äôaide des fonctions SQLite de Air (session 360Flex). Vid?©o aussi visible sur l‚ÄôAMD et sur le nouveau blog de l‚ÄôAdobe Air Team. Les slides de la session sont disponibles ?†cette adresse. Ces billets parlent du m?™me sujet :
October 4th, 2008 at 1:34 pm
WS-Blog » New Mate extensions for using AIR and SQLite: “SQLService + SQLServiceInvoker” is reported to have said:

[…] transactions for batch INSERT/UPDATE/DELETE operations based on the great tips using AIR and SQLite by Paul […]
November 9th, 2008 at 1:46 am
Paul Robertson presents a detailed examination of AIR's SQLite database - AIR is reported to have said:

[…] AIR’s SQLite database, recently presented a very insightful session titled at 360|Flex titled "AIR SQLite: An optimization conversation". If you are interested in learning more about AIR’s SQLite database, this video presents a […]
November 10th, 2008 at 1:47 am
All about AIR SQLite | Adobe AIR Tutorials is reported to have said:

[…] more details¬†¬†on SQLite & List of reources […]
February 16th, 2009 at 3:49 am
Recent Links Tagged With "command" - JabberTags is reported to have said:

[…] public links >> command 360|Flex slides for ‚ÄúAIR SQLite: An optimization conversation‚Äù Saved by macpete on Thu 05-2-2009 Command and Conquer 3: Kane‚Äôs Wrath Saved by YetiLuigi on Mon […]
May 20th, 2010 at 5:43 pm
herve leger dress is reported to have said:

Vid?©o aussi visible sur l‚ÄôAMD et sur le nouveau blog de l‚ÄôAdobe Air Team.
July 28th, 2011 at 11:51 pm
Dimitri K is reported to have said:

Hi Paul, thanks for the useful slides.
Hi think, you may have a few new visits of this post because it seems SQLite perf on AIR for iOS is not very good (one SELECT query of mine use 10”, only for a “WHERE foreignKey=id” on a 30k table, for 20 results, iPad2. The query is instantaneous on desktop.

I also wanted to say that you can watch your prez video on AdobeTv (the Ted P.’s link isn’t working though.

Thanks again.
November 12th, 2011 at 6:59 pm
Confluence: Tech Stuff is reported to have said:

AIR application resources, tutorials, and collections of Adobe AIR applications…

Resources Resources, tutorials and collections of Adobe AIR applications. # airapps Wiki…