Would be great to have this option to store data in JSON. Thanks!
Just curious. What is special in a JSON field. You can store it in a txt field. That’s what I do.
Right that is what I did and it is “fine”. Coming from postgres (and using n8n as well) there is two advantages here.
One is I do not have to convert the string back to a json object when I get the rows of data. So in this case I get those rows and pass them into a code node to do some nice mapping of csv header rows to a database so users can upload csv files and we do the matching of columns for them)
Second, and this one is asking too much, we could query on the json as well like persons.metadata→>first_name LIKE “bob” but at that point it might be just remaking posgres and that seems overkill for the softr team to spend time on.
But yes text works just causes extra steps in the backend when I want to access that data. Thanks though for the idea.
1 Like