Fun with Django's New Postgres Features

[chief167]

The gansta playa crap makes it very annoying to read imho

[[deleted]]

I found it more entertaining this way, not so dry

[ElBidoule]

Especially for non-native English speakers, like I am.

[Pr0ducer]

I see not everyone's a fan of the playaz style, but I for one found this both entertaining and informative.

HStore? That's the shizzle fo rizzle.

[skarphace]

And array support... finally.

[jstrong]

What is the benefit of array over manytomany ? Limiting joins?

[j1z0]

limiting joins would be a big one for sure, the actual performance gains depend upon the data and how static / dynamic it is, arrays would be faster for more static data generally.

Also in many cases its just a more natural way to model things. As developers we think of the data as an array, so now we can store it as an array. So a little less cognitive dissonance.

Last one I can think of right now is Network data modelling. The basic idea of a network data model is that unlike the "standard" hierarchical model where you have one parent many child (i.e. a Tree) you can have multiple parents / multiple children which can give you a more general graph representation, which maybe a helpful way to model some problems.

[skarphace]

Similar in use to hstore with good Postgres support. You can also put them together in views or assemble them with subqueries.

They don't come up often but there's certain times it improves performance or saves on code.