My technology week in review ending 2010.05.02

My summary of interesting URLs from last couple of weeks, including stories related to:

  • SQL and DB2
  • Software development
  • Web tools and standards
  • Innovation, business, self-improvement
  • Podcasts
  • TED talks

And for those of you on Twitter, the stories relate to: @Tunglerocks @DanielPink @tgoetz @hershco @max_webster

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

How the Great Fire of 1904 fire ruined my MySQL DAYOFYEAR() calculations

I had what I thought was a simple requirement, sort a set of MySQL 5 rows in order by the day of the year, regardless of the year. April 22nd before April 21st, etc... In particular I wanted to show photos from 'this day in history' going back over a hundred years! My DAYOFYEAR() code worked perfectly, until the Great Toronto fire of 1904...

My technology week in review ending 2010.04.18

My summary of interesting URLs from the last couple of weeks, including stories related to:

  • SQL and DB2
  • Web tools and standards
  • Podcasts
  • TED talks

And for those of you on Twitter, the stories relate to: @max_webster @dotspots @HiddenBrain @mattjamestaylor @djhomeless

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

My technology week in review ending 2010.04.04

My summary of interesting URLs from the last couple of weeks, including stories related to:

  • SQL and MySQL and phpMyAdmin
  • Location aware applications
  • Software development
  • Podcasts

And for those of you on Twitter, the stories relate to: @chamillionaire @QD3 @dozba @glennplatt @voidfiles @theCSSninja

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

Creating a MySQL View directly in phpMyAdmin

Icon for creating a view directly in phpMyAdminI use phpMyAdmin to administer my remote MySQL databases and find the GUI good enough for most tasks, but I found myself wondering "How do I create a view in phpMyAdmin?" A careful review of the GUI turned up nothing, but this seems like such a common task I was surprised there was no way to create a view other than directly via SQL. A few web searches later and I realized there was a way, it was just not obvious until you figure it out. So here's my quick tutorial on creating a MySQL view directly in phpMyAdmin.

My technology week in review ending 2010.03.21

My summary of interesting URLs from the last couple of weeks, including stories related to:

  • SQL and DB2
  • Data Visualization
  • Software development
  • Podcasts
  • TED talks

And for those of you on Twitter, the stories relate to: @Grant27 @dabbledb @Josh @srhayes @dan_roam @SoquelCreek @infosthetics @DanielPink

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

My technology week in review ending 2010.03.07

A long time since my last summary, but we were away on vacation for a week, had some deadlines at work... the normal blogger excuses, but here's a summary of interesting URLs from the last few weeks, including stories related to:

  • SQL and DB2
  • Software development
  • AI, Robots, and the Singularity
  • Podcasts

And for those of you on Twitter, the stories relate to: @mdirolf @simplecloudapi @dhh

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

Mark Pincus & Bing Gordon: A Serious Take on Internet Game Play

Usually I wait until my weekly review to post links to all the interesting podcasts I listen to in the week, but I found this one quite insightful as well as entertaining, so thought I'd find the video and post it here. It is just over an hour long, including questions from the audience, but the speakers have a good rapport and keep each other moving from topic to topic, so it seems shorter than that.

The Stanford Entrepreneurship Corner podcasts are always interesting, and this one is no exception - from their site: "Serial entrepreneur and Zynga founder Mark Pincus and Bing Gordon, longtime Electronic Arts creative mind and investor on behalf of KPCB, provide a very laid-back and desultory conversation. Topics touched upon include successful CEOs, building sustainable companies, mentorship, and the consumer pay-driven Web 3.0."

The buzz on Buzz? Mobile integration looks amazing

When I first heard about Google Buzz I was of two minds - "its from Google so it is important", but also "another social network, yawn".

But then I watched this video (via the somewhat ad-overloaded http://www.ilovecolors.com.ar ) from Google describing how Buzz will work with Mobile phones, and it looks a LOT more interesting.

Here's the video, just under 2 minutes:

My technology week in review ending 2010.02.07

My summary of interesting URLs from last week, including stories related to:

  • SQL and DB2 - just CouchDB this week
  • Software development - Simple Cloud API, and David Heineimeier Hansson, of Ruby on Rails 37signals
  • User interface and design - I tried to resist the iPad hype, but here are some interface related stories
  • Podcasts
Syndicate content