type in your query to search makeyougohmm
Things that ... make you go hmmtechnology music video art news reviews and muse on the web

Subscribe by Email

RSS
Comments RSS
Subscribe with Bloglines Subscribe in NewsGator Online
  

Reading lists
2008 OPML [web]
2007 OPML [web]
2006 OPML [web]


Hmm updated pages
PS3 1080p games
Xbox 360 1080p games
Wii browers games

Hmm Downloads
Hmm Toolbar IE/FF Google Subscribed Link

MakeYouGoHmm chosen as CNET top 100 blogs on January 31, 2006
Twitter experiment: 630 days

May 27, 2009

Your resume viewed by HR versus a programmer

developers, Humor — by TDavid @ 6:56 am PST

Thanks Abraham for sharing how the HR department view differs from a programmer’s.

HR versus programmer reading resume

Got a good morning chuckle out of this one, particularly the negative programmer points for “topless in Facebook picture” and “Lists Visual Basic experience first.” What is that about perception being everything?

January 21, 2009

Scripts with self-motivating messages

developers — by TDavid @ 10:23 am PST

Have been working on a script to track our cold call marketing efforts and decided it would be kind of fun and useful to have the script echo back messages to motivate me when certain conditions are met.

self-motivate

The example above shows what we see when we have made no cold calls yet for the day. Cold calling is an art unto itself. It’s a matter of steeling yourself for rejection after rejection after refection to reach a small few people who might be interested. Salespeople tend to look at it as a numbers game. You call X number of people and you’ll find X number of people who might be interested in the products/services you are selling.

Custom self-motivational messages

What other self-motivational messages do you think would be good to add to this script? The "Hey, hit the phones already!" is bound to get old. I’m thinking of dumping the messages in a basic array like this:

$motivational_msg = array(’msg1′,’msg2′,’msg3′);

Then choosing a message at random and displaying. Very similar to a simple quote rotating script. Just off the top of my head here’s some other possible motivational phrases I’m considering:

  • No activity happens without action
  • You’ve got a few minutes, pick up the phone already

What other self-motivational messages can you think of?

Full compliance with FTC Do Not Call List

We are fully compliant with the FTC Do Not Call list and do not call any number that is in this database, BTW. Each number is checked before adding to our calling database and rechecked before calling. We refresh the DNC list regularly for new added/dropped number. Once your number is on this list and 31 days have passed, you should stop receiving most telemarketing calls. As of Feburary 2008, being listed is permanent until you request removal:

Telephone numbers placed on the National Do Not Call Registry will remain on it permanently due to the Do-Not-Call Improvement Act of 2007, which became law in February 2008. Read more about it at http://www.ftc.gov/opa/2008/04/dncfyi.shtm.

If you want to delete your number from the Do Not Call Registry, all you have to do is call from the number to have deleted: 1-888-382-1222 (TTY 1-866-290-4236)

Note to other telemarketers: you can sign up for Do Not Call registry list downloads at https://telemarketing.donotcall.gov/ 

You can receive up to five area codes for free. In the state of Washington there are only five area codes, so that covers us for the entire state. Any area code needed beyond five costs $54/year. This can become expensive for telemarketers what work in locations where there are a lot of area codes like Florida where there are like 22.

November 14, 2008

MySQL queries to sort by most comments by reader in WordPress blog

developers, blogs and podcasting, How To — by TDavid @ 10:10 am PST

There are Wordpress plugins out there that will display who has left the most comments at your WordPress powered blog, but what if you want to query this directly from the MySQL database? Here are the queries required to do that.

Show top 10 commenters at your blog with URL and email address

select count(comment_ID) as a, comment_author, comment_author_url, comment_author_email from wpmughd_comments group by comment_author order by a DESC limit 10;

hmm-topcommenters-112008

Note that Lestat and ^Lestat are the same person. This query comes in handy to see users that have changed their names to leave different comments. Sterling has done this too, adding "chip" between his name in 16 comments, giving him a grand total of 619 comments.

As of this morning’s query this blog has 13,162 approved comments. You can find this number inside the WordPress admin dashboard area, but if you want to query it, use the following:

select count(comment_ID) from wpmughd_comments where comment_approved=‘1′;

For reference:

