Why HStore2/jsonb is the most important patch of PostgreSQL 9.4

Re:Why HStore2/jsonb is the most important patch of PostgreS... by twic on Sunday February 23, 2014 @10:50AM (#7286197)

This could be done fairly easily, perhaps more easily, as a standalone program, i think. Something that exposes a MongoDB-compatible API, and translates requests into libpq to go to a PostgreSQL backend.

You could run it either on the PG host, or on the same host as the apps wanting to talk to PG.

[ Parent | on HN ]

Re:Why HStore2/jsonb is the most important patch of PostgreS... by brannon on Sunday February 23, 2014 @11:07AM (#7286262)

My understanding of all of this is beginner level at best, but isn't that more or less what waterline does? https://github.com/balderdashy/waterline-docs

[ Parent | on HN ]

Re:Why HStore2/jsonb is the most important patch of PostgreS... by twic on Monday February 24, 2014 @02:57PM (#7293043)

Based on a quick look at the documentation, i think the API Waterline exposes to clients is not an imitation of the MongoDB API, which would allow PostgreSQL to be used as a drop-in replacement for MongoDB. Rather, it's its own thing.

Waterline does support both MongoDB and PostgreSQL, though, so you could use it as part of a migration strategy: start with MongoDB, install Waterline backed by MongoDB, migrate your app to use Waterline rather than using MongoDB directly, replace MongoDB with PostgreSQL.

[ Parent | on HN ]