Topic: Projects
New project: AIR SQLite utilities
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 of functionality), […]
» Keep reading New project: AIR SQLite utilities
A new (old) tool for AIR SQLite development
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 for […]
» Keep reading A new (old) tool for AIR SQLite development
A useful tool, the joy of shipping code, and a great developer
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
Please test: updated ActionScript GZIP library with Flash Player 10 support
Since I first created my ActionScript GZIP library as a test of Adobe AIR’s file compression capability, the number one request I’ve received has been to add support for Flash Player-only projects. With the release of Flash Player 10 last fall, I couldn’t use the lack of player support as an excuse any more. So […]
» Keep reading Please test: updated ActionScript GZIP library with Flash Player 10 support
As I’ve mentioned I’ve been doing a lot of AIR database work, so I’ve been spending literally hours a day working in my AIR SQL query runner app. The good news is that means I’ve been finding/fixing bugs and adding features!
One thing I’ve been wishing for the last week or so is undo/redo functionality as I’m editing query text. Coincidentally, I just found out that my 360|Flex friend Jac Wright has written a library for undo and redo in Flash Player (ActionScript) text fields. The previous link is to the Google Code project; here’s his introductory blog post about the “undo textfields” library. (via Tyler Wright via Gilles Guillemin/Twitter)
Admittedly I haven’t tried this yet, and I’ve asked whether it’s been tested in AIR so I don’t know whether it will actually be feasible as-is. But I’ve got my fingers crossed! =)
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
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 news […]
» Keep reading AIR 1.5 encrypted SQLite database — how to use it, best practices, and new projects
360|Flex slides for “AIR SQLite: An optimization conversation”
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”
New project: ActionScript Regular Expressions Testing Tool
Over the last couple of weeks I’ve been working on a Flex project where I’ve had to make heavy use of regular expressions. As always seems to happen when I work with regular expressions in any language, I found that one of the more complex parts of the process was just figuring out the exact […]
» Keep reading New project: ActionScript Regular Expressions Testing Tool
XML-RPC client updated
In case anybody follows my site just to get updates on my XML-RPC client library… I’ve just released an updated version of my XML-RPC client library project.
The library is still in ActionScript 2.0—I haven’t finished porting it to ActionScript 3.0 yet, although I’ve started.
This release (.3 beta) contains a single bug fix. In anticipation of […]
» Keep reading XML-RPC client updated
Articles by Type
Articles by Topic
- .NET (5)
- ASP.NET (3)
- ActionScript (70)
- AS3 (34)
- Vector (typed arrays) (2)
- AIR (31)
- local SQL database (18)
- Privacy/security (3)
- Application Design (17)
- Book reviews (3)
- Coding (9)
- Conferences (2)
- Contextual design (1)
- Design Process (1)
- Dreamweaver (4)
- Flash (55)
- Flex (36)
- Flex Builder (5)
- Frameworks (8)
- iPhone (3)
- JavaScript (2)
- Life at Adobe (3)
- MS SQL Server (4)
- Multi-screen (1)
- Pixel Bender (1)
- Presentations (12)
- Projects (10)
- SaaS (1)
- Semantic Web (1)
- SQL (12)
- Surveys (1)
- Unit testing (3)
- User-centered design (14)
- Web Browsers (6)
- Web Design (16)
- CSS (6)
- Writing (13)
Random Reading
- Andrew Shebanow
- Greg Burch
- Erik Bianchi
- Abdul Qabiz
- Adobe Kiwi Project (Brian Riggs and Darrick Brown)