1 = comment approved
0 = comment pending
spam = comment marked as spam

A past Hmm post shows the query necessary to delete spam comments from a WordPress database.

How many comments have I made as of this writing? 1,976 (15%). I’d be curious from a percentage basis seeing how that compares to other bloggers. Feel free to provide your own percentage stats in the comments or trackback.

I’m going to make an extra effort to get these top commenters on future Hmmcast Live shows. Since they aren’t textually shy, maybe the same will apply to audio versions.

Show top 10 commenters for year at your blog

What if you wanted to find out who the top commenters were by year? Here’s the query to do that:

select count(comment_ID) as a, comment_author, comment_author_url, comment_author_email from wpmughd_comments where comment_date like ‘<strong>2008</strong>%’ group by comment_author order by a DESC limit 10;

Just replace 2008 with the year you want to check.  I ran this for years 2003-2007 as well as 2008 to date. If you’d like to see how many comments were made by year, use the following query:

select count(comment_ID) from wpmughd_comments where comment_approved=‘1′ and comment_date like ‘<strong>2008</strong>%’;

It’s interesting to note the numbers of comments received by year as this blog has grown.

2003 - total comments made: 93

hmm-comments-2003

2004 - total comments made: 561 (+503%)

hmm-comments-2004

2005 - total comments made: 2405 (+329%)

hmm-comments-2005

2006 - total comments made: 4,940 (+105%)

hmm-comments-2006

2007 - total comments made: 3,642 (-26%)

hmm-comments-2007 

2008 - total comments made through November 14, 2008: 1,517

hmm-comments-2008

Notes:

  • the peak for most comments received in the year to this blog was in 2006 and has fallen off noticeably since. I’m sure there are many bloggers who would love to have over 100 comments left a month so believe me I’m not complaining. But for the curious, why has this happened? Are blogs dying as some are suggesting? Or is commenting on blogs themselves dying? I don’t think so. Sure, traffic is down a bit here for the year, but not to the degree of the number of comments dropping off.
  • There are tons of places these days to comment externally like Twitter, FriendFeed. I predict this trend of leaving comments elsewhere will level off somewhat and we’ll see return to commenting at blogs directly. Perhaps this won’t rebound in 2009, but I don’t see things deteriorating much further.
  • There remain good reasons to leave comments at blogs, particularly for bloggers wanting other bloggers to follow blog comments to signature URLs. I’m sure there are a good number of readers who don’t use these microblogging tools, nor care to.
  • In the post dated July 23, 2007 I noted that commenting activity had "increased dramatically" over the last year — statistically, at least from a calendar year basis this appears inaccurate. I’m not sure from reading that post what queries I was using to come to that conclusion, but the numbers above don’t lie.

How is commenting activity going at your blog?

Questions for bloggers: have you seen a similar drop-off? What kinds of things are you doing to invite more comments left on your blog?

Questions for non-bloggers: why aren’t you leaving as many comments on blogs as in year’s past? Or are you leaving more? More directly, what would make you more likely to leave more comments on this blog?

September 8, 2008

Limited utility can get your iPhone app rejected by Apple

news, developers — by TDavid @ 9:54 am PST

Apple is flexing their quality control muscle by rejecting applications based on "limited utility." This, no doubt, a knee jerk response to pulling the expensive iPhone application I Am Rich and spawns a rejection of another app called Pull My Finger. I’m sure there are plenty more what many might call stupid, pointless, worthless applications that Apple is subjectively deciding not to publish and promote.

Techdirt’s Kevin Donavon makes an odd and not quite fitting comparison to Wikipedia, Twitter and CouchSurfing:

While I agree that the application in question has little use, this is a dangerous precedent that could easily have been used to ban Wikipedia, Twitter or CouchSurfing.

I wouldn’t go that far. Look, the web has always been a fairly level playing field for whatever crazy idea someone can come up with and promote. If some dude with an application that does nothing more than be too expensive and it gets popular, hey, more power to them. Same thing with a sophomoric humor application like Pull My Finger.

Wikipedia solved an itch: the ability for regular people to be able to contribute to an encyclopedia collectively. To a much lesser and more niche following, the same applies to Twitter where the cliche ’short and sweet’ and the popularity of text messaging converge. Can’t speak for CouchSurfing because I don’t know much about them but again if they can find success with something you and I might think is silly but others enjoy then more power to them.

