2 ms·
I don't think I'd ever want to _serve_ json from the db, and as you say, I'd tweak the data for common usage anyway. But my use case is the opposite: I am stor
by riffraff 14y ago
I don't think I'd ever want to _serve_ json from the db, and as you say, I'd tweak the data for common usage anyway.
But my use case is the opposite: I am storing exactly the data coming from external APIs.
My table has some fields I already extracted from the JSON
data, cause I need them now, yet I don't want to throw away the full data, as I may need it in the future.
So, I was storing the original JSON as text.
But, having support for the API format in the db itself is much better, as I can also actually query and manipulate this data without pulling all the text fields in my client code.