My Macbook Broke “sobs”

I have started doing development on my iPad which should be interesting.

The reasons is that my Macbook broke recently “sob” so I have been working on Windows again for a bit which is not too bad… But there are things that I miss like the Terminal and Alfred App. While I have found ways to make Windows work in a similar way it just isn’t the same.

The solution for me then is to move all of my development into the “cloud”. I say that in quotes because the cloud lives in my company’s data centre :D . So I have been using Vim (with a ton of cool plugins) and SSH for most of my development now. I read this blog post a while ago and wanted to try it out but I didn’t have an iPad then. Now I do so I am going to give it a bash (hehe, no pun intended).

I am currently using the zaTelnet app but I want to move to iSSH sometime soon. zaTelnet is not too bad but it is a bit like Putty which I find a bit basic, also it does not support VNC or X Server.

The server is running Ubuntu Server 12.04 on Citrix Xenserver. Then it just has the standard LAMP stack as well as Xdebug for PHP and Drupal development. I am using Vim for writing code with the NERDTree plugin which is a file manager sidebar toggle allowing you to open multiple file in Vim without needing to know all of the file paths.

I am also running Tmux which allows you to have multiple window sessions inside your terminal and you can also save those sessions and come back to them whenever you feel like it

I will be blogging about how I find working on the iPad in a series of blog posts :) so look out for that. Also if you would like me to post my Vim configs and plugins and any other configuration files let me know in the comments or send me an email.

The Awesomeness of PHP __autoload

Many of you have probably written or at least tried to write a PHP framework at some point during your career. The best way to write a frameworks, in my very humble opinion, is to use object oriented programming (OOP) and a sort of model/view/controller (MVC) architecture. In most cases this means that by the end of writing a sort of usable system you will have a large amount of files filled with different bits of code.

In the bad old days before PHP 5 you would have an index.php file and that looked something like this:

 * Index file of Xframework.

// Include all sorts of useful stuff...
include_once '/tag/development/bootstrap.html';
include_once '/app/model/x.class.html';
include_once '/app/model/theme.class.html';
include_once '/app/controller/user.class.html';
include_once '/app/view/index.html';

// Now we can finally do something.
$x = new x();

Wouldn’t it be really nice if we could just write the code without having to worry about including millions of files everywhere, which can become a pain in terms of maintainability.

Enter __autoload() in PHP5. YAY! All our troubles magically disappear. Well not really, but your life is made slightly easier. So instead of the above, you now have:

 * Improved index file of Xframework.

// Our pretty __autoload() function.
function __autoload($classname) {
  include_once '/app/classes/'. $classname .'/tag/development/.html';

// Run the framework.
$x = new x_controller();

Using __autoload should theoretically also improve the speed at which your app loads because you only load the files that are needed at the time.

You could also do some really complex configurations like the below for example:

 * A more complex __autoload example for Xframework.

// Autoload some classes.
function __autoload($classname) {
  $class = explode('_'. $classname);

  $class_file = $class[0] .'/tag/development/.html';
  $class_type = $class[1];

  // Include the class.
  include_once '/app/'. $class_type .'/index.html'. #class_file;

// Let's run the app.
$x = new x_controller();

In the example above the autoload function is checking the class name for a type. The type could be, for example, model, view, controller, elephant or whatever you wanted it to be. That type is the directory where the class is stored. In the example we called the x_controller class. So that class would be located at /app/controller/x.php, the same would be true if you wanted it to be x_model or x_view.

This most definitely makes my life easier when I write PHP applications. If you spend a lot of time writing PHP applications and don’t use a specific framework for the job I would suggest that you put together a rough toolkit for yourself using __autoload() as the heart.

SQLite3 + Dropbox == Awesome

Dropbox is one of the coolest apps I have ever used and everyone knows how to use it. I can tell my clients to Dropbox me files and they don’t roll their eyes. Finally something useful out there. No, this isn’t an advert for Dropbox I will explain my excitement in a minute.

I wrote a PHP/MySQL contact manager for a client a little while ago, it was the successor to an Excel VBA app that succeeded a Psion Series 3 from 1993. So the client was very happy with the system everything working perfectly. But then he wants to be able to access his database of contacts from other computers as well (work / home / etc…). Initially I was going to build an addon that allowed him to export a file and import it on the other end. But I didn’t really like that idea because it relies too much on the client to get it right, which is not a good thing at all. (Think late night phone calls and weekends filled with a moaning client)

It took a while to realise that perhaps Dropbox could do exactly what I wanted, the thing that held me up was MySQL. Enter SQLite3. I have know about SQLite3 for a while now but I have never used it much. I knew it was a portable database that lived in a single file but have never had a use for it. Until now.

PHP also makes it really simple to convert from a MySQL database to a SQLite3 database, thought I did spend a lot of time fiddling with export tools. I ended up porting the table structure and then writing a simple MySQL query that pushed all the data into the SQLite3 database. It took me around two hours to convert the contact manager from MySQL to SQLite3 which is not bad. All the queries work without needing to change, basically you just change any mysql_* function to sqlite_* and hey presto you’re done :) .

And for the cherry on top I use Dropbox to store the SQLite3 database and then reference it from the PHP application running in XAMPP on his local machines. Then whenever he updates his database on one computer it updates them all. Also with Dropbox he can work offline as well and then sync when he connects.

Of course I know this is not the elixir to everything but for something simple like this where there is one guy using an app on several computers it is perfect.

I think maybe for my next project I will start working on building a Dropbox clone to use in my own office, maybe with a few extra features more useful to developers. Haha, no… but then again…