Apple has the business right to exercise whatever quality control they want around their App store. If their requirements are too restrictive or too vague this opens the playing field for somebody else to come along and compete. I realize it’s their playing field, but you could always make apps that run on competing phones, yes? Don’t get mad, go out and promote your app on an iPhone competitor that doesn’t reject applications that they deem as having limited utility.

AAPL Stock: rejecting iPhone applications based on limited utility

What do you think? Is using "limited utility" a good idea for quality control? Or should Apple let iPhone have the quality control gauge? I believe the web is already a working example of quality control so that you don’t need to impose additional quality control standards on an application breeding ground if you, well, want it to breed.

Perhaps unrelated and of little concern to those who aren’t AAPL shareholders (disclaimer: I am a current AAPL shareholder) but as one I’d like to see Apple not use subjective rules like this for quality control for iPhone applications. They should ferret out anything that’s a security risk or spammy and if they don’t want porn, fine, that too, but beyond that, let the users be your QA team.

Mr. Donavon is right in one respect: having undefined quality control standards on one project will open a company to these questions about other services that accept submissions from third parties. For that reason alone I think if you are planning on releasing something where other developers submit programs to you, it would be wise not to impose subjective quality control rules.

July 22, 2008

Ending Windows desktop file clutter, help!

productivity, developers — by TDavid @ 7:32 am PST

I’m sure there is a Windows application out there that sorts desktop files into folders automatically already and if there isn’t then somebody should develop one post haste. I complained about desktop clutter almost three years ago, ouch. It’s been on my development to-do list for some time and this morning after staring at my desktop I decided to ask the rest of the world if such an animal already exists. Here’s a picture showing the problem:

windows-desktop-icon-clutter

What I’ve been doing for far too long is manually sorting these desktop files by type into folders. Like image files are sorted into a ’screenshots’ folder and .txt files are sorted into a ‘writing’ folder. It wouldn’t be that involved having a program that watches the desktop folder and then auto sorts any file by type (or custom definition rule) into custom directories defined by the user. It could also be run as a scheduled task once a day to clean out the icons of the day and sort into date stamped archive folders also customizable by the end user. Like say I wanted to have the program auto sort each day’s desktop files into monthly folders like July2008, Aug2008, etc., but the default should be to just sort into one folder so one doesn’t have to make too many clicks to get to the file.

If you’re reading this and have the perfect Windows application in mind — freeware, donationware, shareware or commercial — please pipe up in the comments section below with a link. If it’s a commercial or shareware application feel free to use your own affiliate code and if it looks good to me and you’re the first to mention I’ll buy the program through your link. Or write a blog post and trackback in, your choice. If I only hear crickets on this one I may just have to break out Visual Studio and get this done. I need a useful little app like this.

If it does cost money for this application, it shouldn’t cost very much. This isn’t Photoshop. I’m thinking $20 or less. Thank you in advance for the help.

Update 10:16am PST: Wow, that didn’t take long. Major props to Dean in the comments below for pointing me to Belvedere by Lifehacker’s Adam Pash. Now look at my desktop (right). nice clean Windows desktop As the screenshot displays in the upper left corner I’ve got the recycle bin (emptied) and four shortcuts to the following directories:

icons - this contains shortcuts to all programs with the word ’shortcut’. Windows, by default adds the word shortcut to each shortcut on the desktop.
screenshots - all files matching .jpg, .gif, .png and .bmp are automatically moved off the desktop by Belvedere to this directory.
software - zip files are moved here
writings - .txt, pdf and html files moved here

My most commonly used programs are stored in Rocketdock which is right aligned and takes up a very tiny amount of screen real estate. I linked to my original post about Rocketdock in the comments area below. This is on the short list of useful programs I regularly use on Windows plus it gives it a little of that Mac flavor.

For Mac Readers, Belvedere is based on the Mac program Hazel ($21.95, just about the price I suggested a program like this should cost). I’m not sure what is out there for Linux, but a desktop auto clean-up program should be a standard accessory in every OS. If anybody knows of something similar that will help Linux users keep their desktops tidy, feel free to use the comments below to share.

February 22, 2008

Chumby update arrives

