How I can store the Nested json list in a local data base and access them using moor? #1374
Replies: 1 comment
-
I think the best approach to store this information is to use type converters. By using other packages like Depending on your use case, you can also extract some information into additional tables. For instance, you could choose to only store the picture and the name as a serialized string and write a table for the rest: class Users extends Table {
TextColumn get gender => text()();
TextColumn get email => text()();
// ...
} In general, an advantage of type converters is that they're easier to use. Especially for deeply-nested data and arrays, SQL can be a bit of a pain for simple queries. On the other hand. extracting information into tables enables more efficient queries. It also allows you to select a subset of data more easily. |
Beta Was this translation helpful? Give feedback.
-
My JSON is as below:
Beta Was this translation helpful? Give feedback.
All reactions