3 ms·
Also because the JSONB is so close to a relational data model it's a bit easier I've found to pick up some relational data work when needed or visa versa. Acco
by thoraway1010 6y ago
Also because the JSONB is so close to a relational data model it's a bit easier I've found to pick up some relational data work when needed or visa versa.
Accounting for user balances vis a vis some clearing and payment processing accounts? Let's do that with ref integrity and relational model.
Developers want to add all sorts of cruft and notes and weird data to the user record or order record they may want to look back on once in a while or display somehow, give them JSONB.
The alternative seems to a docDB that folks stretch 100 ways to sunday to try and shoehorn a relational model in, or visa versa (exploding schemas and slow dev velocity as whoever manages DB complains).
And with AWS doing hosted postgresql RDS somewhat recently with t3 micros as an option - it's really easy to reach for this hammer. I just do a 1 year reserved instance at $5/month for development, and you can deploy to any size.