February Meetup – MySQL & GIS

Share on Tumblr

When: Wednesday, February 25th @7pm

Where: The404 (details)

At this month’s meetup, I gave a talk about the current (and soon to be GA) geospatial capabilities of MySQL.  The talk covered such things as:

  • High level geospatial overview
  • Early methods of doing geocoding (lat/lon/radius)
  • Intro to GIS functions (geometry type, st_* functions)
  • The impact of adding SPATIAL indexes to InnoDB (coming in 5.7)

My biggest takeaway from prepping for this talk was how excited I am to see SPATIAL indexes for InnoDB in 5.7 (http://dev.mysql.com/downloads/mysql/5.7.html).  We ran some sample queries with and without indexes and it showed how InnoDB goes from essentially unusable for GIS programming to a very viable solution.

I can’t wait for 5.7 to be GA!!

As promised, here is a link to the slides: http://www.slideshare.net/mbenshoof/mysql-gis

It was great to see everyone and I’m looking forward to next month!