Bluesmoke

… just a few ideas for you to think about

Archive for the ‘Reviews’ Category

Number one in Google -a quick primer

Friday, May 7th, 2010

number one in Google

What does it take to get to number one in Google? – its easy!- copy a unique string of  words on your site that nobody else has on theirs…paste it in a search… and you’ll  probably be top or thereabouts

Thats the end of my post-  job done.

If it were only that simple!  But thats what most people want after all  - to be No1  in Google . . I’m stating the obvious but actually by going through the above simple exercise highlights a few  important questions before we even start:

  • Is that phrase ever going to be type into a search engine ever again?
  • does it describe accurately what we are promoting?
  • when users find us what do we want them to do next ?

I’m assuming the answer to the last question is not ‘leave as soon as possible’ although you may be surprised how many do  if you look at your home page stats.
You may have a site that is primarily for generating advertising revenue and so you will want to generate maximum through traffic, where ‘success’ will be exiting your site via a ‘revenue juicy’ click through ad.

However if you have  an ecommerce site you will want to channel  attention to the right pages rather than allow them to leave straight away.  People in browsing mode have the attention span akin to a goldfish swimming in Jack Daniels, so plan how you can grab their attention pretty quickly before they exit without getting beyond your home page.

Either way the same formula applies: more traffic=more revenue. So the same general strategy to get them there in the first place should be the  same, i.e. choosing that all important search phrase for your pages.

Choosing the most effective search words

Wo we need to construct a search phrase that is  not too long and obscure (i.e., its never likely to be typed in a search) and not too short, otherwise the competition will leave you languishing in 10,000th position.

Ideally choose  2 or 3 words particularly relevant to the  page’s content on your website. Also  if the website address, page name (my-key-phrase.htm), page title and page content all have ‘related’ keywords then bingo! –  although its more than likely the web address will not be part of the key phrase.

Note of caution here – Google’s algorithmic nose can sniff out anything contrived, so always be cautious about overloading the page with the key phrase words etc. and start off your optimising by reading your page content first.  Check to make sure the content is relevant,  focused and high quality.

You can then start to tell the world about it by making  it more search engine  ’friendly’  by providing the contextual cues (appropriate page title headings, subheadings, image names).  I always recommend viewing your page in  a text based browser as this is how search engines index pages. ( Lynx is a traditional  text based browser although www.textise.net allows you to do the same thing much more quickly)

External links

Google ranks the importance of your site not just by its content but also by the links to it from other sites on the Internet.  The more reputable these other sites are the more ‘cred’ they add to your site in Google’s eyes, particularly if they have the key phrase words in the link itself, (e.g. ‘my unique search phrase‘  rather than click here)

Job done? not quite – I’ve saved the best till last.

Do Your Homework

Just before you go key search phrase crazy, you have to bear in mind one  minor inconvenience – your supremely crafted key search terms may never be entered in a search – double doh!! And the only way to find this out is to do a quick check to see how often its typed in.

Lots of tools out there to help with this, but Google’s keyword tool is the quickest and easiest.  If you’re not sure what is the best phrase try Google’s suggestion tool.  The difference between the two is subtle but important- the latter helps you come up with a  phrase better matched to your page content. (i.e you may think you have found a great winning phrase that matches your page content perfectly  but Google may not agree so best to get it from the horse’s mouth)

That’s certainly enough to get started, but to summarize just a couple of closing thoughts

Your site will get found if:

  • the content is worth looking for
  • it has a definite market  niche
  • there is a market for it in the first place!

Embedded Legacy

Thursday, April 15th, 2010

The old saying ‘Information is power’ has never been more true in the Online environment. With Search Engines and Social Media sites ratcheting up billions in advertising revenue simply by collating all the data that is freely available out there, its becoming quite a literally ‘a free for all’.

But where do they get all this free information and data  from, and who writes it all?  From Us.  Me and you. As the amount of personal information about us all is being voluntarily uploaded via Social networking media,  the web Megaliths like Google with its massive collating  and repository resources, consume it heartily as  its daily bread and butter.

All tends to sound a bit neurotic I know, but I often talk to cautious web users who are almost phobic about signing up to anything that snaps of social media irresponsibility.  And in many ways I can’t blame them.  I did think this was more down to a fear of the great ‘online unknown’ and a paranoia of all things technological.  But could there also be a smattering of our naivity and passiveness creeping in,  as Google street view cameras capture us and our homes in greater and greater detail (now 3D!).

We can so easily fall in love  with our online social media apps and tools. They’re free but for a good reason. Very large amounts of data  yield a  proportionately increasing commercial return when packaged and served up correctly.

For a moment let’s indulge the scenario that all you have ever published on the web doesn’t ever disappear, but is archived. Archiving does make it sound all respectable and safe but data is archived rather than deleted for a reason, i.e. for future reference.

A recent move by US Library of Congress to archive every tweet ever posted publicly perhaps has come as a bit of a surprise.  Its reasoning is that all our tweets will form a valuable  social commentary of historical events – including all its momentous and trivial moments as they unfold in our public and often our private lives.

Is it my inherent distrust of government tinkering in our webspace or their moves to archive ‘Our’ information without ‘Our’ consent that sets my paranoic alarm bells clanging?

Embed me

There is also a massive surge towards sharing and embedding our social media interactions outside of their current Social Media framework, perhaps as a way of unifying all our separate online social involvements rather than having to start again from scratch every time there is a new kid on the block.

All reputable Social media sites and others including Google invariably have API tools so that content can hooked up to and extracted, repurposed, mashed up and processed on other sites.

A n example of this that proked some online controversy  recently was  the API-mashing of the site foursquare.com.  This site leverages Twitter/Facebook live tweets to provide geographical local town movements we care to relay via mobiles etc in real time.

