Vice 2.0 – Social Media

Posted in Humor, Social Media on July 10th, 2011 by jonolan

To a large extent technology doesn’t change people; it only changes the means and venues of the expression of their basic natures. This is quite evident with the advent of Web 2.0 and social media.

People are people and they gather in the same sort of cliques and self-segregate within the “confines” of social media in the same ways, though often based on different selection criteria, as they did and still do in real life (IRL).

And people often have issues maintaining a balance in their lives and Social Media becomes just another vice in their lives or a replacement expression of a previous vice.

Pick Your Poison

Apt, If Snarky, Descriptions of Social Media

It’s “same old, same, old,” in the digital world because we’re still Humanity 1.0 and nobody has identified an upgrade path for us. So settle in with a cool glass of Facebook and we’ll do a few shot of YouTube later. ;-)

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon] [Twitter]

Browser Wars

Posted in Computers, Humor, Microsoft, The Internet on June 28th, 2011 by jonolan

To many people’s minds the war between the various web browsers looks like a schoolyard brawl between two rambunctious boys, with a quiet – possibly special needs – kids sitting off to one side utterly unconcerned and oblivious to the fight raging beside him.


Mmmmmmmm…Glue Good

Yessir; that’s old Internet Explorer off to side eating glue while the other browsers get rowdy, trying to figure out who’ll be king of the internet playground – or so it’s really easy to think.

The thing is though that the “glue” IE is munching on is business critical Microsoft applications such as Office and SharePoint, and a plethora of other critical web-based or web-enabled systems that were designed to work natively with IE but which either do not function correctly with Firefox or Chrome or which require modifications to those browsers’ settings – Firefox users, think about:config – in order to work correctly.

Firefox, Chrome, and all the lesser contenders can fight between themselves for the recreational market all they want. Microsoft’s Internet Explorer doesn’t need to be the playground’s biggest bully; it’s busy at work – more like the nerdy straight-A student than the special needs kid.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon] [Twitter]

Deleting Post Revisions

Posted in SQL, Wordpress on April 10th, 2011 by jonolan

WordPress W/ Wrench - Tech and Tool Tips for WordPress.org sitesWhenever you create or edit an article in WordPress, the software suit will save multiple revision copies of the article. This is a waste of server and database resources. Excessive or extraneous revision records will increase the burden on the underlying database.

This will increase loop iterations, data retrieval, and page loading time.

Periodic deletion of these post revision and all their associated metadata should be considered part of your normal maintenance routine. This can be accomplished with a simple SQL statement:

DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

NOTE: Depending on exactly how WordPress was installed, the table names (wp_posts, wp_term_relationships, & wp_postmeta) may need to be modified to include the blog name, e.g., wp_yourblogposts.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon] [Twitter]