Topic: AIR

“Adobe AIR data privacy and security” - slides, notes, links

Posted June 9, 2009 10:03 am
Filed under: AIR, Application Design, Flex, local SQL database, Presentations, Privacy/security, SQL

On May 20, 2009 at the 360|Flex conference in Indianapolis I gave a presentation titled “Adobe AIR data privacy and security.” As I always do (and after a bit of a delay), here are the slides from my presentation. I’ve added fairly lengthy notes to the slides (I had to make the font smaller so […]

» Keep reading “Adobe AIR data privacy and security” - slides, notes, links

3 comments so far

A new (old) tool for AIR SQLite development

Posted April 22, 2009 3:41 pm
Filed under: AIR, Articles by Paul, local SQL database, Projects

This is pretty much old news by internet time standards, but I haven’t had time to write about it until now. (We’re working hard to make future Flex/AIR/ActionScript/Flash documentation more focused on how you actually use documentation, better than ever before.) A couple of years ago, before AIR beta 1 (“Apollo”), I wrote a tool […]

» Keep reading A new (old) tool for AIR SQLite development

1 comment so far

A useful tool, the joy of shipping code, and a great developer

Posted March 12, 2009 11:23 am
Filed under: AIR, Application Design, Coding, local SQL database, Projects

If you use David Deraedt’s great AIR SQLite administration tool Lita, you probably already saw that he just pushed an update (v. 1.2) a few days ago. Aside from my general happiness from seeing that this release fixes some bugs and adds new features that were important to me, this release has personal significance for […]

» Keep reading A useful tool, the joy of shipping code, and a great developer

1 comment so far

I just wanted to write a quick note to say that I’ve released an update to my “Doppler” AIR SQL admin tool. You can get it from the Doppler project page. (I’ve been working on an actual real application, one with a fair amount of database work, so naturally I’ve found motivation to fix some lingering bugs and add some missing functionality.)

As with previous versions, if you’ve been using the app you’ll need to uninstall it before installing the new version. Someday I’ll add updating support, but I’m not going to promise anything real soon.

Along with this release, I’ve also made a change to how I describe the tool, and to my future intentions for it. I’ve always had it in my mind to make this a full-fledged database admin tool, similar to the tools that come with SQL Server or other enterprise databases. However, time has obviously not allowed me to do that, and in the mean time other tools have been released by other developers. I’ve found one, David Deraedt’s “Lita” SQLite admin tool that is sufficiently mature that I use it in my day-to-day work now and it definitely beats doing things by hand! There are still improvements to be made and features to be added, but when I’ve reported bugs and feature requests he’s been quick to respond and release updates.

So while I’m sure nobody’s been holding their breath waiting for me to finish the “admin tool” portion of my app, I just wanted to clarify the new direction I’m taking it — or rather, the fact that I’m not planning to take it in as many new directions! (Hence the change in title for the project from “AIR SQL admin tool” to “AIR SQL query testing tool.”)

That doesn’t mean I’m done developing this tool by any means. In past jobs where I did heavy database development, and in a project I’m currently working on that involves heavy database development, I find it very useful to have two different kinds of database tools — one for creating and managing database objects and structure, and another for testing queries. While Lita does in fact have a tab for testing queries, I personally find Doppler to be a bit (not a lot, but a bit =) more developed in that specific area. On the other hand, Lita certainly does a lot in the db management space that Doppler doesn’t do. So I find the tools very complementary in terms of my actual development work.

As always, I welcome feedback, questions, thoughts, etc. And thanks to everyone who’s already reported bugs and offered suggestions!

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

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

» 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, 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

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

Upcoming presentations on AIR Windows, Menus, and the System Tray

Posted April 15, 2008 10:27 am
Filed under: AIR, Articles by Paul, Presentations

I have a couple of presentations coming up soon, and I haven’t been getting word out as much as I probably should have. At the end of May I’ll be speaking at the Webmaniacs conference in Washington D.C. (May 19-23). I’m giving a two hour hands-on session titled “AIR: Windows, Menus, and the System Tray.” […]

» Keep reading Upcoming presentations on AIR Windows, Menus, and the System Tray

1 comment so far

Lots of big releases for Adobe AIR and Flash Player today. In no particular order:

Security update for Flash Player (“9.4”) (also see the DevNet article)
Security update for Adobe AIR (“1.0.1”)
New public Flash Player bugbase (also see the DevNet article)
Adobe Media Player 1.0 (with a lot more content now that it’s final — if you’ve tried it before but didn’t bother with it because of lack of content, it’s worth another look)

Note: I added AMP after this post was already published, since it wasn’t yet public at the time.

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)

« Previous Page