[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Proposal for LedgerSMB 1.5: Move to Pg 9.2 and use JSON for extended attributes

I opt for:
move to Pg 9.2 as a required version and use JSON

2012/9/17 Chris Travers <..hidden..>:
> Hi all;
> I have been thinking about the way we handle customizations in old code vs
> new code where new fields need to be added.  Currently adding these for old
> code is pretty easy, but adding them for new code is a little more
> problematic.  We have two options going forward:
> 1)  We can move to Pg 9.1 as the required version and add a dependency on
> hstore.  An hstore field can be attached to every major object type,
> retrieved and submitted with the stored procs, etc.  We could actually also
> do the same in 8.4 using a text field to store JSON but the db would be
> unable to validate it.
> 2)  We can move to Pg 9.2 as a required version and use JSON in the same
> way.  We wouldn't need to depend, out of the box, on plv8js or any other
> extensions but customizations that might use this would be possible.
> 3)  We could continue with 8.4 and store as XML.  This would give us
> validation and xpath functions.  There is more XML functionality in
> PostgreSQL (any version) than there is JSON functionality.
> My preference currently is to move to JSON since it is a little easier to
> reliably convert to/from Perl data structures, and would be a little easier
> in other languages, probably, too.  What does everyone else think?
> Best Wishes,
> Chris Travers
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel