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.)

SQL and MySQL and phpMyAdmin

No IBM DB2 links this week, more MySQL, the GUI interface phpMyAdmin, and some NoSQL thoughts. Also some honest to goodness SQL links related to geotagging.
Hidden phpMyAdmin Features | ht4
Steps required to enable some additional functionality in phpMyAdmin, like Designer Mode, Query History, and Query Bookmarking.

Delicious tags: sql phpMyAdmin hints MySQL database

Creating a MySQL View directly in phpMyAdmin | Sky on Tech

It isn't obvious to begin with, but once you figure it out, it makes perfect sense.... You first run the query, get it right, and check the output is as you expect, then you can create the view in phpMyAdmin right from the result set. This page provides the steps and some screen captures to help along the way.

Delicious tags: MySQL phpMyAdmin SQL view GUI tutorial database

I Can't Wait for NoSQL to Die | Ted Dziuba blog
They don't teach you this in college, but the fundamental theorem of the software industry is the idea that everything needs to be rewritten all the time. As a corollary, web startup engineers believe that there is no problem but scalability, and architecture is its solution. And thus, the NoSQL movement was born.

Delicious tags: blog programming technology humor tech database NoSQL
Associated Twitter users: @dozba

Selecting points from a database by latitude/longitude within a bounding circle
A clear introduction to the math and SQL required to efficiently select records in SQL that are geotagged within a certain circle away from a given point.

Delicious tags: geolocation php gis programming database development mysql sql

Location aware applications

As more devices and browsers support geo-aware applications, the web experience gets more specific to your location.
Selecting points from a database by latitude/longitude within a bounding circle
A clear introduction to the math and SQL required to efficiently select records in SQL that are geotagged within a certain circle away from a given point.

Delicious tags: geolocation php gis programming database development mysql sql

Accessing the GPS in iPhone Safari | The CSS Ninja
Simple examples of how to use GPS related data in web browsers like Safari, Firefox, etc... almost as simple as a navigator.geolocation.getCurrentPosition(success, fail); call. Even the demo is useful to verify that the GPS / WiFi router data is accurate if you have a geo-aware browser.

Delicious tags: iphone gps javascript maps geolocation safari programming api firefox development geotag gis
Associated Twitter users: @thecssninja

Software development

Programs and processes used to streamline and self-document the development of software. Agile, Object-Oriented, Online, etc...:
How to Make an HTML5 iPhone App
The steps required to make an HTML page look like a native iPhone App, AND store data locally. In many cases this is a much easier way to make native looking iPhone applications, AND done right, they should run on other smart phones without making any changes. No need to buy the Apple SDK or wait for the iTunes Store acceptance. You can also make changes to the application on the fly, via the web server.

Delicious tags: iphone programming development javascript tutorial html css html5
Associated Twitter users: @voidfiles

Selecting points from a database by latitude/longitude within a bounding circle
A clear introduction to the math and SQL required to efficiently select records in SQL that are geotagged within a certain circle away from a given point.

Delicious tags: geolocation php gis programming database development mysql sql

Accessing the GPS in iPhone Safari | The CSS Ninja
Simple examples of how to use GPS related data in web browsers like Safari, Firefox, etc... almost as simple as a navigator.geolocation.getCurrentPosition(success, fail); call. Even the demo is useful to verify that the GPS / WiFi router data is accurate if you have a geo-aware browser.

Delicious tags: iphone gps javascript maps geolocation safari programming api firefox development geotag gis
Associated Twitter users: @thecssninja

Podcasts

The various podcasts I listened to this week
Successful Independent Promotion: From Artist to Entrepreneur | Stanford's Entrepreneurship Corner
Hip-hop artists Quincy Jones III and Chamillionaire discuss mastering the business side of the music industry. Keeping up with cutting-edge technologies, production logistics, and finding creative ways to gain direct audience contact are essential tactics for the self-produced artist in the digital age.

Delicious tags: artist Stanford podcast customer entrepreneurship
Associated Twitter users: @chamillionaire @QD3

IT Conversations | Tech Nation | Peter Hessler

Author, Peter Hessler discusses the new car culture that has emerged in China, as 90 million new drivers take to the streets each day.

Delicious tags: China technation podcast Hessler culture

SXSWi: Education in the "free"era : dW podcasts
The unavoidable and landscape-altering changes that are coming in higher education where the subject of a SXSWi session by Peg Faimon and Glenn Platt of Miami University of Ohio. They joined Scott Laningham of developerWorks for a discussion on the topic after their session. You can see the slides, and more comments, at http://www.slideshare.net/glenn.platt/universities-in-the-free-era-sxsw-2010-presentation

Delicious tags: developerworks podcast Faimon Platt education university free SXSWi
Associated Twitter users: @glennplatt

How Individual Performance Scales Up | Harvard Business IdeaCast 186

Michael Schrage, research fellow at MIT Sloan School's Center for Digital Business discusses his book Serious Play: How the World's Best Companies Simulate to Innovate. "Successful innovation demands more than a good strategic plan; it requires creative improvisation. Much of the "serious play" that leads to breakthrough innovations is increasingly linked to experiments with models, prototypes, and simulations. As digital technology makes prototyping more cost-effective, serious play will soon lie at the heart of all innovation strategies, influencing how businesses define themselves and their markets." For an even briefer introduction, seee a video on YouTube at http://www.youtube.com/watch?v=S_HNy2b4wrs

Delicious tags: management performance podcast play simulation HBR Harvard business Schrage

The Right Way to Collaborate (If You Must) | Harvard Business IdeaCast 185

Morten Hansen, professor at the UC Berkeley School of Information discusses his book Collaboration: How Leaders Avoid the Traps, Create Unity, and Reap Big Results. Not all collaboration is productive; there are situations in which to avoid it. It is also important to ensure the underlying organization can fully support collaboration.

Delicious tags: collaboration hbr podcast business Harvard Hansen





The Secret Origins of Corporate Strategy | Harvard Business IdeaCast 184

Walter Kiechel, discusses his book The Lords of Strategy: The Secret Intellectual History of the New Corporate World that covers the rise of corporate strategy and the people who realized its importance.

Delicious tags: business management strategy HBR Harvard podcast Kiechel