Archive for February, 2011

I missed the minutes for our last group meeting 2/5 (so sorry),  so I’m going to try really hard not to do that again.

Here’s what we covered today at livelyfbug:

Video Coming!

Livelyfbug 2/19 Minutes

  1. 3D by Sweet Pee
  2. Algebra Speak Game by MindWind (Autism Welcomed)
  3. UML with Kent State University
  4. Investment Strategies Game
  5. Development of Flash+PHP+SQLite  Workflow Avoiding Bottlenecks
  6. Using Filezilla for uploading to a server
  7. Flash Talking to PHP (Adam Khoury)
    http://www.developphp.com/list_flash_video.php
  8. PHP talking to SQLite (Bill Weinman – Lynda.com)
    http://code.google.com/p/yii-trackstar-sample/
  9. (Adam + Bill + Lively) = Flash + PHP + SQLite
  10. Simple Example

This was a great session. I had a really good feeling after-wards. Things are really starting to move forward on several fronts of software development. We had Live Meeting available for this session. Next time we should have Adobe Connect up and running. Should have a nice group both in house and virtual.

 

Livelyfbug 2/19 Minutes

 

  1. 3D by Sweet Pee

  2. Algebra Speak Game (Autism Welcomed)

  3. UML with Kent State University

  4. Investment Strategies Game

  5. Development Workflow Bottleneck

  6. Using Filezilla

  7. Flash Talking to PHP (Adam Khoury)

    http://www.developphp.com/list_flash_video.php

  8. PHP talking to SQLite (Bill Weinman – Lynda.com)

    http://code.google.com/p/yii-trackstar-sample/

  9. (Adam + Bill) Flash + PHP + SQLite (lively)

  10. Simple Example

On Feb 19, at Panera’s we’ll be showing you how to get “good old” Flash talking to a SQLite database using PHP. No where else can I find out how to do this (typically it’s done for Flex or AIR). So I myself can’t wait to hear what I’m going to say.

Flash+PHP+SQLite

Flash+PHP+SQLite

See you there!

You can Live Meeting in at

(Link removed – session over)

Selecting a UML Editor and Use Case

Posted: February 16, 2011 in Tutorials

If you are new to UML and need to select an easy intuitive editor these two videos should help you out. I’m producing a UML course in conjunction with Kent State University. Here’s the methodology I went through in selecting the optimal software for that particular teaching gig.

Choosing a UML App: http://www.youtube.com/watch?v=53UKMSMssQM

In the second video, we install our UML application and create an e-commerce use case scenario.

Creating Use Case: http://www.youtube.com/watch?v=RY_9qhaMd3Y

In this video you learn how to import an Excel Spreadsheet into SQLite.

Hello Sweet Pee and Molehill

Posted: February 11, 2011 in Fun and Friends

Jonathan affectionately known as “Sweet Pee” has been working with 3DS Max for a few years now. His skills are improving and he is working on a new game specifically tailored for the Molehill API about to be released by Adobe.

Sweet Pee

Sweet Pee

Below are some of the 3D models he has been developing.

3D Models

3D Models

We are pretty fortunate to have such a talented 3D modeler in our mist. I’m sure Sweet Pee’s talents will be put to good use on many of our projects.

If you don’t know about Molehill and are wondering why we are so interested in it, check out the video below:

While Papervision3D was limited to about 2000 polygons 15fps in the Flash 9 days…Molehill can easily do 1/5 million polygons at 60Hz HD.

Wow, strap on your rocket pack, we’re about to go on a 3D adventure ride!

2 Step Short Cut

Now if all you want to do is add XML to SQLite…it’s super easy. (First) Just install the SQLite Manager Firefox plugin listed below in step 5, (Next) create your SQLite database, add your table, and import your XML.

But setting up the work flow for a larger project takes a few more steps and that’s what this post is all about!

SQLite Video Story

Watch Video 1 on Getting Started

Watch Video 2 Importing XML

Intro: What is SQLite?

Unlike client–server database management systems, the SQLite engine has no standalone processes with which the application program communicates. Instead, the SQLite library is linked in and thus becomes an integral part of the application program. The library can also be called dynamically. The application program uses SQLite’s functionality through simple function calls, which reduce latency in database access – function calls within a single process are more efficient than inter-process communication. SQLite stores the entire database (definitions, tables, indices, and the data itself) as a single cross-platform file on a host machine. It implements this simple design by locking the entire database file during writing.

  • Full featured relational database fully contained in a driver.
  • Complete implementation of SQL
  • Fast reliant transactional and ACID-compliant DB engine
  • Web desktop and embedded applications
  • Not a database server…fully self contatined.
  • SQLite opens a file and used it as a database

Note: Must open up your permissions – the browser needs to write (777)
Data typing is Type Affinity (stores all values as NULL, TEXT, or BLOB)
No data type for money or time

SQLite Work Flow (9 steps)

  1. For programming HTML 5 you are going to use Dreamweaver or NetBeans
    (NetBeans – similar to eclipse – good for PHP and SQLite as well)
  2. In this case we will use NetBeans (http://netbeans.org/)
  3. With NetBeans you also need XAMP (may need to set a different port)
    http://www.apachefriends.org/en/xampp.html
  4. After installing NetBeans 7, you need a management system for SQLite
    so you can do the similar things that (MySQL and SQL Server does)
  5. Use FireFox plugin SQLite Manager
  6. After installing the plugin you need a PHP management PDO library
    to assist you in your work with SQLite (Bill Weinman )
    The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. Each database driver that implements the PDO interface can expose database-specific features as regular extension functions.
  7. Grab it using tortoise (if on windows) from the subversion address
    http://yii-trackstar-sample.googlecode.com/svn/trunk/
  8. Put everything in the right places and write PHP that creates a database
    and table…do a little PHP magic!

    Create Database

    global $G;
    if(file_exists(DATABASE)){ echo ‘Database already exist’;
    }else{
    try{
    $db = new bwSQLite3(DATABASE);
    echo ‘Created Database’;
    }catch(PDOException $e){
    message(‘bwSQLite3 could not create database (%s)’, $e->getMessage());
    }}
    Add a Table 

    try {
    $db = new PDO(‘sqlite:’ . DATABASE);
    $db->exec(‘CREATE TABLE IF NOT EXISTS ReturnData (
    id INTEGER PRIMARY KEY,
    Year TEXT,
    TBillReturn REAL,
    IntBondReturn REAL,
    SP500Return REAL,
    CPI REAL)’);
    message(‘Table ReturnData sucessfully created’);
    } catch(PDOException $e) {
    message($e->getMessage());
    }

  9. Use the SQLite Manager FireFox Plugin to import your XML file into your database table.Note: Make sure all the XML tags match the Database columns
    or it will not parse!

Why HTML 5?

Posted: February 8, 2011 in Flash Builder Users Group

This is a video from a series that I’m doing for MindWindBlowing. This video discusses the why of HTML 5 and places it in the context of web evolution (from where to where). Enjoy…and thanks to MindWindBlowing for sponsoring it.