Topic: SQL

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”

5 comments so far

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

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…)

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)

AIR, local SQL databases, and my role

Posted June 11, 2007 5:37 pm
Filed under: AIR, AS3, ActionScript, Articles by Paul, SQL, Writing, local SQL database

As everyone knows, today Adobe released a public beta of AIR (formerly “Apollo”). As you likely know, since it was announced last week, one of the big new features in this release is an integrated database engine that allows AIR applications to create and use local SQL databases. I’m really excited about this, both because it’s really awesome to be able to access a database directly from ActionScript, and (on a personal level) because it means I can finally talk about what I’ve been working on for the last couple of months. Yes, in fact, my latest assignment at Adobe primarily involves working on the AIR local SQL database functionality.

» Keep reading AIR, local SQL databases, and my role

15 comments so far

SQL Server: Building a Mail Queue System

SQL Server: Send E-Mail Without Using SQL Mail