Author: Wade

MySql in C# is rather painless using the MySQL Connector for .net, but one thing it is missing is a no-frills, no extra requirements, no pre-defined ERD return a row as an instance of a class function. Coming from a PHP background, I love the PDO function fetchObject(), it’s just right there and you get … Read More “C# MySqlDataReader – “one line” function to return a row as an instance of a class.” »

I love Cloudant, simple as, their implementation of CouchDB as a DDaaS (as opposed to DBaaS) has no real competitor – as CouchDB develop’s, that may, of course, become a problem as it gives dominance in a market, but for now, we’re good. One of their best features is the dbcopy command, this copies the … Read More “Cloudant’s Rather Awesome dbcopy for re-reducing the output of existing map/reduce data.” »

So often you find yourself needing a list of countries for use in your software and I keep having to re-use this code so here is a list of countries with their ISO codes in a variety of formats you can simply just use. # C# Dictionary ISO { countrycode, countryname } list new Dictionary<string, … Read More “Country/Currency List for C#, JSON, PHP and HTML select” »

Amazon’s EC2 platform has a very in-depth console which allows you to do a lot, but what if you want to automate some of the processes or handling servers? I’ve been working with EC2 a lot recently and automating server starting/stopping based on parameters of the system we use here at MediaSkunkworks and thought I’d … Read More “Using Amazon EC2 with C# .net” »

Ondřej Surý has released apt-get’table packages for PHP 5.4 on Ubuntu.  Instructions and installation are available from https://launchpad.net/~ondrej/+archive/php5 . Think I’ll keep custom building for now so I get total control but for the majority of people this is better than waiting until potentially October for it to hit the official channels.

Needed to use this recently to create a specificity parameter for an API at work, it gives you a key/value array from an ISO date string regardless of what is actually set in the string (e.g. if you give 2011-06-07 04 you’ll get an array back as array(‘year’=>2011, ‘month’ => 6, ‘day’ => 7, ‘hour’ … Read More “Regular Expression (Regex) For Date part extraction/array split” »

In my leedsphp talk last week I mentioned making a developer (and consumers) life easier by automatically implementing the allow methods functionality that your API may expose (e.g. you call PUT on a URL that only allows GET or POST). I did have an example slide there showing how to implement but I thought I’d … Read More “Automating “Implemented methods” for a web based API” »

Finally got around to uploading my slides (sorry for the delay!) for my talk at leedsphp on Monday 18th. They are now available online at http://www.slideshare.net/wadewomersley/building-a-horizontally-scalable-api-in-php