Source: blog.arctype.com
Forget SQL vs NoSQL - Get the Best of Both Worlds With JSON in PostgreSQLCategory: Database, Data, container, yaml
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL Have you ever started a project and asked - "should I use a SQL or NoSQL database?"
In this article I cover the benefits of using JSON, anti-patterns to avoid, and an example of how to use JSON in Postgres.
The original creator of JSON, Douglas Crockford, attributes the success of JSON to its readability by both developers and machines, similar to why SQL has been dominant for almost 50 years.
When you try to model data in PostgreSQL, the best practice is to still default to a relational model and only use JSON when it makes sense.
In this article I cover the benefits of using JSON, anti-patterns to avoid, and an example of how to use JSON in Postgres.
The original creator of JSON, Douglas Crockford, attributes the success of JSON to its readability by both developers and machines, similar to why SQL has been dominant for almost 50 years.
When you try to model data in PostgreSQL, the best practice is to still default to a relational model and only use JSON when it makes sense.
Related Articles
Community Partners
DevOps Careers