Michael Gaigg: Über UI/UX Design

4Mar0

Using REPLACE in a SQL UPDATE

Posted by Michael Gaigg

When moving domains there will be a need to replace old url's and other strings to reflect the new names.

In my case the images of my blog articles were still pointing to the old domain which didn't physically exist anymore. Result: broken images and links.

Quick Solution

A quick SQL replace does the trick:

UPDATE blog_posts SET post_content = REPLACE(post_content, 'old-server.com', 'new-server.com') WHERE post_content LIKE '%old-server.com%'

This SQL statement is perfect for updating wordpress blogs that moved to a different domain/host.

Easy and efficient 🙂

14Mar0

Highlights of Week 10/2011

Posted by Michael Gaigg

17Mar0

I love Speed… therefore Google Chrome is.

Posted by Michael Gaigg

Happy St. Patrick's Day

Happy St. Patrick

Happy St. Patrick's Day everyone! While you're still sipping your Guinness and chewing on your shamrocks, everything seems to be new and shiny at Google: As announced today in their new Google Chrome blog, Google has released their new beta of Chrome.

New Features

Besides some really nice features (form autofill, full page zoom and autoscroll) Google Chrome offers a cool new way to drag tabs out to get a side-by-side view - way to go.

Did Google Chrome Just Get Even Faster?

Have I mentioned speed yet? As if (ooooold stable version of) Chrome wasn't fast enough, the neeeeew beta promised 25% to 35% in speed enhancements according to their V8 and Sunspider benchmarks. Ask your typical user to see why speed matters 😉

Which Browser do you use?

Are you still on Internet Explorer? Don't tell me IE6 - I'd have to creep through your monitor and strangle somebody... Firefox? Chrome? What are your experiences?

13Mar0

Go figure: 10 Comic Strips that have Something in Common

Posted by Michael Gaigg

Here is to all you peeps that cannot survive the weekend without a computer, smart phone or internet connection: What do the following 10 comic strips have in common?

Be aware, this is a trick question!

Comic 01: 'You have major self-esteem issues. I highly recommend that you immediately disable commenting on your blog.'

Comic 01: 'You have major self-esteem issues. I highly recommend that you immediately disable commenting on your blog.'

Comic 02: 'You don't send me trackbacks anymore. Are you blogging someone else?'

Comic 02: 'You don't send me trackbacks anymore. Are you blogging someone else?'

Comic 03: 'I wanna Wii' - 'Well, please wait until you're finished telling Santa what you want.'

Comic 03: 'I wanna Wii' - 'Well, please wait until you're finished telling Santa what you want.'

Comic 04: 'Will blog for food'

Comic 04: 'Will blog for food'

Comic 05: 'You can't go outside to play until you've finished reading all your RSS feeds!'

Comic 05: 'You can't go outside to play until you've finished reading all your RSS feeds!'

Comic 06: 'Hey Sport, there's a huge sale today so I'm going to buy some software. You need anything?'

Comic 06: 'Hey Sport, there's a huge sale today so I'm going to buy some software. You need anything?'

Comic 07: '...and Phillip, do you promise to blog about Janice, every day for the rest of your life...'

Comic 07: '...and Phillip, do you promise to blog about Janice, every day for the rest of your life...'

Comic 08: 'Waddya mean all my facts are wrong? I copied everything straight off the internet.'

Comic 08: 'Waddya mean all my facts are wrong? I copied everything straight off the internet.'

Comic 09: 'I can't find my GPS.' - 'Oh, the sweet, sweet irony.'

Comic 09: 'I can't find my GPS.' - 'Oh, the sweet, sweet irony.'

Comic 10: 'I don't care what 57% of your blog readers think is cool. We're not naming her Skype!'

Comic 10: 'I don't care what 57% of your blog readers think is cool. We're not naming her Skype!'