3 ms·
This is a really serious indictment, folks: “Also, they were doing some unusual things, such as storing JSON strings in a text field in a PostGres database”
by dev360 9y ago
This is a really serious indictment, folks: “Also, they were doing some unusual things, such as storing JSON strings in a text field in a PostGres database”
- itronitron 9y agoI will keep that section in mind the next time I see a job posting at a startup that requires PostGres experience :)
- Noumenon72 9y agoDon'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.