Doctrine query postgres json (contains) json_array

Question

The json_array type of doctrine is saved to a postgres database > 9.2 as json datatype.

Postgres supports contains and lots of other operations on the json datatype. Is there any possibility to use the functionalities in doctrine?

Probably a custom SQLWalker is needed for that? As described here. Also a custom type supporting JSONB would be nice. As described here. This would increase the performance when querying for the json field. Or is there a custom lib that adds the json(b) functionality or is it even possibile using DQL.

I'm looking for the same thing, i found this while searching: github.com/opsway/doctrine-dbal-postgresql though it's still missing some operators. About jsonb I can tell you they are implementing the jsonb data type through an option but it's not available yet github.com/doctrine/dbal/pull/824 — valepu
– valepu, Commented May 20, 2015 at 10:18
@valepu I created a Symfony Bundle to support jsonb. github.com/boldtrn/JsonbBundle it works well — Robin
– Robin, Commented May 20, 2015 at 13:24

Robin · Accepted Answer · 2015-05-20 13:25:24Z

7

I created a Symfony2 Bundle that supports jsonb.

Hope this helps.

https://github.com/boldtrn/JsonbBundle

Right now I prefer to use NativQueries instead of custom DQL functions to query for my jsonb fields. The custom functions are too cumbersome in my application.

Everything should be documented in the Bundle as well.

answered May 20, 2015 at 13:25

Robin

3,92011 gold badges41 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shairyar Over a year ago

Many thanks for creating this bundle, was going crazy for last 2 days.

Collectives™ on Stack Overflow

Doctrine query postgres json (contains) json_array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related