Archive for January, 2012

SQLite Management

Posted: January 29, 2012 in Flash Builder Users Group

I usually use the firefox sqlite plugin to manage my SQLite databases. But recently I snagged the Drupal sqlite database and set it up as a Flex backend. Looking around I found this really cool air sqlite management tool…Lita

You can grab it at


We had a great meeting. Several projects are in the works and were dicussed:

  • Stuart’s Investment Strategy Game (Flex)
  • Ed, Ted, and Bill’s Mobile Coupon system (HTML5 and Flex)
  • Kyria is planning a Chinese Mandarin Site (HTML5)
  • David’s EPA contract (Flex and MATE)
  • I’ve got a new open source Flex piece (for Ed’s app)
  • Jonathan is working on a Ray Tracing (JavaScript) game and he demonstrated some of his 3D work
Basically, we are using HTML5 for our mobile delivery and Flex for our desktop applications. That’s why Ed’s project has both a HTML5 and Flex piece.

Here’s a few links we looked at today:


Javascript Gaming

Relational Database Basics

Chinese Roots

Yet another Mobile Template

Chamber of Commerce


Our meeting is this Saturday, 28th at 9am at my house (1849 Windingvine Ct., Florence, Ky 41042). Here is what we are going to cover:

  1. Congrats David got a Flex Job
  2. Setting up and connecting to an SVN (Flex and HTML5)
  3. Setting up a Database using phpmyadmin (look at a modified Drupal DB)
  4. Connecting to the database in Dreamweaver (and more)
  5. Yet another Mobile HTML5 starter file
  6. My Upcoming Flex Open Source Project (needed for Ed’s project)
  7. Timeline for Ed Landis’s Project
  8. Proposed Kyria’s Chinese Project
  9. Chamber of Commerce

See you there…Mike

Setting up an SVN for Flex

Posted: January 22, 2012 in Tutorials

Part 1: Setting up an SVN in Flex

Part 2: Setting up an SVN in Flex

If you’re doing software development with more than one person (more than just yourself that is)…get an svn.

I’ve seen organizations loose a man-years tripping over each other because they did not have an SVN. And yet, it is so easy to set up.

Griping Mouse

OK, I’ve got to gripe… I’ve worked on a ton of contracts so it has all happened to me. At a bank I worked at (doing major development with no SVN), one of the project developers asked me to do AB and C. But I knew that B (of AB and C) would erase her work. So I only did A and C. The next day she sent out an email to 10 people on how I had erased her work (because I had done AB and C). But my reply to the 10  was “impossible”, because I had not done B. Then she sputtered a little in an incompetent way… During five years of development, this bank must have lost at least one man-year of work while creating a poor/stressful work environment.

So what’s the point…get an SVN! And always play smart, and be nice! Life is too short to give someone an ulcer because you won’t take 15 minutes to set up an SVN.

(Video Goes Here)

Important Links to Help You Get Started

A. Tortoise (for Windows):

B. SVN Comparison Chart:

C. Codesion:

D. Setting up Flex SVN (Flex Magazine):


2 Steps

2 Part Process

1. Download and install Tortoise (if you are using a MAC look for something comparable).

2. Set up your SVN hosting using Codesion (they have a ton of helpful getting started videos and live help). See Section B for other SVN options.

3. Install the subclipse plug-in into Flex (or eclipse Flex):

Note: If you are using eclipse with the Flex plug-in then you can in stall subclipse by Start by opening Help -> Software Updates -> Find and Install.

This will open up a dialogue that will let you select to either update existing features or Search for new features to install. We are installing a new feature, so select this one. Click through to the site selection dialogue. The Subclipse server is not in the default list, so we must add it manually.

Click the “New Remote Site” button and set Name to “Subclipse”. Check out the standard Subclipse install procedure to deternmine your version of subclipse. For this demo use the URL “” (without the quotation marks). Enter the URL and press “OK”.

Make sure that only the server we just added is checked and click “Finish”. Eclipse connects to the server and grabs the list of files available to us.

Make sure that only “Subclipse Plugin” is checked and click “Next”. Accept the terms, click “Next” and then “Finish” to install. This will start the download of the plugin. You’ll need to verify the features installed and restart. That’s it, you’re done!

