3 ms·
Excellent article on Arrays. I wish I knew about these before, there have been so many times I should have used this instead of serializing / deserializing JSON
by rdegges 14y ago
Excellent article on Arrays. I wish I knew about these before, there have been so many times I should have used this instead of serializing / deserializing JSON myself via TextFields :(
- joevandyk 14y agoPostgresql 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.
- einhverfr 14y agoWhat 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.