-
I need to store list of strings in table in schema, however there are only text, real and integer options. Is there a support from PowerSync to do so? |
Beta Was this translation helpful? Give feedback.
Answered by
rkistner
Oct 30, 2023
Replies: 1 comment 1 reply
-
You can use |
Beta Was this translation helpful? Give feedback.
1 reply
Answer selected by
Gambley1
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
You can use
json
,jsonb
,text[]
, or any other array type. PowerSync converts all of those to JSON text, which you can then query using SQLite's json1 functions, or parse in the app code.