Re: Bootstrap DATA is a pita - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Bootstrap DATA is a pita
Date
Msg-id 54E8989F.6070900@dunslane.net
Whole thread Raw
In response to Re: Bootstrap DATA is a pita  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Bootstrap DATA is a pita  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 02/21/2015 05:04 AM, Andres Freund wrote:

> Yes, that's a good point. I have zero desire to open-code a format
> though, I think that's a bad idea. We could say we just include
> Yaml::Tiny, that's what it's made for.
>


Personally, I think I would prefer that we use JSON (and yes, there's a 
JSON::Tiny module, which definitely lives up to its name).

For one thing, we've made a feature of supporting JSON, so arguably we 
should eat the same dog food.

I also dislike YAML's line oriented format. I'd like to be able to add a 
pg_proc entry in a handful of lines instead of 29 or more (pg_proc has 
27 attributes, but some of them are arrays, and there's an oid and in 
most cases a description to add as well). We could reduce that number by 
defaulting some of the attributes (pronamespace, proowner and prolang, 
for example) and possibly infering others (pronargs?). Even so it's 
going to take up lots of lines of vertical screen real estate. A JSON 
format could be more vertically compact. The price for that is that JSON 
strings have to be quoted, which I know lots of people hate.

cheers

andrew



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Expanding the use of FLEXIBLE_ARRAY_MEMBER for declarations like foo[1]
Next
From: Andrew Dunstan
Date:
Subject: Re: Bootstrap DATA is a pita