Blog

Category Filtering: 'mobile-development'

11
March 2015

Gavin Pickin

Windows Store Metro App issues with jQuery Ember Angular - Solved

Angular, Javascript, jQuery, Mobile Development, Techie Gotchas

During my recent adventures with cross platform app development, I have come across a few issues,.. and solved them along the way. I had an old issue just reappear. Since the Windows Platform gives you Javascript API access to some lower level features, there are some additional security you have to deal with, one of those includes Adding Dynamic Content. This of course is a key part of jQuery, Ember, Angular and Knockout, so this by default will make developing apps for the windows store and windows devices troublesome. 
 

05
March 2015

Gavin Pickin

Did you turn it off and on again? Troubleshooting Gotchas with Cordova and WebSQL

Chit Chat, Mobile Development, Techie Gotchas, WebSQL

If you have not seen IT Crowd, you are missing out on some strange but funny geek culture... and one of the highlights of that show is the line, "Did you turn it off and on again". Sometimes with troubleshooting, the simple things can throw you off, and that happened with me recently, so I wanted to share my frustration. This might not be the most informative post, but hopefully it helps someone, so they don't shoot themselves, like I was tempted to do so.

03
March 2015

Gavin Pickin

Loading or Dumping Large Amounts of Data into WebSql - Options with Performance Numbers

Javascript, Mobile Development, WebSQL

Working with databases, there is going to be a time when you need to dump large amounts of data out of, or into your database. Dumping data out, has always been pretty easy, but what about inserts? We’ll look at a couple of solutions, and a couple of issues, and see what seems to be the best solution.

17
February 2015

Gavin Pickin

WebSQL - When is a Javascript Object not a Javascript Object?

Cordova / Phonegap, Javascript, Mobile Development, Techie Gotchas, WebSQL

After a short break from WebSQL, I am back to talk to you about WebSQL again, as I continue my work on my Cordova / Phonegap cross platform app. Today I ran into one of those Gotchas, that cost me a couple hours of time trying to debug a strange happening in my app. It is one of those things in our developers lives, if you only knew what you didn’t know, you'd know more than you know now. In finding this gotcha, I remembered a couple of other lessons when using Web Developer tools, which you may or may not know… so I’ll share those too.

22
January 2015

Gavin Pickin

Using WebSQL in my Mobile App - Lessons learned - The hard way

Javascript, Mobile Development, WebSQL

I have been working on my Multiple Platform App, using WebSQL for bigger storage needs, instead of simple Locale Storage, in which my App started with. My last blog post walked us through opening a db connection with WebSQL, creating tables, inserting data, inserting data and protecting your app from SQL Injection using placeholders, and the 2 types of transactions, .transaction() which locks the db, and .readTransaction() which does not lock the whole db, and can only be used for ready only sql… as the name suggests.

Of course, the more you dig into something, the more you learned, and I think I learned a few important things to share.
And Yes, that title is beyond a little dramatic.

22
January 2015

Gavin Pickin

Getting Started with WebSQL in your Mobile App

Android, IOS, Javascript, Mobile Development, WebSQL

In my last Blog Post, I discussed an App I was building, and how it changed target from Windows 8, to iOS to Android, and back to Windows 8, and thanks to MS Open Tech, the Microsoft Open Source company, I could use the WebSQL API to talk to WebSQL on iOS and Android, and with the plugin, SQLite on Windows 8.

This post will give you the basics of actually creating a DB Connection, creating a table, and making a couple of queries against it.

Blog Search