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

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

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

Application architecture/patterns/libraries

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

You can leave a comment, or trackback from your own site.

5 Comments so far

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

    links from TechnoratiSydney 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

  2. 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 […]

  3. November 9th, 2008 at 1:46 am
    Paul Robertson presents a detailed examination of AIR's SQLite database - AIR is reported to have said:

    Kramer auto Pingback[…] 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 […]

  4. 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:

    links from Technoratisession 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 :

  5. 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 […]

Add your comment





Comment notes

Please keep comments on topic. Comments that are inappropriate or offensive will be edited or removed.

Paragraphs and line breaks are automatically converted to HTML, and quotation marks are converted to “smart” quotes.

The following XHTML tags can be used: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> . All others will be removed.

Articles by Type

Articles by Topic

Random Reading

Currently...

Subscribe