Topic: local SQL database
360|Flex slides for “AIR SQLite: An optimization conversation”
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. […]
» Keep reading 360|Flex slides for “AIR SQLite: An optimization conversation”
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
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 that […]
» Keep reading Adobe AIR 1.0 ships! SQL changes, and other thoughts
AIR beta 3 and local SQL database changes
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: every […]
» Keep reading AIR beta 3 and local SQL database changes
AIR embedded SQL database: What’s new in beta 2
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
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
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
Why doesn’t Adobe’s AIR dev guide mention SQLite? A response to Tim Anderson
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
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)
Articles by Type
Articles by Topic
- .NET (5)
- ASP.NET (3)
- ActionScript (62)
- AS3 (30)
- AIR (19)
- local SQL database (11)
- Application Design (13)
- Book reviews (3)
- Coding (8)
- Design Process (1)
- Dreamweaver (4)
- Flash (54)
- Flex (33)
- Flex Builder (4)
- Frameworks (6)
- JavaScript (2)
- MS SQL Server (4)
- Presentations (8)
- Projects (3)
- SaaS (1)
- Semantic Web (1)
- SQL (8)
- Unit testing (2)
- User-centered design (12)
- Web Browsers (6)
- Web Design (16)
- CSS (6)
- Writing (9)
