Re:Why HStore2/jsonb is the most important patch of PostgreS...
by einhverfr on Sunday February 23, 2014 @08:23PM
(#7288599)
> What does it matter if it is JSON or not.
It makes it easier to pass the complex data regarding a financial transaction into a stored procedure all at once. That's the non-trivial part today.
What does it matter if it is JSON or not. In financial transactions you want:
* Maximum fault tolerance * Auditability * Security * Performance * Ability to roll it back with all the cleanly defined states in between * Ability to talk to legacy / standard systems
JSON-ifying the contents of the transaction is nice. But I wouldn't think that is the main pain point in the industry at the moment. It is really the behavior of the systems outside the transaction contents itself that matters.