Home
Blog
About
Coding
Websites
Photos
Twit-Map
Links
Only Idiots Assume - Blog Home

Archive for May, 2010

Seriously back up your databases!

No comments

Backups Backups and more Backups, always an important mantra. I was surprised to find that a fellow geek wasn’t backing up his MySQL database that runs his website. Yea he has backups for all the code files, but not for his content!

It frightened me when I found out how many people don’t backup their websites SQL databases. Every WordPress blog runs off of a SQL (normally MySQL) database, if you use a WP-Hosted blog then your safe as they back it up for you. If you host your own WP blog (or geeklog, drupal, etc, etc) then your backups are up to you!

It is for that reason that I have just finished knocking together a page detailing how my simple Linux script backups up my databases at regular intervals (some hourly, some every two, some once a day!) zips them and emails the smaller ones to me!

Check out the article on “Backing up MySQL databases automatically in Linux“.

The Official Twitter iPhone Application

2 comments

Twitter for iPhone App Icon

Twitter for iPhone App Icon

So here it is the long promised Official Twitter iPhone Application, first impression upon loading it from the Apple AppStore was that the icon needs a bit of work, almost like it had been rushed.

But more importantly what is the application like? Opening the app up for the first time presented me with a screen showing the latest tweets of interest and trends. I would show you a screen shot, but stupidly I rushed passed that page and logged in (you get a similar page once logged in).  What did surprise me was the basic authentication method that was used, “please enter your username and password”. Surely the official Twitter app should be using oAuth? If someone like me can slave over a PHP oAuth system, then Twitter’s dev team can create a layer for the iPhone!??

But what do my tweets look like I hear you shout (or I might be imagining it), well they look like this.

Official Twitter iPhone App - Timeline

Official Twitter iPhone App - Timeline

They appear to have taken the standard layout, author image to the left (unless its your’s, then its to the right). @kaivana ‘s tweet is shown with a blue background I presume because it is tweeted at me! Oh and @Tony_Hillier is trying the new app also, hence the random “Tweet Tweet”.

My current iPhone Twitter client is TwitBird Pro, and the only thing that I feel this page is missing is the background image feature that TwitBird Pro offers.  Perhaps @Twitter will take notice and do an update!

The icons along the bottom of the screen provide a few extra views,

  • Speach bubble provides your standard home timeline.
  • @ symbol unsprisingly provides a list of tweets in which you are mentioned.
  • Letter provides your direct messages, grouped by user which is a nice touch.
  • The hand glass provides the more interesting feature allowing for trending topics and searches.
  • The triple dots gives access to the settings and your favourite tweets and lists.

Clicking onto a tweet performs the usual action of showing the tweet along with and links for #hashtags and @usernames. If the tweet is geo-tagged then it will also show a nice little map which can be extended with a click to a full screen view.  The normal access to a users bio is also available when you click on their name, which gives a funky feature allowing you to import their info into an iPhone contact!

Read the rest of this entry »

Bye Bye Facebook! Deleting my account

2 comments

Well it has now happened, I have deleted my @Facebook account (and yes I am aware how fitting it is for me to use facebook’s @twitter address!). There are a few factors which have driven me to this, some more basic than others. In recent weeks I realised that I was only using facebook for one purpose, and that was the events features. All I did was check if my friends were holding a party or a pub trip and then log off.  One thing that I did notice each time that I logged in was the shear amount of rubbish that was in my news feed, why would I care if so and so only needed two more bricks to build their barn!! Add the fact that people were always bulk inviting me to their bands gig on the other side of the country and I got fed up!

The bigger issue of course is (or now was!) their stance on history, I really dont want every website I visit to know everything about me just because I happened to be logged into facebook at the time. There is also the issue regarding  the “facebook-positive”, and yes I did just coin that term. On facebook (and for that matter any site which uses facebook) you can only “like” something, you can’t dislike it. As such with facebook’s iFrames (seariously iFrames in this day and age!), any website I visit is instantly “liked” and “liked” even more if I choose to click the “like” button.

So the process of actually deleting my account! A quick search of the internet gave me enough impotus to actually delete all my data before I even deleted my account! It appears that facebook does not actually delete your data when you close the account, it simply lies dormant on their servers. As such I removed all traces of my facebook life first:

Remove two Email addresses (having to type my password each time!)

  • Set up a fake email and add it to FB allowing me to delete my other email address (another two password inputs!)
  • Remove my Mobile Number.
  • Remove all 37 applications that somehow had found their way into my profile.
  • Trash the content of my profile page (including my picture!).
  • Delete all my likes and dislikes (three clicks for each one!!).
  • Remove my contact information.
  • Delete my photo albums.
  • Delete my links and notes.

I started the process at 15:30 and finished 63 minutes later, every action I took to delete something was slow, and many times facebook just crashed out and I had to login again. So not a quick fix.

The last few stages were easyier, however I did like the “please don’t leave us” page.  It picked three friends and told me how much they would miss me, needless to say it didn’t stop me from leaving!  Following that I got a simple captcha and another password request, I was amused to see the captcha text it was rather fitting.

Leaving Facebook Captcha

Leaving Facebook Captcha

All in all leaving facebook wasn’t that hard, taking the extra precaution of removing all my data too a little longer but should be worth it.

Now I just need someone to re-create facebook’s events system via twitter and all will be sorted! Perhaps I could write it myself!