PostgreSQL 9.3 Beta 1 Released

Re:PostgreSQL 9.3 Beta 1 Released by masklinn on Monday May 13, 2013 @10:31AM (#5698835)

the json support is fairly recent and doesn't support operating directly on the data yet (e.g. you have to create functional indexes through plv8js and you can't directly query on the document's content as you can with array, xml or hstore columns)

[ Parent | on HN ]

Re:PostgreSQL 9.3 Beta 1 Released by e1ven on Monday May 13, 2013 @11:19AM (#5699137)

I'm using https://github.com/JerrySievert/mongolike to support Postgres using mongo-like queries.

I patched in a bunch of features I needed, and it works really well for me.

[ Parent | on HN ]

Re:PostgreSQL 9.3 Beta 1 Released by jeltz on Monday May 13, 2013 @10:45AM (#5698935)

PostgreSQL 9.3 adds functions for accessing JSON data without having to use plv8js.

[ Parent | on HN ]

Re:PostgreSQL 9.3 Beta 1 Released by masklinn on Monday May 13, 2013 @10:57AM (#5699000)

Yeah but since it's just being added, it precludes "NoSQL guys" having built upon it, which is the original complaint.

[ Parent | on HN ]

Re:PostgreSQL 9.3 Beta 1 Released by jeffdavis on Monday May 13, 2013 @12:39PM (#5699673)

Another intepretation of zapov's comment is that it's a shame the NoSQL projects didn't try achieving their goals by building postgres extensions (or even adding new features).

A reasonable question. MongoDB could have focused their energies on really good JSON support in postgres and making postgres sharding easier.

[ Parent | on HN ]

Re:PostgreSQL 9.3 Beta 1 Released by masklinn on Monday May 13, 2013 @03:18PM (#5700802)

An interesting interpretation, which I had not considered. Thank you.

[ Parent | on HN ]