Re: Best way to populate nested composite type from JSON` - Mailing list pgsql-general

From Chris Travers
Subject Re: Best way to populate nested composite type from JSON`
Date
Msg-id CAKt_ZfsBgXTSjNsYsOZd8geMm6H0JKYCZsO64xndNGL+aDfnjA@mail.gmail.com
Whole thread Raw
In response to Re: Best way to populate nested composite type from JSON`  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Best way to populate nested composite type from JSON`  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general



On Fri, Sep 13, 2013 at 7:58 AM, Merlin Moncure <mmoncure@gmail.com> wrote:

 
Yup.  As things stand currently, it's better *not* to make
serialization-driving composite types which when learning the json
stuff I did heavily; it was a habit I learned (and had to unlearn)
from libpqtypes which solves a lot of the same problems for C clients.
 You can *almost* send json back to the database with the same
elegance as it can be sent out of the database.  I see a big future
for postgres-json with many roadmap improvements; it's a complete game
change for service call driven database interaction and forward
thinking developers should realize it essentially obsoletes ORMS.

merlin


In your view, would it be better to serialize in the pseudo-nested-csv (native row/array) formats?

--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: e: Running/cumulative count using windows
Next
From: Merlin Moncure
Date:
Subject: Re: Best way to populate nested composite type from JSON`