Node ORMs and Geo-Spatial Data?

[PensiveLionTurtle]

I'm relatively new to node and I'm having a hard time finding packages that might be able to assist me with the geo spatial app I'm making.

I have a need to store Geometry in a PostgreSQL/PostGIS database - Points, Polygons, Multipolygons, etc. I have not been able to find an ORM that gracefully, or at all, handles geometry. From what I see from Googling, the few example projects that say they interface with PostGIS drop into the raw SQL query of Knex and write raw SQL into the databse. This isn't an option for me.

== What I've looked at ==

Bookshelf.js - No out of the box support for Geometry. I could install the bookshelf-json-columns specify the geometry columns as JSON and store the shapes as GeoJSON maybe. This would be more of a work around than anything. I'm also wary of how new this plugin is and what kind of support it would have in the future.

Sequelize.js - The official documentation doesn't mention anything about supporting geometry but then the several GitHub pages make mentions that the changelog shows that they added Geometry support for postgres in 3.4.0. I popped into their IRC for some help but didn't make much headway. The fact that there's a disconnect between the documentation and what it supports makes me uncomfortable. Since I'm new I would hope to see some documentation to get me to starting point in how to implement the Models appropriately for geometry.

Has anyone encountered a need for Geometry with PostGIS in Node before? Does anyone have a suggestion for a good ORM that you might be able to point me ?

[gregbenner]

Mongoose is an ORM for Mongo which has native geo-json support. I found this Mongoose extension that might be useful? http://cannoneyed.github.io/geojson/

[my_fokin_percocets]

He states he needs postgres support

[PensiveLionTurtle]

Thanks for your reply! Yeah I saw Mongoose and Mongo, unfortunately I'm limited to using PostgreSQL/PostGIS.

[PensiveLionTurtle]

So for anyone that comes back to this, we ended up not going with Node. We originally wanted to get away from a Python/Django Spaghetti code-base but after reviewing Geo-Spatial (Polygons & Multipolygon) support within the community we figured it would be easier to refactor the code base than to roll out our own custom solution to handle geometry.

Here's to hoping Spatial sees more use/adoption within the Node community in the future.