Blog

31
January 2015

Gavin Pickin

Using WebSQL - Pulling Data - Start Thinking Async vs Sync

Javascript, WebSQL

In today's post on WebSQL, I’m going to show you how I had to refactor my application, to move from sync LocalStorage functions and storage, over to using WebSQL, which has an ASYNC API for transactions. In the last few posts, I have gone over why I chose WebSQL for this Application, and how to get Started with WebSQL etc, and had to post a correction to some assumptions I had made, so now we’re ready to move on and get some data out of the db, and thrown into our application.

30
January 2015

Gavin Pickin

Pre-mature Optimization - Pre-mature Blog - Gotcha WebSQL Open Database

Javascript, Techie Gotchas, WebSQL

I have written a few posts so far about WebSQL, why I like it, especially in this cross platform Cordova / Phonegap App development world, and a getting started post, where I was wrong. Yes, I Pre-maturely posted that Blog, so this is me fixing it, of course, I edited the original post right away, but here, I’ll go into what I stated wrong, and how it took me way too long to figure out I was wrong, and how sometimes Pre-mature Optimization isn’t needed, but sometimes, it will help show you how wrong you were.

30
January 2015

Gavin Pickin

Whats better than Firefox Developer Tools? Firefox Developer Edition

Javascript, Tools and IDEs

In the world we work in, the Web world, there are lots of IDEs and tools out there. One of the best tools to ever come out for Web / Javascript development, and made developing in Javascript even possible I thing, was Firebug. These days most modern browsers have web tools, and they're getting better every day. Some like Firefox's Dev tools, others prefer Chrome, and I have heard that IE 11s are actually pretty amazing. Each suite of test tools one ups the other, and the innovation is good for all of us.

I am probably very behind the times, but I only just learned of another option from Mozilla, which is better than Firefox's Dev Tools... a Firefox Developer Browser.

29
January 2015

Gavin Pickin

Lucee in the Clouds with Java - Hello World, from Lucee

CFML Language, CFML Server, Migrating to Railo, Server Admin

Less than 12 hours ago, we were on the dawn of a big announcement in the CFML world, and only a few knew it was coming. A few more knew something was coming, but were not sure what it was, myself, I was expecting some tools, or a new version, or something, to put it mildly, I was surprised to hear what the big announcement was.

There is a new server product on the CFML Engine market, LUCEE.

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.

20
January 2015

Gavin Pickin

Cordova Cross Platform Database Issue - The Solution Might Surprise You

Android, Cordova / Phonegap, IOS

There was a point when Local Storage key value pair just didn’t seem to be a good solution. Its great for small key and values, but when you’re starting to dump JSON Objects Arrays, which have children, and you do not have all the NoSQL goodness, its time to get something bigger and beefier.

Here is the story of my search for a cross platform DB solution to work with Cordova.

26
August 2014

Gavin Pickin

ColdFusion Install Download Repo - New Home for all your Files

CFML Server, ColdFusion Install Repo

The ColdFusion Install Download Repo has been having some issues lately, with the main location, Copy.com. They shut down a shared folder, but not the whole account, and after no response, and a timely process to move all the files, I decided (with some input from Charlie Arehart) that its probably better off somewhere a little more independent, and more user friendly.

http://www.gpickin.com/cfrepo/

11
June 2014

Gavin Pickin

The CFML Community's Cries for Help have Been Heard

CFML Language, CFML Server, ColdBox, Tools and IDEs

Talk about some link bait, but, to be honest its pretty accurate. For the longest time now, the CFML community has been asking for several things, to help bring CFML into todays standards for languages, and the call has been answered. What are these things I talk about, CLI Command Line Interface, REPL Read Evaluate Print Loop, a Package Manager, and a Command Line way to Access the Package Manager. For those of you who did not make it to cf.Objective() or Scotch on the Rocks, you might not have heard, but Ortus Solutions has created CommandBox, and even Adam Cameron has no problem with all the superlatives in the documentation, because even he agrees, CommandBox is AWESOME. Although Adam stated it as "This is possibly the most important innovation in #CFML since CFCs" - that's awesome

10
June 2014

Gavin Pickin

Viva Las Vegas - Roll the Dice or just Vote It Up

CFML Language, Conferences

Finally getting over cf.objective()? Maybe you're just recovering from Scotch on the Rocks last week? Don't worry, there are more great ColdFusion conferences coming your way soon, and it's time to help shape CF Summit in Las Vegas, October 16-17 at the aria. Our friend Matt Gifford, released an app for call to speakers and voting on submitted topics. Last year CF Summit had over 500 attendees, and is expected to be bigger and better than last year. So don't wait, submit a topic, vote, and get a ticket.

Blog Search