Should I use Metafields or a database for customer reviews?

Hello , I am developing an app that has the functionality for customers to submit product reviews. To save the customers’ reviews should I use Metafields or store the reviews in database ? . If, the answer is database, then should I make a new database for each store ? Thanks.

Good question, it depends on your usecase. Here are some considerations:

  • metafields are accessible by other dev/ store staff who have write access so they can modify it
  • metafields are great one way to have one copy of the data, no need to make a database synced.
  • Metafields are limited by the bulk edit

No you do not need a db for each store.