Jonathan Stark

Web 2.0 / San Francisico

The slides and example files for my Web 2.0 workshop (March 28th, 2011 in San Francisco) are available for download below. Please feel free to contact me if you have questions.

Slides & Examples

building-cross-platform-mobile-apps.zip (4.8MB download)

Outstanding Questions

Can you use dynamically created SQL queries with Web SQL Database?

Yes. See below for a simple example.

How well with this approach work on WP7?

I have to buy a WP7 phone to say for sure. Hopefully I'll have one in the next couple of days.

Which browsers and platforms support animation events?

I've tested the following device / OS / browser combos so far...

Works:

• iPad 1 / iOS 4.3 / Mobile Safari
• iPhone 4 / iOS 4.3 / Mobile Safari
• MacBook Air / OS 10.6.6 / Chrome 11
• MacBook Air / OS 10.6.6 / Safari 5
• Nexus One / Android 2.2 / native browser

Does NOT work:

• iPhone 4 / iOS 4.3 / Opera Mini
• MacBook Air / OS 10.6.6 / Firefox 3.6
• MacBook Air / OS 10.6.6 / Opera 11
• Nexus One / Android 2.2 / Opera Mini

Books

Links to both free and paid versions of my mobile app development books can be found here.

Related Links

jQTouch main site

http://jqtouch.com

jQTouch source code

https://github.com/senchalabs/jQTouch

Sencha Touch main site

http://sencha.com

PhoneGap main site

http://phonegap.com

PhoneGap docs

http://docs.phonegap.com

PhoneGap Build service

http://build.phonegap.com

Weinre Remote Debugger main site

http://pmuellr.github.com/weinre/

JS Console Remote Debugger main site

http://jsconsole.com

Intro to Weinre: Remote Debugger for Mobile Web Apps

http://www.youtube.com/watch?v=4nL6xey13fE

Intro to JS Console: Remote Debugger for Mobile Web Apps

http://www.youtube.com/watch?v=BEo8oJYey-M

How to Install PhoneGap

http://www.youtube.com/watch?v=yuTqQyzyVvU

Intro to jQTouch

http://www.youtube.com/watch?v=6X4K2MQsSeI

TextMate Bundle for jQTouch

http://www.youtube.com/watch?v=KsmdtnbAj80

TextMate Bundle for Safari

http://www.youtube.com/watch?v=f_T6ABZ3kzU

Web Storage spec

http://dev.w3.org/html5/webstorage/

Web SQL Database spec

http://dev.w3.org/html5/webdatabase/

Offline Application Cache spec

http://dev.w3.org/html5/spec/offline.html

Dynamic SQL Example Code

function createPerson() {
    var firstName = firstNameField.value;
    var lastName = lastNameField.value;
    var table = 'person';
    var sql = 'INSERT INTO ' + table + ' (firstName, lastName) VALUES (?, ?);';
    db.transaction(
        function(transaction) {
            transaction.executeSql(sql, [firstName, lastName], findAll, errorHandler);
        }
    );
}