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.

6 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.

  5. February 17th, 2010 at 9:06 am
    Jim is reported to have said:

    Paul,
    I’m just getting into Air, usually use html and ajax. However I downloaded Run! and can see it being very useful for mac and pc clients searching for media, based on a query about content of the metadata fields held in the SQLite database on our storage area network.

    How can I delete your templates and add some of my own? For most of the query’s I need to include a lot of processing for dates and time code values.

    here’s a typical query to find clips with “Karl” in the metadata fields or in the clip name;

    SELECT strftime(‘%d-%m-%Y %H:%M:%S’, m.createTime, ‘6612 year’, ‘+1 month’, ‘+5 day’, ‘-12 hour’) as ‘Create Date’, mg2.binName as ‘Parent/Session’, mg.binName as ‘Bin Name ‘, m.name as ‘Clip Name ‘, m.assetType as’Asset’, e.name as ‘Metadata Type’, e.data as ‘Metadata’,

    cast((m.maxLength / 3000) as text) || ‘:’ || cast((m.maxLength % 3000) / 50 as text) || ‘:’ || cast((m.maxLength % 50) / 2 as text) as ‘Duration’,

    cast(m.firstTimecode >> 24 & 31 as text) || ‘:’ ||
    cast(m.firstTimecode >> 16 & 63 as text) || ‘:’ ||
    cast(m.firstTimecode >> 8 & 63 as text) || ‘:’ ||
    cast(m.firstTimecode >> 1 & 31 as text) as ‘MarkIn’,

    cast(m.lastTimecode >> 24 & 31 as text) || ‘:’ ||
    cast(m.lastTimecode >> 16 & 63 as text) || ‘:’ ||
    cast(m.lastTimecode >> 8 & 63 as text) || ‘:’ ||
    cast(m.lastTimecode >> 1 & 31 as text) as ‘MarkOut’

    FROM Extension e, Movie m, MovieGroup mg, MovieGroup mg2
    WHERE m.id=e.movieId
    AND mg.BinId=m.binId
    AND mg2.BinId=mg.parentId
    AND (e.data LIKE ‘%Karl%’ OR m.name LIKE ‘%Karl%’)
    ORDER BY mg2.binName, mg.binName, m.createTime, m.name ASC;

    thanks,
    Jim

  6. February 18th, 2010 at 10:36 am
    Paul Robertson is reported to have said:

    Hi Jim,
    Right now there isn’t a way to add new templates. It has been in the back of my mind as a potential feature, but in truth I never knew whether people found the templates useful in the first place.

    Now that I know this is something that would be useful to you, I’ll definitely move it up the “priority ladder” for the next release.

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