gadgets, developers, customer adventures — by TDavid @ 12:49 pm PST

Been a little while since I’ve mentioned Chumby.

It still sits to the left of my computer monitor, nestled atop the printer, updating me through a dozen different widgets throughout the day on things like stock prices, my horoscope, what happened on this day in history and so on. To date it’s been used like a $179 billboard, rather than anything that useful or revolutionary.

This morning the New York Times has a piece which discusses the monetization scheme for Chumby (emphasis mine):

The New York Times: The Chumby Is Open, but Not for Business

Businesses are free to distribute widgets that use information from their own sites, except if they want those widgets to display advertising or sell something. In that case, the only thing that is open is Chumby’s phone line. It expects to be paid a cut of all the money made over its system.

At first I didn’t see as many Public Service Announcements on Chumby, but I’ve noticed an increase. I realize the Chumby can be modified to function as a lighthttpd server which better suits my needs and would use 100% of my bandwidth. I’m thinking about doing that because I don’t really want or need to see commercials in between widgets. That’s too similar to the TV model of content, commercials, content. Anybody else reading using their Chumby this way and want to share your experiences in the comments below?

My original plans were to do some amount of Chumby widget development but since I don’t have and have little desire to pay $679 to buy the Flash IDE, I’ve kept on the fence. There are some open source alternatives to doing Flash development, but they looked a little time intensive. Is there an open source Chumby Flash lite IDE that somebody reading knows about and is using? I’d still like to get into developing some Chumby widgets, but if this calls for me buying the Flash IDE, it will probably be back-burnered.

Also, anybody running Silverlight applications on Chumby yet? I see some PHP 5.25 binaries were cooked up already.

December 3, 2007

Generate your own 3D Boxes online in JPG, GIF and PNG format

developers, linkdump — by TDavid @ 3:06 pm PST

With 3D Online Package it’s easy to generate 3D box art. Just upload a graphic in PNG, GIF or JPG format for the cover, side and top and the server side program generates the graphic that you can copy and use.

create 3D box art

Added to the online generators list.

November 6, 2007

Comparing The Crunchies to the GRAMMYs is hilarious

news, developers, Humor — by TDavid @ 11:43 am PST

The Crunchies? Please tell me they aren’t going to do this.

The Crunchies are coming, the Crunchies are coming

I’d say no offense before launching into this rant, but I’m still laughing as I type. It’s so crazy, I can’t stop laughing. The Crunchies? The Crunchies!

Om Malik could be the nicest guy in Sillicon Valley for all I know, haven’t met him but will take Mark Evans word. I have met Richard MacManus and Michael Arrington who both seemed like pleasant chaps in person, but the idea of these three along with Venturebeat teaming up and comparing the small start-up world awards to the GRAMMYs is laughable. The combined readership of TechCrunch, Read/WriteWeb, Gigaom and Venturebeat barely dents the number of albums James Blunt’s first CD sold.

Gotta love the comment from cweeb: “Come on Om, don’t bend over to techcrunch everyday.”

Malik contends that “the community will have a lot to say here.” Now this is something I have to see. Voting on the internet can so easily be gamed that I’m extremely cynical of any web system ever being fair and I’m a programmer.

The real reason sites offer awards
I understand the giving out awards at a site — or in this case from multiple sites. This has been happening for many years on the web and they usually mean one thing: more exposure for the site running the awards.

A lot of award sites require or strongly encourage entrants to link back to them and promote to their audience — vote for me, vote for me. It’s a guaranteed proven way to manipulate traffic to the website(s) behind the award. On the eve of Google penalizing sites for selling text links, contributing to link farms and link schemes, The Crunchies team needs to be very careful about how they promote their awards.

And let’s not forget that even a worthless program can get a five star award out there. The Crunchies team has a lot of swashbuckling to do in those chilly awards infested waters, arrr!

Will the Crunchies be the Crappies? We’ll have to wait and see when the details of the awards system are published, but they’ll at least be worth a laugh. Imagine what the award will look like? A bowl of Captain Crunch, maybe? Priceless! Thanks for the morning laugh guys.

November 2, 2007

Author Dori Smith on Javascript ES4: “wake me when there’s something to care about.”

developers — by TDavid @ 11:36 am PST

