Back in 2007 I wrote about CocoaMySQL, a small GUI for MySQL that allows you to manipulate and manage MySQL databases through a native Cocoa application. Since then development of CocoaMySQL died off and it has since been abandoned. A shame really as it did have several frustrating quirks that spoiled an otherwise great application.
Recently I came across Sequel Pro, a fork of CocoaMySQL that has big plans to stabilise the core code and turn it into a multi-engine database management tool (with support for SQLite and PostgresSQL scheduled for the future). Despite being available since early 2008 I’ve seen very little mention of Sequel Pro.
HeadSpace has had a meta-robots module for some time. This module allows you to set various options on a page-by-page basis that determine how search engines (and other bots) process the data on that page. This is fine in general, but sometimes it’s necessary to have a little more control, and to this end I’ve created a new module that let’s you change the follow/nofollow attribute of certain links.
First it’s worth explaining what nofollow does. Nofollow is a tag that was invented by Google to allow website owners to prevent a link from affecting it’s target site’s search ranking – the link is not followed. In effect this gives you some control over how search engines index your site. The tag itself is very simple:
<a href="http://google.com" rel="nofollow">Google</a>
If you make use of any of my plugins then it’s likely you’ve noticed several fundamental changes, along with some tougher system requirements. I think now is a good time to actually write about these changes and discuss the reasons behind them.
I’ll start by making an admission: the release of WordPress 2.7 was a big headache for me. There, I’ve said it. I’ll continue on by stating that I love all the new features, and appreciate the updated interface and the amount of work that has gone into it (and continues to go into it). However, as a developer with around 20 plugins for WordPress, the changes in 2.7 were substantial enough that that it took considerable effort to get all my plugins working ‘properly’ again.
Yes, this is one of those late-late February New Year round-ups! And what a year it’s been in general. Moving back to the ‘real world’ (aka London) has now come and gone, and I’m safely wrapped up in trying to stay ahead of the world’s general downward curve.
This site has fully moved from it’s previous Dreamhost location and is now being hosted by Slicehost. This has allowed me to add bug tracking through Redmine, which has helped considerably in keeping track of the state of things. I’m still experimenting with the right settings, and there are occasional weekend dips as I move things around, but everything should now be running quite nicely with a combination of Apache and Phusion Passenger. If you’re not afraid of managing your own system then Slicehost are highly recommended.
Living in Guangzhou had many advantages, and one of the biggest was the cheap availability of food. As the centre of Cantonese cuisine, Guangzhou (previously called Canton) is more than well placed to provide some tasty treats. My brief experience with Northern food revealed a somewhat stodgy bread-based diet and combined with my return to London I discovered that I missed real Guangzhou Dim Sum.
Since then I’ve tried several places in an attempt to find something satisfactory. First was an anonymous restaurant in China Town, which in retrospect is probably not a good place to find Chinese food (aimed more at tourists than anything else). Next up was a hopeful Chinese/Jazz fusion, courtesy of Shanghai Blues. I left here feeling disappointed – the dumplings tasted bready, the contents were indistinct. Prices were also too high.
After a prolonged lapse I will soon be restarting my attempts to learn Chinese by signing up for proper classroom-based lessons. My hope is that I’ll be able to learn better than previous DIY attempts. I’ve even been provided with a student ID card, effectively turning me into a bona-fide student once more.
On the development side of things I’ve finally updated all of my WordPress plugins to support the latest version of WordPress, as well as fixing most outstanding problems. I’m also planning to distribute the plugin library that I’ve developed over the course of the past few years. This will likely take place as a series of articles documentating how to use it. Hopefully this will prove useful either as the basis for other plugins, or simply as a learning resource.
Next week sees the beginning of the Chinese Year of the Rat, and with it millions of Chinese will celebrating with their families. The rat symbolises wealth and prosperity to the Chinese, and I’m hoping this is a good sign as by the end of the month I will be moving to London to restart Life 2.0.
My feelings about this are mixed. In many respects I’m looking forward to having access to all the modern goodness that I’m used to, but in others I’m expecting severe culture-shock as I rejoin the familiar rat-race (pun intended). Like many Chinese at this time of the year I shall be catching up with family (although hopefully not hampered by extreme weather conditions). Following that I’ll be faced with the rather more difficult prospect of finding employment and a place to live.
Seeing as the internet is ideally built for self-promotion I thought I may as well mention that if anyone happens to be in the position of needing a full-time London-based developer then please do get in touch. There’s some more details about my skills here, and it should be noted that I can do other things besides PHP/WordPress. Pimp-mode over.
I’m cold. Very cold. For the past two weeks China has been experiencing the worst winter in fifty years. Much of the country has been covered in snow. Living in the relatively warmer climates of Southern China you would expect winter to be a mild affair. Last year it was, but this year the temperatures have dropped to around 4 degrees (daytime). Now this isn’t such a low number when compared to other parts of the country, but the important factor is that the South is completely unprepared for such weather. For example, the building I live in has absolutely no insulation, the windows have gaps along the edges, the door leading to the balcony is an interior door, and there is no heating of any kind. The building itself is made of concrete and this only seems to intensify the exterior temperature. I can safely say that this is the coldest winter I’ve ever experienced – cold, damp, and miserable. Prague seems balmy in comparison.
The weather has affected the country just before the main Chinese New Year holiday, and right at the time when millions of migrant workers want to return home. Apparently 500,000 of them were stranded at the main train station here in Guangzhou, due to cancelled trains elsewhere on the network. The situation is so bad that the army was called in to calm the situation. The estimated cost to the country is about 18 billion yuan. Ouch.
All I can say is roll on spring.
I’ve got a substantial update to Redirection just about finished off and ready for release. Rather than dropping this out and running the risk of upsetting a lot of websites, I’ve decided to try a private beta-test to iron out any final problems.
The new version gives much better management of redirections and error logging, and adds very powerful support for native Apache .htaccess files (i.e. you can use Redirection to edit .htaccess). If this sounds like something you want to help out with then drop me a line. The only requirement for this is that you are familiar with backing up and restoring your site database, or that you have a test WordPress site. The biggest help will be from people who are already using Redirection and have data to import into the new version.
Thanks in advance for any help!
After two years in China I finally managed to do something I’ve been planning to do for a long time, namely visit Beijing. As Southern China is such a very long way from the North, Christmas seemed as good a time as any, and after some last-minute clicking I had a flight and hotel booked to see me through the Christmas period.
Not only is Beijing geographically distant from Guangzhou, it’s also different in most other respects. The people look different, they behave different, they eat different, and they speak different. It would be easy to convince yourself you are in a different country entirely.
