JQuery (contains) json_array

Question

The doctrine type json_array stored in the postgres> 9.2 database as jon datatype .

Postgres supports and contains many other json data type operations . Is it possible to use functionality in a doctrine?

Perhaps you need a custom SQLWalker for this? As described here . A custom type supporting JSONB would also be nice. As described here . This would increase query performance for the json field. Or there is a custom lib that adds json(b) functionality or it is even possible to use using DQL .

Answer 1

I created a symfony2 package that supports jsonb.

Hope this helps.

https://github.com/boldtrn/JsonbBundle

Currently, I prefer to use NativQueries instead of custom DQL functions to query my jsonb fields. Custom functions are too cumbersome in my application.

Everything should be documented in the Bundle.