Can the store metafield be used as a custom table?

Retired Boards Appdev Metafields
1

I would like to create a custom table that stores a totally new type of information. As a result I am thinking of storing it on a sub-property of the store metafield. Something like this:

store.trades.firstName

store.trades.lastName

store.trades.tradeDate

store.trades.itemsQuantities

In SQL the last field, items would be a separate table. Here I’m thinking of simply stringifying an array.

Is this the best approximation of a custom table for this use case or is there a better way?

2

If you are looking to keep data on the Shopify side, that’s the best you can get.

1 Like
3

Thank you. If I opt to use Cloud Firestore or other external database, is it safe to save auth credentials in a public app? Or can individual store owners see the code of public Shopify Apps they use?