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!