Doing blog migration from wordpress and drupal, below are the basic guidelines if you plan to use a brute migration. It is only advisable to do this for total blogs of less than a thousand.

1. Map tables and fields from database source to destination.

2. Generate the select query statement and make use 'AS' keyword to assign the target field

3. From your sql viewer export the queried data to a INSERT formmatted query.

4. Run the generated statements and wholah data has been migrated.

Kinda wierd writing this items, it is more like a reminder next time I try to do another brute migration.

After updating to the new format, I still adopted the simple and bare theme for this website. Loading takes around 1600ms on uncached state, and around 500ms cached. Images are loaded on demand, which improves overall performance.

After using wordpress and drupal for the last 10 years, I have migrated my blog to a platform similar to jekyll a static site generator. I have made this decision after my drupal accounts have been compromised thrice this year. Despite my knowledge for both systems [wordpress and drupal], recovery and clean up takes its tolls specially for their volumes and also for the other sites i'm hosting.

Created a simple and quick entry for the Scirra Game Jam. Due to the lack of time and resources, aiming for the main price was far fetched, so instead I aimed for the personal license. The only restriction was during development, only the free version of construct 2 should be used.

After a few hours work I finished Earthshakers, a platform auto-runner game. The game was intended for both mobile and web browsers. The mechanics are simple tap to shoot and reach the underground labyrinth.

Below are the list of winners for the Construct 2 Underground Game Jam. There were three winners of the personal licence, and  fortunately our entry was one of the winners! Woohoo.

After a having a couple of small project that require CI and simple CRUD implementation, I have created a generic library plugin for Code Igniter. It is used for prototyping and for simple projects. It is also my first entry to my github account.

The implementation of this library only requires you to perform an select statement or you just need to define the database table. The library is compatible with the newer version of code igniter and primeui.