The site Pleaserobme.com then used Foursquare’s API to build its own site  to highlight how easy it was to take all this shared information about individuals who had given their own home address, and using their realtime tweeting about their whereabouts could then publish which homes would be empty at any given (real)time.

The site now seems to have removed this feature, but made very a serious point: how easy it is  to ‘pull’ in real-time social media data and for the wrong purposes, and also the fact that no-one is really regulating this type of embedded exploitation (self regulation aside).

The embedding of data is now becoming much easier and commonplace.  Twitter has now announced its @anywhere tweet option, which will allow  you to tweet  your comments via other media sites that have this facility, (rather than  via the SM bookmark icon)

There may well be virtuous  ’drivers’ to develop a universally and socially coherent platform for us all to enjoy , although its more likely its do with a fear of a levelling off  in interest (as has happened in Twitter recently) and consequent financial freefall ( the demise of Bebo) which commercially motivates the drive for Social Media sharing  just to stay ahead of the competition.

And lets face it, their success and livelihood is built around how easy and  frequently we can post  our views and opinions,  including our most throwaway comments –  which of course aren’t actually thrown away.

Some web links:

http://news.bbc.co.uk/1/hi/technology/8621297.stm

http://news.bbc.co.uk/1/hi/technology/8570293.stm

http://news.bbc.co.uk/1/hi/technology/8521598.stm

http://foursquare.com/

http://pleaserobme.com/

From Access to MySQL

Thursday, March 11th, 2010

under the hood of databasesUnder the hood of every successful website  there is invariably a database or more likely a whole cluster of them. It is quite literally the driving force in website architecture, and  probably the most important component in managing and delivering content efficiently to the pages of your website. So whether your website is a Mini or a Hummer its time to talk DB’s.

BUT (and its a big but), the learning curve can be steep particularly for the first time database user  - there’s nothing quite as mind boggling as the complexities of Database topology.  And there is no getting away from them –  if you want your website  to perform well and be able to manage content yourself,  it obviously makes sense to have some rudimentary understanding of what is going on in the background.

But where to start? If you have a Mac you may have already come across Filemaker – a  user friendly but quite powerful WYSIWYG relational Database, while the unfortunate Windows sufferer has to be content with MS Access – although once you have a rudimentary understanding of how Access is supposed to work you can certainly see its appeal as a file based ‘lite’ application.
As a website backend DB, MS Access is also relatively easy to implement and integrate. Updates and  backups can be carried out by  dragging and dropping the mdb file on to your hosted web space via FTP (obviously in a secure folder off the web).  It can even be administered using the local copy of Access on your machine. In fact I have deployed a number of eCommerce sites using Access and they have worked surprisingly well, as long as the website does not get too popular (no more than a few concurrent users at a time please!).
Unfortunately however that’s where the plaudits end. As the size of the database increases, as it invariably will do, Access performance starts to degrade significantly . So life on the web can be short lived for our little desktop application. There are many other reasons, including the limitations on concurrent users, security issues, etc why MS Access is not a good idea, more of which are listed here.
Certainly for non Windows web database requirements Access doesn’t get a look in. On Unix based servers, MySQL has proved without doubt the most popular and now the most widespread:
  • It’s Open Source (free-ly available, financially speaking)
  • it’s proven reliability has resulted in widespread implementation.
  • it’s scalability (don’t underestimate this one  - it is running YouTube after all)
  • its ongoing support and development structure

Many hosting companies, even those running Windows based servers, don’t encourage or are reluctant to support  use of Access, and generally advocate using  MSSQL as a windows based alternative – which makes lots of sense as again MS Access can still act as the local  ’front end’ for the web database admin tasks (a unique moment of Microsoft joined up thinking).

So which is best?

Horses for courses here I reckon – arguably the choice can be narrowed to a few main contenders -of the Open Source applications MySQL and PostgreSQL are the first choice for Linux servers; while  MSSQL might be the obvious way to go if your website is on a Windows server.  However the level of  online support and documentation may be the reason why increasing numbers are opting for MySQL even on Windows servers.(also see ‘and finally’ below )

Migrating to MySQL

On one occasion I was told that one of my Access DB websites was being removed immediately from the shared server because it was causing performance problems for all other sites on the server (MS Access was identified as the culprit) – which prompted me to migrate fairly quickly to MySQL. however this turned out in practice not to be so quick -it certainly wasn’t a straight swap. Again OS tools came to the rescue to make the process easier, although there were one or two coughs and splutters before the website DB ‘engine’ came back to life

Eureka moment

Having a ‘free’ and  scalable database architecture just makes sense  - from the new web venture through to the monolithic sites like YouTube.
The lack of a front end WYSIWYG can be a bit daunting  for the novice though,  and tackling MySQL through a command prompt may not make for Rapid Application Deployment, particularly if you are not familiar with SQL syntax – is the  lack of it MySQL ‘s achilles heel? Not at all,  there are shed loads of excellent web based Open Source  and proprietary interface tools for MySQL such as MySQLAdmin, MySQLyog, Heidi etc etc which will do the job effectively. In any case for most of the day to day website requirements much of the transactional activity will be hidden behind a well designed admin ‘backend’ .

And finally…

…there is some good news for Die  hard Access users also – you can now  use it  for the front end admin for your  MySQL database through So I was surprised recently to find out that the MySQL guys have launched
Further info at:
see also limits on Access databases at:
http://blogs.msdn.com/access/archive/2006/06/05/access-2007-limits.aspx

Facebook DB architecture:

http://glinden.blogspot.com/2008/05/scaling-facebooks-databases.html

Development of youtube architecture vid: