Use cases for hstore vs json datatypes in postgresql -


in postgresql, hstore , json datatypes seem have similar use cases. when choose use 1 vs. other? initial thoughts:

  • you can nest json; can't hstore
  • functions parsing json won't available until 9.3

the json type string. there no built in functions parse it. thing gained when using validity checking.

edit downvoting: written when 9.3 still didn't exist.it correct 9.2. question different. check edit history.


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -