|
|
|
|
|
|
by munro
4460 days ago
|
|
|
If you want to store & query JSON [1], Postgres 9.3 is great! Plus you can index functions, meaning you get cool things like fast JSON look up, and doing case insensitive searches. Which is hard in Mongo, you would either have to do a slow regexp look up, or save a lower case version in your application logic. CREATE INDEX ON members ((lower(my_json_data->>'email')));
[1] http://www.postgresql.org/docs/9.3/static/functions-json.htm... |
|
|