Topic: SQL

Notes from D-Flex “AIR SQLite for the real world”

Posted May 23, 2011 7:38 pm
Filed under: AIR, local SQL database, Presentations, SQL

Last week I presented to D-Flex (the Dallas Flex Users’ Group) on the topic of AIR SQLite for the real world. This is the description of the presentation: Almost any real application needs to store data, and usually that means using a relational database. In the real world, building an application that uses a database […]

» Keep reading Notes from D-Flex “AIR SQLite for the real world”

1 comment so far

Data “paging” in AIR SQLite

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

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

» Keep reading Data “paging” in AIR SQLite

2 comments so far

AIR SQLite library updates

Posted April 2, 2010 2:18 am
Filed under: AIR, local SQL database, Projects, SQL

A couple of people have reported a bug in my AIR SQLite utility library. I also recently used it to help build a Robotlegs demo app for the 360|Flex Robotlegs training, and in the process I discovered a missing feature I needed (namely, the ability to get back the SQLResult objects after running a batch […]

» Keep reading AIR SQLite library updates

5 comments so far

New project: AIR SQLite utilities

Posted February 3, 2010 1:44 pm
Filed under: ActionScript, AIR, Application Design, Articles by Paul, AS3, local SQL database, Projects, SQL

I’m excited to announce that I’m “officially” releasing a new open-source project that I’ve been using on personal and work projects for over a year. For lack of a better name, I call it my “AIR SQLite utility library” The code currently contains one major piece of functionality (well, two different variations on one bit […]

» Keep reading New project: AIR SQLite utilities

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

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

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

2 comments so far

“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

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!

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”

9 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!)