Re: [HACKERS] Protocol buffer support for Postgres

2016-06-29 Thread Robert Haas
On Fri, Jun 24, 2016 at 2:23 PM, Flavius Anton wrote: > Any other thoughts on this? My guess is that it might be an important > addition to Postgres that can attract even more users, but I am not > sure if there's enough interest from the community. If I want to pick > this task, how should I move

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-24 Thread Flavius Anton
On Fri, Jun 24, 2016 at 11:35 AM, Álvaro Hernández Tortosa wrote: > > > On 24/06/16 14:23, Flavius Anton wrote: >> >> On Thu, Jun 23, 2016 at 2:54 PM, Flavius Anton >> wrote: >>> >>> On Thu, Jun 23, 2016 at 1:50 PM, Greg Stark wrote: On Thu, Jun 23, 2016 at 8:15 PM, Flavius Anton

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-24 Thread Álvaro Hernández Tortosa
On 24/06/16 14:23, Flavius Anton wrote: On Thu, Jun 23, 2016 at 2:54 PM, Flavius Anton wrote: On Thu, Jun 23, 2016 at 1:50 PM, Greg Stark wrote: On Thu, Jun 23, 2016 at 8:15 PM, Flavius Anton wrote: I'd love to talk more about this. I thought quite a bit about this a few years ago but ne

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-24 Thread Flavius Anton
On Thu, Jun 23, 2016 at 2:54 PM, Flavius Anton wrote: > On Thu, Jun 23, 2016 at 1:50 PM, Greg Stark wrote: >> On Thu, Jun 23, 2016 at 8:15 PM, Flavius Anton wrote: >>> >>> I'd love to talk more about this. >> >> I thought quite a bit about this a few years ago but never really >> picked up it to

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-23 Thread Flavius Anton
On Thu, Jun 23, 2016 at 1:50 PM, Greg Stark wrote: > On Thu, Jun 23, 2016 at 8:15 PM, Flavius Anton wrote: >> >> I'd love to talk more about this. > > I thought quite a bit about this a few years ago but never really > picked up it to work on. > > Another option would be to allow the output of yo

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-23 Thread Greg Stark
On Thu, Jun 23, 2016 at 8:15 PM, Flavius Anton wrote: > > I'd love to talk more about this. I thought quite a bit about this a few years ago but never really picked up it to work on. There are different use cases where this could be useful and different approaches that could be useful for the di

Re: [HACKERS] Protocol buffer support for Postgres

2016-06-23 Thread Flavius Anton
On Tue, Apr 26, 2016 at 2:40:49PM -0700, David Fetter wrote: > Should we see about making a more flexible serialization > infrastructure? What we have is mostly /ad hoc/, and has already > caused real pain to the PostGIS folks, this even after some pretty > significant and successful efforts were

Re: [HACKERS] Protocol buffer support for Postgres

2016-04-26 Thread David Fetter
On Mon, Apr 25, 2016 at 11:06:11PM -0700, 陈天舟 wrote: > I am interested in adding Protocol Buffer support for Postgres. Protocol > Buffer occupies less space than JSON. More importantly, it has schema and > is forward/backward compatible. All these make it a very good format for > persistency. Than

Re: [HACKERS] Protocol buffer support for Postgres

2016-04-26 Thread Paul Ramsey
On Tue, Apr 26, 2016 at 6:40 AM, Tom Lane wrote: > Craig Ringer writes: >> On 26 April 2016 at 14:06, 陈天舟 wrote: >>> (1) Since each protocol buffer column requires a schema. I am not sure >>> where is the best place to store that schema info. Should it be in a >>> CONSTRAINT (but I am not able t

Re: [HACKERS] Protocol buffer support for Postgres

2016-04-26 Thread Tom Lane
Craig Ringer writes: > On 26 April 2016 at 14:06, 陈天舟 wrote: >> (1) Since each protocol buffer column requires a schema. I am not sure >> where is the best place to store that schema info. Should it be in a >> CONSTRAINT (but I am not able to find the doc referring any custom >> constraint)

Re: [HACKERS] Protocol buffer support for Postgres

2016-04-26 Thread José Luis Tallón
On 04/26/2016 08:06 AM, 陈天舟 wrote: I am interested in adding Protocol Buffer support for Postgres. Protocol Buffer occupies less space than JSON. More importantly, it has schema and is forward/backward compatible. All these make it a very good format for persistency. Have you investigated JSO

Re: [HACKERS] Protocol buffer support for Postgres

2016-04-25 Thread Craig Ringer
On 26 April 2016 at 14:06, 陈天舟 wrote: > I am interested in adding Protocol Buffer support for Postgres. Protocol > Buffer occupies less space than JSON. More importantly, it has schema and > is forward/backward compatible. All these make it a very good format for > persistency. > > Here are two r

[HACKERS] Protocol buffer support for Postgres

2016-04-25 Thread 陈天舟
I am interested in adding Protocol Buffer support for Postgres. Protocol Buffer occupies less space than JSON. More importantly, it has schema and is forward/backward compatible. All these make it a very good format for persistency. Here are two rough ideas I have right now: Approach 1: Creating