News for hackers. Stuff that matters.

A comment on When to Avoid JSONB in a PostgreSQL Schema. Parent comment

Re:When to Avoid JSONB in a PostgreSQL Schema by sk5t on Thursday September 01, 2016 @10:54PM (#12410498)
Multiple, independent apps poking changes into the database is a kind of failure too. For writer apps > 1 it is often preferable to route them through a middle tier / web API / etc.
[ Parent | on HN ]
Re:When to Avoid JSONB in a PostgreSQL Schema by strommen on Friday September 02, 2016 @12:12AM (#12410789)
Data lives far, far longer than applications. You may not have multiple apps using the database now, but if your system lasts 10 years or more than it certainly will.
[ Parent | on HN ]
Re:When to Avoid JSONB in a PostgreSQL Schema by inopinatus on Friday September 02, 2016 @02:57AM (#12411383)
I think this approach creates bottlenecks and ultimately has an inner-platform effect.

Use your RDBMS to the max, they are powerful tools!

[ Parent | on HN ]