" "

Building a Simple PHP Twitter Client Without Twitter October 18th, 2008

Tags: , , ,

Part One – Getting to Grips with GNIP

Okay so now I suppose I better start doing some geek stuff as its been far too long. What I’m going to try and accomplish is to build a simple Twitter client using PHP and GNIP and as little help from the Twitter API. Sure this may fail badly but we’ll learn something along the way. Why Twitter? Well I do lots of stuff with Twitter data, so why not. But I also want to demonstrate the power of GNIP to you as well as showing that there are ways to be friendly to Twitter & other providers without having to hammer their API’s.

Read More »

Impresive MySQL stats August 3rd, 2008

Tags: , ,

So I’m doing something that relies on MySQL a lot. Last night I had to test a rebuild process that we would use if there was a failure in our systems. Worst case secnairo would be we would have lost about a weeks data and need to reinsert the whole lot.

So I wrote a quick and nasty PHP script with multiple nested foreach() loops, yeah I know what your thinking, but as I said, it was a quick and nasty script. Basically all this script done was parse a directory full off XML files and based upon the content, perform multiple SELECT, INSERT or UPDATE based on the data per element in the given XML file.

So, on my little iMac (24″, 4GB RAM, 1TB Drive) the following are the stats from the completition of the script.

Total Processing Time: 4975.59566307 seconds.
Total DB Inserts: 1,961,000
Total Selects: 12,035,743
Total Updates: 10,465,071

This all translates to;

Inserts Per Second: 394.12
Selects Per Second: 2,418.95
Updates Per Second: 2,103.28

Keep in mind, I was watching a movie at the same time and that there has been no optimisation carried out on the server at all (Although the DB is fairly well normalised). Table format was MyISAM.

Now imagine what MySQL could do on an optimised Linux server with custom optimisations to make it faster. I am quite impresed given the workstation I was working on and the complexity of the queries we are doing. Pat on head for MySQL. Well done.

So much for a global company. How Apple & Others treat Europeans July 15th, 2008

Tags: , , ,

Reading Pat Phelan’s blog yesterday about Apple and how it restricts the rest of the world as to what it can purchase through iTunes got me thinking. I’ve long known that Apple deploy such practices as do many other organizations. I don’t think its right at all, yet have thought I would have been a crackpot for thinking same. If I buy an iPhone to have access to all the applications and Games, that means I want access to ALL the games and applications and not a limited subset. Alas they (Apple) cannot be fooled by the use of a mere proxy server, you need to supply a US address too, thus making it impossible for us Europeans to but such games as “Insert desired super cool game not currently available in Europe”.

Another thing Apple engage in which I am also not a fan of, is over charging or taxing their European customers. For example, I recently bought an iMAC 24″ With the 3.06 Proc. Its US cost is $2,199.00, yet its Euro Price is €1,919.00. If the exchange rate were taken into consideration it would be €1,377.43 Euro (15th July 08 – 08:00). This sort of thing is not confined just to Apple, recently I’ve experienced the same sort of practices with Adobe, so I am guessing there are others too.

You could argue that its not possible to keep track of exchange rates. I say balderdash. I know many smaller companies that deploy either daily adjustments or realtime adjustments in order to be as competitive as possible. Yes, Apple don’t need to be competitive to an extent, however they do need to start looking after their customers in Europe and not discriminate against them based simply on where you are coming from. Currently a European customer in not as equal as a US customer to Apple it would appear, from my recent use of iTunes anyhow.

I don’t subscribe to the content licence argument either. If it could be arranged with the music companies it can be arranged with the TV,Film and Software houses. Then Apple may be really disruptive, changing EU broadcasting too.

Calling for a boycott of such products from their vendors is at best a pipe dream. Yes I know they are discriminating against me, but I still want to use their products, or indeed in some circumstances I may need to use them. So how do we register our complaints, how are we heard? Is blogging about it going to be enough? I don’t know, is my answer, but hell I’ll give it a try and add to the growing choir.

So back to the thinking, here is one for someone with a bit of time on their hands. Setup up a buinssess selling proxy serivces Not only web based proxy services, but also real world proxy services, where people order stuff they can’t get in their location so the end up purchasing through you. Yes it would be a pain, to do, but then again I don’t care, I just want my cool iPhone game…. NOW!!!!!!

Goodbye Drupal, Hello WordPress February 22nd, 2008

Tags: ,

Well, finally after ages of messing around, I feel comfortable enough with my theme to switch over to WordPress instead of Drupal. Note, its not complete, but it is getting there. I hope you don’t find too many things broken.

Before I get hit with a lot of mail asking why I ditched Drupal, let me say it was not for any other reason than time. Something which I have very little of these days as projects come in by the truck load.

Read More »

Testing WordPress Super Cache Performance on SLES 10 SP1 using Siege November 30th, 2007

Tags: , , ,

I was reading a post by Donncha recently on the new WordPress plugin, WP Super Cache. He mentioned that he did not know what the performance would be like, which got me thinking about running my own tests to see for myself (I was doing some basic ones anyhow for another idea I had). There are many bloggers using WordPress whom do not know one technical thing (nor should they!), but they should know what its gonna be like for them when their site gets busy.

N.B. My intention here was to just see what would happen. This should not be regarded as a complete proper test, but rather an indicative one. I had limited time and was not arsed doing this 100% correctly.


Read More »

Company:
Rush Hour Analytics
Cell:
+353863805070
Location:
Limerick
 
Munster
 
Ireland