PostGis and Ruby

A lightning talk on using PostGis in a Ruby stack.

Transcript

1. PostGIS and Ruby Andy Mention @amention
2. The Problem • Healthcare Providers • Participation • Location
3. The Stack • PostGIS (duh.) • Ruby • Grape API • ActiveRecord
4. The Solution • Database table/view optimization • JSONB • Basic spatial functionality • Compose query using Ruby
5. Code: where scope :by_language, lambda { |language| where(language: language) }
6. Code: where (jsonb) scope :by_language, lambda { |language| where("languages ?| array['#{language}']") }
7. MOAR Code scope :participating, lambda { |doc_groups| groups = “‘#{doc_groups.join("','")}'" where( "doctor_group ?| array[#{groups}] OR hospital_group ?| array[#{groups}]” ) } scope :awesome_doctors, lambda { select( "(CASE WHEN doctor_rating ?| array['awesome'] THEN 1 ELSE 2 END) as awesome” ).order("awesome") }
8. Do you even PostGIS? scope :within, lambda { |lat, lng, radius| select( "ST_DWithin( the_geom, ST_GeomFromText('POINT(#{lng} #{lat})', 4326)::geography, #{radius})") }