Note: If you are using Flash Builder (not the FB plug-in) you must first start it up as an administrator to install from the help menu.

Go to where you installed it (in my case it was C:\Program Files (x86)\Adobe\Adobe Flash Builder 4), right click on the Flex executable and choose Run as Administrator. When Flex starts up you will now be able to install Subclipse from the help menu as shown above.

4. Set up your Flex Repository.

Back in Flex, select Window -> Open Perspective -> Other…

Select “SVN Repository Exploring” from the list and click OK. Flex will now switch to the new mode. To add a new  Repository, right click in the white space in the left panel called SVN Repositories and select”New” -> “Repository Location” from the popup menu. From your Codesion site, insert your SVN repository URL.

Switch back to the “Flex Development” perspective (in the upper right corner) and create a new project.

5. Uploading your project.

After restarting Flex, create a Flex Project (or use one you’ve already created), right click the project you want to add and select Team -> Share Project. (you may be asked to select between CVS and SVN, choose SVN.)

Select to use the repository location you added in the previous step. Click next to proceed. Use a specified folder name or use the project name as the folder name. Click next and finish to ready share your project. Write a comment, choose specific parts of the project to import (if not all), and click OK to import into the SVN. A repository icon should appear on your project icon. Check the Repository to see your imported project.

6. Making Changes.

To incorporate changes to your project. Modify project and save. A asterisk should appear over the modified file.  Right click on the modified project in the Flex perspective and select Team ->Synchronize with Repository. Choose Yes for Team Synchronization. Go to project and right click on appropriate element and choose update to add changes (arrow pointing to left), or commit to add new changes to SVN (remember to add a comment).

7. Create a project from the SVN.

In Flex in the SVN Repository Exploring perspective navigate to the project folder you want to download. Right click on the folder and choose checkout. Double check the project name…you can create multiple projects by changing the name. If the project already exist not changing the name will over write what you have.

Click Next Finish and Flex will create a Project from your repository.

8. Other Things.

Before you commit changes always update first (or you might erase other’s work)

You will get conflicts in the SVN when working with other developers so follow the menu items to merge conflicting items. Once merged…mark as merged and commit.

Don’t get wrapped around the axle. If all else fails start over. Download a new version from the SVN and start developing again. If you’ve messed up the SVN, dial back to a previous version.

Happy SVN-n-ing.

Hebrew Alphabet Flyer

Posted: January 21, 2012 in Active Projects

Here’s a fun project. Made this flyer in Photoshop for my Hebrew connect group. It took longer than I would like to admit. But the alphabet portion is really useful – check it out!

If you want the Photoshop files – email me at and I will send them to you.

Just a little background: Greeks adapted the Hebrew letters and added vowels which was funneled through the Romans and became our Alphabet. Hebrew is an abjad language – a system where each symbol usually stands for a consonant. So there have been a few additions since Paleo-Hebrew.

Hebrew is the root alphabet to most languages in the world. However, it’s different in that its alphabet not only gives the sound of the words but also their definition. For example Aleph-Bet means strength of the tent, or FatherJehovah means nailed creator (יְהֹוָה). God’s personal name after the fall of man.

Got a question on this –

I got a question on the origin of languages…Each letter of Phoenician (which is almost identical to the Paleo-Hebrew) gave way to a new form in its daughter scripts. Left to right:Latin, Greek, Phoenician, Hebrew, Arabic. See the image. If you are an Orthodox Jew you will believe that the Hebrew Alphabet and Man were created in the same time frame. Or more specifically, God created the letters first את and used them to create the universe. No doubt Paleo-Hebrew came from Shem (one of Noah’s son). But then again it depends on your world view.

First Meeting of the New Year

Now that the holidays are over…we are starting up again. Our first meeting of the new year was on 1/14/12 at 9 at my house.

The topic for our meeting was mobile HTML5 menu systems. I demonstrated (for anyone who needed it) how install  Wamp or Mamp, and how to start using phpmyadmin to create databases for PHP systems.

Saturday (1/14/12) at 9 am

The meeting is at my home: 1849 Windingvine ct., Florence, KY 41042. Call me if you get lost at 859-802-5749