Andrew Clarke

I architect and create secure, scalable and useful internet applications. I help make business decisions, manage projects, develop databases and write code.

With fifteen years of internet and e-commerce development experience, I can help you define what exactly you need, and then manage and implement that plan.

You can learn more about me by clicking one of the links across the top.

As of October 1, I've accepted a new full-time position.  I'll be working as a systems analyst on a mobile payments platform.  I'll be responsible for extending the platform and product's reach into some new markets.

If you're one of my existing clients reading this, I'm still here to help you out for the next couple months.  If you need significant ongoing help after this, we'll work together to transfer you to someone else.

I'll be in the Netherlands from May 24-30.  I'm looking for a full-time job, so if you're in the Netherlands and you're hiring, I'd love to come by and meet with you in person during that time.

After recently finishing off Bullhive and Comfort Revolution, I'm available to take on your project.  I'm very much open to full-time employment too, either near Waterloo, ON Canada, in western Europe, or elsewhere.

You'll find a lot more information about me on this site, but here are some of the areas in which I have experience:

• Systems architecture,
• Project management,
• Database architecture & development,
• Internet, intranet and extranet development,
• Technical pre-sales engineering,
• Technical solutions architecture and consulting, and
• Team leading

I've released an updated version of CFScaffold, as well as updated examples at http://www.clarke.ca/cfscaffold/examples.

[Read more →]

I know this is sort of nerdy, but I just noticed that my Amazon Route 53 components have been included in Amazon's list of tools and libraries for Route 53.

It's just nice to get a bit of recognition from Amazon.

Here's a way of locking down and security access to your ColdFusion Administrator, if you're running ColdFusion Enterprise multi-instance.

[Read more →]

Bullhive is live!  Live in closed beta, that is.  Bullhive leases cloud-based computers to traders for financial modelling.  https://bullhive.com

[Read more →]

I'll be attending the Scotch on the Rocks CFML conference March 3-4 in Edinburgh.  Following that I'll be in Switzerland March 5-11.  Please contact me if you'd like to meet up with me during that time!

[Read more →]

This is my take on the CRTC's recent ruling on usage-based billing.  Fortunately Prime Minister Stephen Harper has promised to reverse this decision.  Let's hope it happens!

[Read more →]

I've released a new version of CFScaffold.  Some of the bigger changes are:
- You can now call any view from your own code, without having to use CFScaffold as a monolithic application.  For example, if you want to just display an edit form for an entity, or even just use CFScaffold to save an object created in your own code, you can do that.
- I've integrated Greg Moser's EntitySmartList into CFScaffold, so you can generate lists of objects in an entity using EntitySmartList's URL parameters.
- CFScaffold has integrated granular security for each action and display.  By default, the security check returns true, and you can override the security object to implement your own security.
- I've started writing documentation at http://www.clarke.ca/page.cfm/projects/cfscaffold.
- There are more automatic checks in place to ensure that valid data is being added.  These checks should all take place both in cfform tags when possible, as well as on the server.
- I've been using CFScaffold extensively on Windows/Adobe ColdFusion 9.0.1/MSSQL as well as Mac OS X/Railo 3.2.1/MySQL.
- There are numerous other bug fixes and small feature enhancements.  You can look in the comments at the end of any file to see what's changed when.