When it comes to getting excited about new standards or versions of programming languages I tend to take a more reserved approach.

TD listens to Javascript & Ajax bookQuietly — yes, I can be quiet sometimes — evaluating the details myself and when applicable trying to put to some real world applications. A practical, pragmatic approach to consider using any new technology. I would rather spend those breaths of air exploring technology that is here and now instead of fighting standards wars. I’ll defer those battles respectfully to people closer to the metal on the issues. I’m a programmer, not a designer, and while yes web standards still matter to me, this isn’t my area of expertise. The other day I discovered that neither is brewmastery (thanks Sterling and Vince). Sometimes it’s better not to venture too far from the nest.

So recently when I heard that the ECMAScript 4th Edition aka Javascript ES4 is causing blood pressure to be raised in a few folks, I look for people more entrenched to see if there is fire where there is smoke. I’ve met Dori Smith, co-author of Javascript & AJAX, in person and she’s one source on Javascript that I trust.

In Dori’s post yesterday, she doesn’t appear too concerned:

Look, it’s always been the case with JavaScript, and it’s one of the things I like best about the language: it’s all about what works in the majority of browsers. If it doesn’t work in the majority of existing browsers, it’s utterly irrelevant. And given that this group has shown an inability to actually ship, it’s even less relevant.

If you think I’m dismissing ES4 too casually at this point, please feel free as always to correct me below.

OpenSocial, the future and the value of people’s time

developers, customer adventures — by TDavid @ 7:56 am PST

Google’s latest disruptive move, the OpenSocial API, which they are being careful to couch as not being GoogleSocial and instead an open move for the good of users sort of launched last night. It was like attending a fireworks celebration and seeing gigantic rockets in the distance, but a few people coming out in front of a poorly lit campfire holding sparklers saying, “this is all for now.”

Watch in handFacebook is claiming they weren’t briefed on OpenSocial, says Techcrunch, and yet there were a couple Facebook developers in attendance at last night’s campfire, go figure.

The developer view
I was excited, and still am about OpenSocial but was disappointed this morning to read first thing from the API documentation: “All of the details are subject to change, but this preview should give you a general idea of what the API will be like.”

The SDK is still not available.

I was under the impression — wrong it seems — that this was what was launching last night. What actually launched was the document and a 57 minute video showing what companies are involved with OpenSocial and a few demos of how it works. If it’s working now behind the scenes why not release the SDK?

There will be three main data APIs: People, Activities and Persistence. The last one generates the most questions. It’s a neat idea for me to be able to save user activity at our sites using the Persistence data API, but unless my initial review of the docs is flawed, this still has Google directly involved, managing the Persistence layer, yes/no? Or will it be the provider, meaning we can save this data on other people’s servers?

our site’s user activity (OpenSocial enabled) -> persistance layer -> receiving site

Currently it appears the only sandbox environment for OpenSocial is Orkut, with Ning maybe launching a sandbox tonight. If we can send information to be saved on other servers that will help with the traditional data bottlenecks and scaling, but could present some interesting security challenges. I’m very curious how this part will work and need to study some real world examples.

As you might tell from my admittedly jumbled thoughts, I’m still trying to piece this together. I wish the SDK was available now so I could point out specific code. There are examples in the API documentation but I’m reluctant to quote something Google admits can — and probably will — be changing. Guess I need to play around with the Orkut sandbox.

The non-developer perspective
And now for those of you reading who aren’t developers: should you care about OpenSocial? Short answer: wait and see which sites become OpenSocial enabled that you care about.

In theory OpenSocial should make it easier for developers to produce widgets to run inside other sites without additional code. This should make aggregating activity for services like Friendfeed easier to deploy, which means you might have more Facebook-like widgets to insert into other OpenSocial-enabled websites. For example, let’s say this blog became OpenSocial enabled and each commenter had a Hmm profile you could add these widgets to your profile page or perhaps take your comment activity here — if it was made part of an activity stream — elsewhere.

One of the best real world summaries I’ve read so far comes from the Tim Lee at Techdirt:

The fundamental problem facing Orkut, Friendster, LinkedIn and the other social-networking also-rans is that people don’t want to sign onto a dozen different social networking sites to keep up with all their friends. They want to sign up with a single site and see updates for all their friends in one place. As long as each social networking site is a walled garden, only allowing users to connect with other users on the same site, the largest sites will have a huge advantage because people will naturally gravitate to the site most of their friends use.

