Hacker News new | ask | show | jobs
by joevandyk 5044 days ago
Postgresql 9.2 supports json, btw!

You can store json, or, even better, you can write sql that returns an arbitrary json structure.

So you can have one sql query return a nested array of hashes of arrays of hashes... handy if you need a retrieve a lot of different data at once that doesn't fit into a neat set of rows.

1 comments

What we need now is a function that will take an arbitrary JSON element and return a data structure associated with it. This shouldn't be too hard using plv8js.....

This could then be used as an input format for object-relational modelling.