When designing a new data model, there are many possible data models for storing information. We could choose to store information with a JSON blob or creating a database table with column for each information.

Scenario

  • Imagine we are going to design an admin dashboard (page A), where we need to display our users’ information such as date, name, age, sex, job, salary etc.
  • This application has both mobile and web view
  • Using GraphQL API with relational database

Proposed Solutions

In this post, we are going to compare two different approaches:

#graphql #data-model #database #json

GraphQL - Object Types (Columns) vs. JSON Field (JSON)
3.05 GEEK