Someday I believe everybody will have their own home internet address — a virtual home address — just like your physical home address. Those who have their own personal websites that they host on their own domains already do have this home to some degree. Sure, some people will continue to rent which is the web equivalent of spending a lot of time at any third party website over your own (MySpace, Facebook, Live Spaces), but buying a domain and sharing your social network there makes sense. Having thousands of profiles at different sites seems more like a marketing thing than something practical. When these also-rans, as Tim put it in the quote above go offline you could still save the data and activity from these former sites on your own home site. That to me is one of the most powerful parts of OpenSocial for users in the future.

Time isn’t always on our side when it comes to the web
As shared here before, I’m reluctant to spend too much time at third party sites because I’ve seen so many go by the wayside over the years and my time and activity there, unless they offered an export function, went with them. OpenSocial could help change this if our favorite sites become OpenSocial enabled and share our activity streams. This way new connections you make at some third party also ran site can come with you without having to sign up to be your friend again somewhere else.

Powerful, indeed, if that’s how it works.

Or for the cynical types: not enough of the sites we spend time at will care to do the extra work to be OpenSocial enabled and share the activity stream, thus making it a feature that was a big deal for trendy web pooh point oh sites and little else.

We’ll know the answer in a couple years, looking back. Kind of wish I had a time machine on this one to know which one to put effort into. I’m leaning toward opening up activity streams for users across as many of our sites as possible simply because it seems the right thing to do. The most valuable possession for any human being is time and we should seek to never, ever waste that.


Pages (13): [1] 2 3 4 » ... Last »

 

By Category ?
subscribe via RSS to: Hmm Reviews Hmm Reviews
subscribe via RSS to: Hmmcast (podcast) Hmmcast
subscribe via RSS to: blogs and podcasting blogs and podcasting
subscribe via RSS to: customer adventures customer adventures
subscribe via RSS to category: finance finance
subscribe via RSS to category: gaming gaming
subscribe via RSS to category: How To How To
subscribe via RSS to: Interviews Interviews
subscribe via RSS to category: linkdump linkdump
subscribe via RSS to category: movies movies
subscribe via RSS to category: music music
subscribe via RSS to category: graphics and design photoshop it
subscribe via RSS to category: politics politics
subscribe via RSS to category: search engines search engines
subscribe via RSS to category: spam spam
subscribe via RSS to category: Tablet PC Tablet PC
subscribe via RSS to category: television television
subscribe via RSS to category: browsers and toolbars toolbars
subscribe via RSS to category: travel travel

By Month
July 2009
(9) June 2009
(6) May 2009
(5) April 2009
(7) March 2009
(8) February 2009
(11) January 2009
(20) December 2008
(34) November 2008
(24) October 2008
(19) September 2008
(19) August 2008
(24) July 2008
(17) June 2008
(9) May 2008
(5) April 2008
(9) March 2008
(15) February 2008
(30) January 2008
(35) December 2007
(59) November 2007
(62) October 2007
(51) September 2007
(66) August 2007
(62) July 2007
(59) June 2007
(75) May 2007
(58) April 2007
(81) March 2007
(78) February 2007
(93) January 2007
(82) December 2006
(89) November 2006
(65) October 2006
(78) September 2006
(80) August 2006
(107) July 2006
(121) June 2006
(132) May 2006
(128) April 2006
(92) March 2006
(90) February 2006
(83) January 2006
(117) December 2005
(116) November 2005
(108) October 2005
(126) September 2005
(140) August 2005
(67) July 2005
(149) June 2005
(145) May 2005
(142) April 2005
(121) March 2005
(126) February 2005
(100) January 2005
(109) December 2004
(70) November 2004
(62) October 2004
(74) September 2004
(65) August 2004
(52) July 2004
(65) June 2004
(68) May 2004
(65) April 2004
(75) March 2004
(55) February 2004
(79) January 2004
(40) December 2003
(46) November 2003
(65) October 2003
(66) September 2003
(91)August 2003
(140) July 2003

 

Copyright 2003-2009 KMR Enterprises All Rights Reserved. Privacy Policy