How to avoid serialization of postgres json result in Sequel

Question

In a web server, I'm running a query in Postgres that performs a select json_build_object of an aggregation(json_agg). I'm using Sequel to fetch this data, and I'm getting as a value an instance of Sequel::Postgres::JSONHash. Then, I perform a to_json in order to send it to the web client.

The output of this query is very big and I think that it could be more performant If I could grab the raw json response of postgres directly and send it to the client, instead of parsing it into JSONHash (which is done by Sequel) and then converting it again to json.

How could I do it?

Jeremy Evans · Accepted Answer · 2019-03-28 15:10:33Z

4

Cast the json_build_object from json to text in the query: SELECT json_build_object(...)::text ...

answered Mar 28, 2019 at 15:10

Jeremy Evans

12.2k32 silver badges28 bronze badges

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

1 Comment

Bruno Over a year ago

Thanks @Jeremy. Nice idea.

Collectives™ on Stack Overflow

How to avoid serialization of postgres json result in Sequel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related