CODEWITHSUNDEEP
ruby-on-railsmysqligeospatial
scrrr
scrrr

Reputation: 5340

Geospatial application in Rails

For my next Ruby on Rails-project I will have to store and query geospatial data. More precisely I want to do the following things:

Another very important query is:

What is the most pain-free combination of components to accomplish that? I care about a quick implementation and very fast queries.

I have found this presentation and the author seems to favor Postgres and the activerecord-postgis-adapter, but perhaps there are other worthwhile opinions.

This is just a small prototype project, but I already have MySQL running, so I am interested in experiences with that. Or ist Postgres + PostGIS definitely the way to go? And I know that MongoDB makes it easy to get started with Geo-data, however, this time I want to use a relational database.

Any input is very appreciated.

Upvotes: 0

Views: 504

Answers (2)

RoRRe
RoRRe

Reputation: 291

Have used MongoDB with mongoid. does a great job. Also, try using in elasticsearch (tire gem) for geo search.

Upvotes: 1

Mayukh Roy
Mayukh Roy

Reputation: 1815

MySQL also supports GIS. Though MSSQL and Postgres have excellent library support for this, MySQL can also perform well. Check the function list MySQL provides.

  • MySQL: Uses Geography datatype for both GIS and planner calculation. Documentation-> Good
  • MSSQL: Has both Geography and Geometry datatype. Documentation->Great. Help-> Awesome
  • Postgres: Has both Geography and Geometry datatype. Documentation->Awesome. Help-> Good

Choose wise :)

Upvotes: 1

Related Questions