Topic: Tutorials

Simple ActionScript 3 animation examples

Posted July 20, 2010 9:20 am
Filed under: AS3, ActionScript, Animation, Articles by Paul, Tutorials

Last week I spent a little time teaching some of the newer developers in our office about scripted animation in ActionScript 3. I put together a few simple demos for them, and I thought I might as well share them with the world.
Note that these are basic demos so if you know pretty much anything […]

» Keep reading Simple ActionScript 3 animation examples

2 comments so far

Data “paging” in AIR SQLite

Posted April 7, 2010 12:25 pm
Filed under: AIR, Articles by Paul, Projects, SQL, Tutorials, local SQL database

I got an interesting question a few days ago that I thought I’d share:
My application has thousands of records in one particular table that I need to populate the display with. I was wondering if I can implement paging to speed up the retrieval of those records?
In fact he specifically wanted to know if it […]

» Keep reading Data “paging” in AIR SQLite

2 comments so far

Multi-table INSERT using one SQL statement in AIR SQLite

Posted November 30, 2009 11:00 pm
Filed under: AIR, Articles by Paul, SQL, Tutorials, local SQL database

This article describes a way that you can use a single INSERT statement to add data to multiple tables in the SQL dialect supported by the SQLite engine in Adobe AIR.
Normally in SQL, including in AIR’s built-in SQLite database engine, you can only add data to one table at a time using an INSERT statement. […]

» Keep reading Multi-table INSERT using one SQL statement in AIR SQLite

2 comments so far

New article “Programming with the Vector class”

Posted September 14, 2009 4:40 pm
Filed under: ActionScript, Articles by Paul, Tutorials, Vector (typed arrays), Writing

Several months ago (probably almost a year ago) I wrote an article for the Adobe Developer Connection titled “Programming with the Vector class.” As you can surely guess, the article is about the Vector class, which provides typed array functionality (an array whose elements are required to all be instances of the same data type). […]

» Keep reading New article “Programming with the Vector class”

no comments so far

AIR 1.5 encrypted SQLite database — how to use it, best practices, and new projects

Posted November 18, 2008 1:30 am
Filed under: AIR, Articles by Paul, Life at Adobe, Projects, Tutorials, Writing, local SQL database

Over a year ago I described a potential area of concern for using a SQLite database with an AIR application — because all apps use the same database engine, any AIR app can read any other app’s database (as long as it can find the database file).
As you may have heard among all the news […]

» Keep reading AIR 1.5 encrypted SQLite database — how to use it, best practices, and new projects

13 comments so far

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

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

7 comments so far

Slides and files for “AIR, Windows, Menus, and the System Tray”

Posted June 4, 2008 4:24 pm
Filed under: AIR, Articles by Paul, Flex, Presentations, Tutorials

As I’ve mentioned before, a couple of weeks ago at the Webmaniacs conference I presented a session titled “Adobe AIR: Windows, Menus, and the System Tray” (and I also presented the same material in a partially different form over the course of two SilvaFUG meetings. The presentation covers those three aspects of Adobe AIR, specifically […]

» Keep reading Slides and files for “AIR, Windows, Menus, and the System Tray”

no comments so far

New Adobe Dev Center articles (Flash deep-linking and Flash CS3 DataGrid)

Posted November 13, 2007 11:14 am
Filed under: AS3, ActionScript, Articles by Paul, Flash, Tutorials, Writing

Several months ago I was asked to re-purpose two of my previous articles from this site for publication on the Adobe Developer Center (now renamed as the “Adobe Developer Connection”). The first one was published in September 2007, and the second was just published yesterday. So in a way this is sort of a revisiting […]

» Keep reading New Adobe Dev Center articles (Flash deep-linking and Flash CS3 DataGrid)

comments closed

AIR embedded SQL database: What’s new in beta 2

Posted October 9, 2007 4:41 pm
Filed under: AIR, AS3, ActionScript, Articles by Paul, JavaScript, SQL, Tutorials, local SQL database

Now that the roar of MAX is over, and since AIR public beta 2 is now available on Adobe Labs, I thought I’d highlight what’s new in beta 2 specifically around the embedded SQL database in AIR:

Synchronous database operations
Schema API (database instrospection)
Additional data types
Other new documentation
Bug fixes

Synchronous database operations
From the various public and internal feedback […]

» Keep reading AIR embedded SQL database: What’s new in beta 2

6 comments so far

Problem (and solution): Any AIR app can read any other app’s databases

Posted June 21, 2007 11:06 am
Filed under: AIR, Application Design, Articles by Paul, Tutorials, local SQL database

In a side note on a recent post about the AIR functionality for working with local SQL databases, Tim Anderson raised some concerns about the security model for AIR local SQL databases, that I thought would be valuable to discuss more.
Tim also raises other concerns which aren’t so much issues to keep in mind when […]

» Keep reading Problem (and solution): Any AIR app can read any other app’s databases

9 comments so far