12Robots.com - Jason Dean - AIR

My Presentation slides from cf.Objective, NCDevCon, and CFUnited

Thu, 19 Aug 2010 07:14:00 -0500

I keep forgetting to do this. Sorry :( I have given three presentations so far this year, and I will have 2 or three more et before the end of the year. Here are the slides for the first three in both Keynote and PDF formats. [More]

Enabling Access to the Adobe AIR Tools in ColdFusion Builder

Wed, 28 Jul 2010 16:29:00 -0500

I was talking to Charlie Arehart today after his "Hidden Gems in ColdFusion Builder" presentation at CFUnited 2010 and I mention that, for some reason, ColdFusion Builder has the Adobe AIR packaging features of the application hidden by default. So I thought I would write a post on how to enable them for those that would like to use CFBuilder for developing AIR applications. [More]

On my way to NCDevCon

Fri, 21 May 2010 07:30:00 -0500

Right now I am on my way to NCDevCon (Yay for free inflight internet!!). If you are going to be at the conference this weekend, please do not hesitate to introduce yourself. One of the main reasons I go to conferences is to meet others. On Saturday I will be speaking about Security in Adobe AIR applications. I will point out that this session is targeted toward experienced AIR developers (either Flex or HTML JS). Anyway, I am looking forward to the conference. Last year's CFinNC was amazing, and I am positive that this year will be just as good.

My presentations from the MN Government IT Symposium

Mon, 14 Dec 2009 11:38:00 -0500

Bleh. I have been sick for the last week and have spent a lot of time away from the keyboard and from blogging. But I was able to give both of my presentations at the MN Government IT Symposium last week and they both wen toff excellently. I got a lot of good feedback for both. Even my application security presentation, which was the last session on the last day managed to draw 20 attendees, which, I understand, is pretty good. Anyway, here are my presentations in their original formats and in PDF format. [More]

I will be speaking at the MN Government IT Symposium Next Week

Thu, 03 Dec 2009 13:27:00 -0500

Last year I spoke at the Minnesota Government IT Symposium on application security, and I thought it went really well. I ended up with 75 or so attendees (for a 2.5 hour presentation), which I thought was fantastic. This year I have been honored with being selected to speak again on application security (this time for only one hour) and also on Adobe AIR. [More]

I'll be speaking at CFUnited 2010!! w00t!!

Tue, 24 Nov 2009 01:14:00 -0500

I found out late last week that I am one of several people to have had a presentation topic selected for CFUnited 2010. This is very exciting for me and is a great honor. The selected topic title is "Understanding Security in Adobe AIR Applications" and here is the description.

Wait... You mean AIR applications have different security concerns than regular web applications? Yes, they do. Since Adobe AIR applications are desktop applications we have new security considerations to think about. Come learn how to ensure that your AIR applications are secure. In this presentation we will go over the Adobe AIR security model and some security best practices in Adobe AIR for both Flex and Ajax applications.

I am really looking froward to putting together this presentation and presenting it to one of the many fantastic conference audiences in the best developer community in the world.

Using SQLite Databases with AIR - Part 8 - Encrypted SQLite Databases

Mon, 02 Nov 2009 09:23:00 -0500

Getting back on track with projects I have already started, I want to finish up this series of posts of using SQLite databases with Adobe AIR. This last section will be on using Encrypted SQLite Databases.

Why use Encrypted Databases?

There will likely come a time in your career when you need to deal with sensitive data. When dealing with AIR applications, it may come sooner than you think. With AIR applications, if you need to persist data for use offline, one of the better options to do so is inside of a SQLite database. However, if you do this without any encryption, then the file is (obviously) stored in a clear-text way, meaning that it can be read by anyone who had access to the machine, including other applications like Trojan horses or other AIR applications written by malicious users. [More]

Adobe AIR for JavaScript Developers: Pocket Guide

Tue, 29 Sep 2009 10:49:00 -0500

So while searching for some Adobe AIR information the other day, I came across the PDF of a book that I have been using to help me learn AIR with JavaScript. I thought maybe it would come in handy for some others, as it has for me. [More]

AIR Tip: Cookie Sharing between AIR and Web Browsers

Tue, 22 Sep 2009 18:48:00 -0500

This is something I came across at work that I thought I would share, because at first, it had me scratching my head. Internally, Adobe AIR uses webkit as a "browser" which is great, and as expected, it actually behaves like a browser, including cookie support for access to external resources. Which means that when you are making remote calls to resources, you can use cookies to maintain sessions, or for information tracking. [More]

Last Night's Hands-on Adobe AIR Presentation at TCCFUG - with source code

Thu, 03 Sep 2009 14:05:00 -0500

Last night we did a hands-on Adobe AIR session at the Twin Cities ColdFusion User Group meeting. We had a great turnout of about 18 people and I was very happy to see so much interest in Adobe AIR. I think it is a lot of fun to work in and I am glad I piqued the interest of so many others. As promised at the meeting, I am posting the source code of the completed application. [More]

Using SQLite Databases with AIR - Part 7 - Looping over Query results (also with jQuery)

Thu, 27 Aug 2009 08:06:00 -0500

I think that I have neglected to cover one of the most important parts of working with SQLite databases in Adobe AIR, and that is how to get the results out of the query. We talked about making queries, parameterizing queries, using transactions with queries. But I don't think we have covered getting the data out of the queries. So let's do that. [More]

Using SQLite Databases with AIR - Part 6 - Transactions

Mon, 24 Aug 2009 07:48:00 -0500

Transactions is SQL statements are something that I have come to love. I'm sure you have too. But for those that don't know what transactional control in a database management system is, we'll start with a definition. Usually, when doing multiple SQL statements in a row in an application, each SQL statement is handled as a atomic unit and is committed permanently to the database before the next one is run. This can be very problematic when those queries depend on each other to work properly to maintain data integrity. [More]

Hands on Adobe AIR at the next Twin Cities CFUG

Thu, 20 Aug 2009 15:33:00 -0500

On Wednesday, September 2nd, I will be presenting at the Twin Cities ColdFusion User Group meeting. At this meeting we are going to be trying something new (at least for me since I have been going to the CFUG). We are going to do some hands-on work with the technologies we love instead of just doing a lecture-style presentation. The work we will be doing is with Adobe AIR, JavaScript, jQuery, and SQLite. Here is the description for the session: [More]

Using SQLite Databases with AIR - Part 5 - Parameterizing Queries

Wed, 12 Aug 2009 13:49:00 -0500

In a previous post we looked at doing simple CRUD with Adobe AIR and SQLite and doing CREATE TABLE statements. But the examples we've looked at are VERY simple. In fact, we have not looked at any dynamically constructed queries. Today I want to look at properly building dynamic queries in AIR using bind parameters. [More]

Using SQLite Databases with AIR - Part 4 - Simple CRUD

Mon, 03 Aug 2009 15:47:00 -0500

So in case you you've been living under a rock for the last several years, you know that CRUD stands for Create, Read, Update and Delete. Which is what we are going to look at today, doing simple SQL statements with SQLite databases in Adobe AIR using JavaScript. We saw in my last couple posts how do do simple CREATE statements using both synchronous and asynchronous connections. I will paste them here again so that we have the reference all on one page. [More]