I have just transitioned into the next round of browser ping pong. I am an openSUSE Linux user. For years, I had been an avid Firefox user. Even as people were ranting and raving about Google-Chrome I remained true to Firefox for quite some time.
But then out of curiosity in the summer of 2010 I gave Google-Chrome a try and to my surprise was greatly impressed. My Firefox had become slow (perhaps because to many add-ons were installed). Google-Chrome was fast, very fast. Also, the installation of add-ons was very nice. Searching for add-ons and installing them can’t get much better than in Google-Chrome. Firefox still persists in forcing a restart after the installation of add-ons. It is reminiscent of the Windows OS, which seems to believe that the ultimate purpose of an OS is to reboot. As a Linux user I am accustomed to making major changes to the installation and using them immediately without the need of an interim reboot.
Anyway, back to the Browser tale. Google-Chrome was impressive on many fronts. A few things had been bugging me but I was willing to live with them. One thing I missed was the quick ability to switch search engines that one has in Firefox. Another was the lack of a sidebar. Normally, that is not a big deal but the Delicious add-on for Firefox is very nice and makes good use of the sidebar. Another thing that is bothersome with Google-Chrome is that it crashes whenever I try to upload an Image from disk. This is a well documented bug. The routine of watching Google-Chrome disappear, switching to Firefox to upload a file and then return to Google-Crome, becomes old very quickly.
Another thing that happened just today is that Google-Chrome decided to start displaying links with a red background. This is not a bug in WordPress. It happens an many different websites and I cannot figure out why.
So I then upgraded Chrome from version 7.x to 8.0 hoping that this would solve those two problems. Well, it didn’t. So that was the last straw. Looks like I’ll be Firefox user for a while until Google comes out with another release. It’s nice that the two of them keep fighting it out. It improves the product. In this process I was also pleasantly surprised to learn that xMarks is back in business. So syncing my browser bookmarks is once again simplified.
There are several Twitter accounts, which offer a regular stream of Quotes on a variety of topics. Examples are @iwisenet and @tweetsayings. Using a few tools available on my Linux distribution I’ve created a very simple automated setup for regularly sending tweets from a Twitter account. There are likely a myriad of software products available for doing this a bit more professionally but I though some of you might be interested in something you can do from own PC, assuming you have the appropriate tools and like playing around.
There are only three requirements:
- A means of storing and retrieving the tweets
- A means of automated processing
- A means of posting the tweets to your Twitter account
I used the following tools which are avalalble in most Linux distributions but other tools could be used instead.
- For storing the tweets – MySql
- For automated processing – Cron and Bash Shell
- For posting the tweets – the Twitter Command Line API and curl
Step One – Setup a MySql Table
CREATE TABLE texts
lastused timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
usagecount int(11) NOT NULL default '0',
saying varchar(140) collate utf8_unicode_ci NOT NULL COMMENT 'Twitter Status Text',
KEY usagecount (usagecount),
KEY lastused (lastused)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
This table stores the tweets. The column ‘lastused’ is automatically updated by the DB upon an update operation. This gives you the ability to cycle through the tweets when they are retrieved with the appropriate query (see below)
Step Two – The Cron Job
30 14 * * * /twitterupdate.sh
This job updates the twitter status once per day. Vary the frequency by adjusting the crontable parameters.
Step Three – The Shell Script
## Bash cron job for updating a twitter status using curl, the twitter API and MySql Table
## - cron daemon
## - bash shell
## - curl
## - MySql
## (Note: Twitter Status refers to the actual 'tweet' that is displayed for the account)
## Operational Description: The MySql Table contains a listing of Status Updates for the twitter
## account. The frequency of the updates is determined by the settings for the cron job, which
## must call this shell script. This script performs the following tasks
## - read one Status Update Text from the DB. The status text which has not been used
## for the longest time is selected.
## - An update is performed on the DB for this record incrementing the usage count and last used
## - The text is sent to the twitter API using curl to perform an update of the account status.
twitterUsername="<twitter user name>"
mysqlDbName="<MySql DB Name>"
selectQuery="select saying from texts order by lastused, usagecount limit 1;"
updateQuery="update texts set usagecount = usagecount + 1 order by lastused, usagecount limit 1;"
## Retrieve Next Text from the DB
echo $selectQuery > query.sql
statusText=`/usr/bin/mysql -s --user="$mysqlUsername" --password="$mysqlPassword" "$mysqlDbName" < query.sql`
## Update Text usage counter
echo $updateQuery > query.sql
/usr/bin/mysql -s --user="$mysqlUsername" --password="$mysqlPassword" "$mysqlDbName" < query.sql
## Update Twitter Status
/usr/bin/curl --basic --user $twitterUsername:$twitterPassword --data status="$statusText" http://twitter.com/statuses/update.xml >/dev/null 2>&1
This script performs all the steps necessary. With a little tweaking other tools could be used. It would certainly be possible to do this with a plain text file and eliminate the need for MySql but that would require another script and would be a bit more involved. Another command line URL utility besides curl is also conceivable but that is what Twitter recommended and I have curl so I didn’t bother looking for alternatives.
Lot’s of fun …