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

Using JSONB directly from application

2018-02-26 Thread Anthony Communier
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 scalable than database itself. Regards, Anthony Communier