Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL 9.3 Beta 1 Released

postgresql.org

Post reply on HN
Print view View original

11–20 of 118 posts

Re: PostgreSQL 9.3 Beta 1 Released

#11

Post by masklinn »

gbog wrote: post #6
zapov wrote: post #5

Postgres type system is so much better than any other RDBMS that it's a shame NoSQL guys didn't spend more time building on top of it. While their optimizer could use some work here and there it's improving all the time. We are doing some pretty obscure stuff to it and it's serving us well. Oracle on the other hand requires so much attention and special handling with it's type system, that if there were an alternativ…

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

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)

Re: PostgreSQL 9.3 Beta 1 Released

#14

Post by Ygg2 »

mintyfresh wrote: post #12
DrJokepu wrote: post #2

The PostgreSQL team just keeps on giving. There is nothing that can stop these guys.

In that spirit, what are the best resources for getting started and diving in to working with PostgreSQL?

I'd love to hear about them too. I've seen some O'Reilly books but they've been long time ago.

Re: PostgreSQL 9.3 Beta 1 Released

#15

Post by recuter »

gbog wrote: post #6
zapov wrote: post #5

Postgres type system is so much better than any other RDBMS that it's a shame NoSQL guys didn't spend more time building on top of it. While their optimizer could use some work here and there it's improving all the time. We are doing some pretty obscure stuff to it and it's serving us well. Oracle on the other hand requires so much attention and special handling with it's type system, that if there were an alternativ…

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

Sort of like a column store? ;) This is also rather how Reddit uses it I believe.

Re: PostgreSQL 9.3 Beta 1 Released

#16

Post by lucian1900 »

gbog wrote: post #6
zapov wrote: post #5

Postgres type system is so much better than any other RDBMS that it's a shame NoSQL guys didn't spend more time building on top of it. While their optimizer could use some work here and there it's improving all the time. We are doing some pretty obscure stuff to it and it's serving us well. Oracle on the other hand requires so much attention and special handling with it's type system, that if there were an alternativ…

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

You'd be better of with hstore than json.

Re: PostgreSQL 9.3 Beta 1 Released

#17

Post by tiwazz »

alberth wrote: post #7
zapov wrote: post #5

Postgres type system is so much better than any other RDBMS that it's a shame NoSQL guys didn't spend more time building on top of it. While their optimizer could use some work here and there it's improving all the time. We are doing some pretty obscure stuff to it and it's serving us well. Oracle on the other hand requires so much attention and special handling with it's type system, that if there were an alternativ…

HStore [1] is NoSQL plugin for Postgres. Works great. Been available for a long time too. [1] http://www.postgresql.org/docs/9.0/static/hstore.html

I don't believe hstore supports nested structures, which would make it less than a drop in replacement for many NoSQL use cases. Native JSON support should fix that though, so good news everyone!

http://www.postgresql.org/docs/devel/static/functions-json.h...

Re: PostgreSQL 9.3 Beta 1 Released

#18

Post by volkadav »

mintyfresh wrote: post #12
DrJokepu wrote: post #2

The PostgreSQL team just keeps on giving. There is nothing that can stop these guys.

In that spirit, what are the best resources for getting started and diving in to working with PostgreSQL?

The postgresql.org docs are a great starting point: http://www.postgresql.org/docs/9.1/static/ for example. (They also serve as a good reference when you're forgetting some finer point of syntax or admin later... the manual's nicely "phased" in terms of introductory and reference content.)

I'm lucky enough to work at a company that tends to use Pg as our default RDBMS; speaking strictly as a dev it's a heck of a lot more ergonomic and sophisticated than some of the things I've dealt with.

Re: PostgreSQL 9.3 Beta 1 Released

#19

Post by jeltz »

masklinn wrote: post #11
gbog wrote: post #6

Earlier quoted context omitted.

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

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)

PostgreSQL 9.3 adds functions for accessing JSON data without having to use plv8js.
Post reply on HN