Run! AIR SQL query authoring/testing tool

Run! is a “query runner” tool for Adobe AIR developers building applications that use AIR’s local SQL database (SQLite) functionality.

The current version of Run! is 0.2.1 (July 7, 2009)

Run! was previously known as “Doppler” but my plans for the project changed somewhat, so a name change seemed appropriate too.

When I’m developing an application that uses a database, I find it much easier to get a SQL statement working in isolation rather than trying to write it and test it within the application source code. That is the basic idea of Run!. Since Run! can load and save SQL files directly, I use it as the editor application for my SQL code while I’m building AIR apps that use SQLite database functionality.

Install

To install Run!, click on the “Install Now” link in the installer badge:

Please upgrade your Flash Player
This is the content that would be shown if the user does not have Flash Player 6.0.65 or higher installed.

If the badge installer doesn’t work for you, you can also Download the .air file and execute it to install Run!. You will need to have Adobe AIR 1.5 (or later) installed on your machine already.

Notes: If you have “Doppler” version 0.1.3 or earlier installed, you will need to uninstall it before installing the latest version. Starting with Run! version 0.2, the application includes support for auto-updating, so that should no longer be necessary.

Currently I’m only providing the .air file, although someday (once I’ve cleaned up the code) I plan to make this an open source project.

Details

Here’s a screenshot to give you an idea of what to expect from Run!:

A screenshot of the Run! AIR SQLite query testing tool, showing the tree view of the tables in the open database as well as a query and its results.

The main part of the application is the query editor on the right hand side. You enter your SQL and run it, and if it’s a SELECT query you see the results in the grid beneath. In addition, the db structure is shown in the tree on the left. You can double-click on a table or column node, and it’s name is automatically entered in the editor at the selection point.

Note that Run! is not intended to be a full-featured database administration tool. For additional “admin tool” functionality, such as creating and managing tables and indexes, I use and recommend David Deraedt’s “Lita” SQLite admin tool. I personally use both tools for development. I use Lita for creating/managing database structure. I use Run! for testing queries because it shows more detailed table and view structure without needing to click away from the query window and has some additional functionality.

Project history

0.2.1 (2009-07-07):

0.2 (2009-03-18):

0.1.3 (2009-01-26):

0.1.2 (2008-11-18):

0.1.1 (2008-08-28):

0.1 (2008-08-19): Initial release

You can leave a comment, or trackback from your own site.

4 Comments so far

  1. July 12th, 2009 at 7:16 am
    João Pedro Pereira is reported to have said:

    I loved this tool! It has been very usefull for me! Thanks

  2. September 10th, 2009 at 9:37 am
    Charlie Key is reported to have said:

    Quick question, say i encrypt a database using Lita and got my hash, what is the value I enter when opening the database in Run!? Thanks for the tool.

  3. September 11th, 2009 at 11:36 am
    Paul is reported to have said:

    Hi Charlie,

    Thanks for asking this question. It turns out there’s a small incompatibility in the encryption keys that Lita generates versus the ones that Run expects. Fortunately I’m on good terms with David Deraedt (and I’m a contributor to Lita) so we were able to figure out the issue. I’ve talked with David and we think we’ve figured out the best way to resolve the incompatibility. (It will probably involve changes to both Run and Lita.)

    In the mean time, if you want to open your database with Run (don’t laugh =) I’ve built a Flex app to convert a Lita encryption key hash to the base-64 encoded encryption key format that Run uses

  4. December 12th, 2009 at 6:02 am
    Chuck Freedman is reported to have said:

    Great work on this SQL Admin tool. UI is great and it’s letting me peak into my otherwise hard-to-read SQL Lite table for my AIR app.

Add your comment





Comment notes

Please keep comments on topic. Comments that are inappropriate or offensive will be edited or removed.

Paragraphs and line breaks are automatically converted to HTML, and quotation marks are converted to “smart” quotes.

The following XHTML tags can be used: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> . All others will be removed.

Articles by Type

Articles by Topic

Random Reading

Currently...

Subscribe