Add messagepack return type about postgrest-docs HOT 6 OPEN

msgpack was discussed here before: PostgREST/postgrest#1548

PostgREST/postgrest#1582 is still looking like the way forward

from postgrest-docs.

Even with better content negotiation, we'd still need a way to convert to and from msgpack. Is there a postgres extension to do it?

from postgrest-docs.

Yes, there's https://github.com/patriksimek/msgpack-postgres

from postgrest-docs.

Yes, there's https://github.com/patriksimek/msgpack-postgres

Right, I'm just not sure whether an implementation written in plpgsql will be helpful in terms of performance... which seems to be the primary use-case for to request msgpack data in the first place.

from postgrest-docs.

Is this now possible from PostgREST-side? I think it is, right? @steve-chavez

from postgrest-docs.

Yeah, should be possible like:

create domain "application/x-msgpack" as bytea;

create or replace function hello() returns "application/x-msgpack" as $$
  select msgpack_encode('{"hello": "world"}'::jsonb);
$$ language sql;

Using the extension https://github.com/patriksimek/msgpack-postgres.

from postgrest-docs.