Blog

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.

04
June 2014

Gavin Pickin

ColdFusion - Hide n Go Seek with Documentation + Update on the CF Install Repo

CFML Language, ColdFusion Install Repo, Techie Gotchas

Another interesting week in ColdFusion… other than the call for speakers (if you want to speak at CF Summit, go submit your proposal now), the big talking about over the last week, has been Adobe discontinuing all of the CF8 and CF9 live doc help files, and recommending users, use the new maintainable Wiki. So why is that big news? 

27
May 2014

Gavin Pickin

ColdFusion Install Repo - News and Updates and new Contributors

CFML Language, CFML Server, ColdFusion Install Repo, Server Admin

The idea started with a couple of tweets, and has been growing steadily since that day in Feb 2014, when I decided to make an online repo of any and all ColdFusion Installs I had, and open it up to the community too. Now, a few months later, with Adobe's ColdFusion 10's legal issues, the ColdFusion Install Repo might become a pretty popular item… and even Charlie Arehart is contributing to the repo, so you know its worth looking into right, well, here is some news and updates.

21
May 2014

Gavin Pickin

Techie Gotchas - Debugging Code - How important is it to a Programmer?

CFML Language, Chit Chat, Conferences, Dependency Injection, Techie Gotchas, WireBox

It seems as programmers, we're always writing code, but as Dan Wilson said in one of his great sessions at cf.Objective() last week, we spend only a small fraction of our time writing new code, we spend most of it debugging, fixing and reading code. Thats not something you normally think about, but it aligns with my thinking recently, about what makes a good programmer. Being involved with teams for some time now, albeit small teams, adding new members is something which is constantly on the horizon, and the more I think about it, one of the biggest signs of a good programmer is the ability to spot bugs and problems with code. If you're fixing, debugging, or just trying to read code, it makes sense that reading and understanding the code is the most important thing. Now, whether you agree or not, why am I writing this today? 

15
May 2014

Gavin Pickin

Multi CFML Engine Install - Extracting the ColdFusion 9 Connector for Apache

CFML Server, Server Admin

We are going to setup apache with virtual hosts to deliver multiple CFML engines.
To do so, we need to setup the cfml engine adapters / connectors, 1 by 1, and remove their connector code from the main httpd.conf and then include that connector string in the Vhosts themselves, while leaving any LOAD MODULE code in the main httpd.conf, because we only want to load the module once, and because you cannot load modules in a Virtual Host. This way, we can designate which sites use what connector. Lets do ColdFusion 9.

Blog Search