Re: Using JSONB directly from application

2018-06-25 Thread Andrew Dunstan
On 06/24/2018 12:42 PM, Tomas Vondra wrote: Sending raw JSONB to Postgres might also be interesting, but I'd start with receiving. Would implementing raw_jsonb be as trivial as it sounds?  What about usages like SELECT raw_jsonb(col3->'foo'); does the subobject returned by '->' share struct

Re: Using JSONB directly from application

2018-06-24 Thread Tomas Vondra
On 06/22/2018 11:52 PM, Christian Ohler wrote: > (continuing an old thread from > https://www.postgresql.org/message-id/CAMsr%2BYEtamQYZ5EocsuthQCvyvmRnQrucDP6GZynPtf0gsMbuw%40mail.gmail.com > ) > > Craig Ringer , 2018-02-26: > >> On 26 February 2018 at 04:05, Anthony Communier > wrote: >>  >

Re: Using JSONB directly from application

2018-06-22 Thread Nico Williams
On Mon, Feb 26, 2018 at 09:36:52PM +0800, Craig Ringer wrote: > On 26 February 2018 at 04:05, Anthony Communier > wrote: > > It would be nice if application connected to a Postrgesql database could > > send and receive JSONB in binary. It could save some useless text > > conversion. All works coul

Re: Using JSONB directly from application

2018-06-22 Thread Christian Ohler
(continuing an old thread from https://www.postgresql.org/message-id/CAMsr%2BYEtamQYZ5EocsuthQCvyvmRnQrucDP6GZynPtf0gsMbuw%40mail.gmail.com ) Craig Ringer , 2018-02-26: > On 26 February 2018 at 04:05, Anthony Communier wrote: > > > It would be nice if application connected to a Postrgesql databa

Re: Using JSONB directly from application

2018-02-26 Thread Craig Ringer
On 26 February 2018 at 04:05, Anthony Communier wrote: > Hello, > > It would be nice if application connected to a Postrgesql database could > send and receive JSONB in binary. It could save some useless text > conversion. All works could be done on application side which are often > more scalabl