Topic: local SQL database

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

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

8 comments so far

Peter Elst, an excellent Flex/Flash developer and speaker, just finished touring as part of the on AIR Europe tour. He’s posted his slides and sample applications from his presentation, “Introduction to SQLite in Adobe AIR”. Looks like it was a great presentation, and even without hearing him he’s got some nice samples to dig through.

(via Twitter from Peter himself)

Adobe AIR 1.0 ships! SQL changes, and other thoughts

Posted March 24, 2008 2:04 pm
Filed under: AIR, Articles by Paul, Flex, local SQL database, Opinions

Now that Adobe AIR 1.0 is in the wild, I wanted to post an update about changes that happened with the local SQL database functionality between beta 3 and the final release. Plus, I’ve had some general thoughts about the release of the software that I thought I’d share. For some reason, the final time […]

» Keep reading Adobe AIR 1.0 ships! SQL changes, and other thoughts

5 comments so far

AIR beta 3 and local SQL database changes

Posted December 18, 2007 12:55 pm
Filed under: AIR, Articles by Paul, Flex, local SQL database, Opinions, Writing

Note: Sorry for the delay on this article. I composed this article a couple of weeks ago, and then I got busy with work and holidays and I forgot and didn’t publish it until now =( If you’ve been following my posts on AIR and the SQL database functionality, you may have noticed a trend: […]

» Keep reading AIR beta 3 and local SQL database changes

3 comments so far

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

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

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

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

6 comments so far

Justin (“AlternateIdea”) has a nice, fairly technical write up of dealing with asynchronous operations when you’re using the AIR SQL database with JavaScript.

I admit, my JavaScript is much rustier than my ActionScript/Flex, so I’m glad to see these sorts of things — it helps me to see what patterns and approaches work for the larger-than-you-might-imagine JavaScript AIR developer audience.

Update: added links, so that you can actually find the article (Doh!)

Dan Thomas (“Danny-T”) has written up a nice concise intro to database concepts, geared toward working with databases in AIR (more…)

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, local SQL database, Tutorials

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

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

9 comments so far

Why doesn’t Adobe’s AIR dev guide mention SQLite? A response to Tim Anderson

Posted June 19, 2007 11:11 pm
Filed under: AIR, Articles by Paul, local SQL database, Opinions, Writing

Yesterday Tim Anderson asked a question: “Why doesn’t Adobe’s AIR dev guide mention SQLite?” As the author of the “Working with local SQL databases” chapter in the AIR Developers Guide that Tim refers to, as well as the related sections of the AIR language reference, I guess I know better than most people the answer […]

» Keep reading Why doesn’t Adobe’s AIR dev guide mention SQLite? A response to Tim Anderson

17 comments so far

If you’re looking to simplify the local database access part of your AIR app, this might be the ticket. Brandon Ellis has written a no-frills wrapper class for AIR local database operations. The biggest benefit it provides is that if you add, delete, or update data in a table, it automatically updates whatever component is displaying the data from the related SELECT statement.

The part that caught my eye the most was that the wrapper class doesn’t dispatch any events to notify the view when the operations have completed. How, I asked myself, does it notify the view when the updated data loads? After a few seconds I realized the answer — it’s the magic of Flex data binding. The DataAccess class exposes the SELECT results as a property (dbResult) that’s a Flex ArrayCollection, and it’s marked [Bindable]. A Flex control can bind to that property as a data provider, and whenever the DataAccess instance reloads its data and updates the ArrayCollection. Then the Flex framework takes over, and the view gets updated automatically. Pretty slick; and it definitely saves a lot of event-handling code. So I guess seeing this in action gave me further appreciation for the power of data binding.

It has a couple of minor issues that I’ve noted in the comments on that page (but mostly they should be fairly easy to fix, if Brandon or someone else decides to do so).

(via: Greg Hamer)

« Previous Page