3 ms·
Don't understand if you are being sarcastic. I can say that the giant blobs of XML in our text fields are very annoying. I have to compare them with Kdiff and t
by Noumenon72 9y ago
Don't understand if you are being sarcastic. I can say that the giant blobs of XML in our text fields are very annoying. I have to compare them with Kdiff and too many of them don't fit in DBVisualizer's buffer.
- steve_adams_86 9y agoI think sarcastic. Psql has great support for json - they were probably taking advantage of it. If you've already got psql set up in your project and have minimal json storage requirements, it can be all you need. You also gain the possibility of retaining some normalization of the data if necessary, which is a lot more complicated if you throw it all in an entirely different database.
- grzm 9y agoSmall nit: psql is the command line client bundled with Postgres (PostgreSQL). And yeah, the JSON/JSONB support in Postgres is pretty nifty. Postgres 10 added full text search for JSON/JSONB columns.
- steve_adams_86 9y agoOh geez, you're right. It's really the only way I use postgres so I kind of equated the names, but yeah, different tools.