Building a MongoDB Clone in Postgres

#1

Post by jerrysievert » Mon, Jun 04, 2012, 4:57 PM UTC

Building a MongoDB Clone in Postgres
legitimatesounding.com

Re: Building a MongoDB Clone in Postgres

#2

Post by NewtonsFolly » Mon, Jun 04, 2012, 5:19 PM UTC

Sounds legit.

Re: Building a MongoDB Clone in Postgres

#3

Post by nsanch » Mon, Jun 04, 2012, 5:21 PM UTC

Unless he's planning to build sharding on postgres too, I think he's missing the point.

Re: Building a MongoDB Clone in Postgres

#4

Post by jerrysievert » Mon, Jun 04, 2012, 5:26 PM UTC

nsanch wrote: post #3

Unless he's planning to build sharding on postgres too, I think he's missing the point.

while sharding is an important aspect of mongodb, i don't consider it the most important feature.

Re: Building a MongoDB Clone in Postgres

#5

Post by StavrosK » Mon, Jun 04, 2012, 5:37 PM UTC

This is (almost) exactly what Goatfish[1] does, except it uses SQLite, and can create SQL indexes on any arbitrary field. I needed a schemaless, embeddable store, so I decided to go with that, since Postgres already has the hstore. It's still very simple and preliminary, but it works, and it's very useful for prototyping.

I'd like to develop it some more, if people found it useful and started using it.

[1] https://github.com/stochastic-technologies/goatfish

Re: Building a MongoDB Clone in Postgres

#6

Post by [deleted] » Mon, Jun 04, 2012, 5:49 PM UTC

nsanch wrote: post #3

Unless he's planning to build sharding on postgres too, I think he's missing the point.

[deleted]

Re: Building a MongoDB Clone in Postgres

#7

Post by jshen » Mon, Jun 04, 2012, 5:50 PM UTC

jerrysievert wrote: post #4

nsanch wrote: post #3

Unless he's planning to build sharding on postgres too, I think he's missing the point.

while sharding is an important aspect of mongodb, i don't consider it the most important feature.

that doesn't mean that others don't find it to be an extremely important feature.

Re: Building a MongoDB Clone in Postgres

#8

Post by DEinspanjer » Mon, Jun 04, 2012, 5:52 PM UTC

It is interesting, but what I really need in the JSON functionality of PG is some internal representation that will allow fast and efficient exploration of the JSON blob within the query. i.e. being able to refer to a single attribute within the select/where/groupby clauses without having to pay the toll of serde every time.

Re: Building a MongoDB Clone in Postgres

#9

Post by nsanch » Mon, Jun 04, 2012, 5:54 PM UTC

jerrysievert wrote: post #4

nsanch wrote: post #3

Unless he's planning to build sharding on postgres too, I think he's missing the point.

while sharding is an important aspect of mongodb, i don't consider it the most important feature.

I don't know if it's the _most_ important feature, but I wouldn't build a serious site on top of anything that didn't have some sort of built-in sharding story.

With postgres you have to roll your own. If you want to bridge the gap from postgres to mongo, I think that's where you have to start.

Re: Building a MongoDB Clone in Postgres

#10

Post by jshen » Mon, Jun 04, 2012, 5:57 PM UTC

nsanch wrote: post #9

jerrysievert wrote: post #4

Earlier quoted context omitted.

while sharding is an important aspect of mongodb, i don't consider it the most important feature.

I don't know if it's the _most_ important feature, but I wouldn't build a serious site on top of anything that didn't have some sort of built-in sharding story. With postgres you have to roll your own. If you want to bridge the gap from postgres to mongo, I think that's where you have to start.

"but I wouldn't build a serious site on top of anything that didn't have some sort of built-in sharding story."

There are many serious sites that don't need sharding.