Things that I’ve had a burning desire to accomplish and understand have gone from impossible to just really challenging… I’ll take it. I’ve made more progress in a few days with this trial than I have in years Obsessing over this stuff in my off time…
Hi, can you use JSON columns to create a NoSQL db in Postgres?
I need to store a series of items in db but each items has different parameters (in example: one can have length width height while other it’s ed can have diameters etc)
Can I use Postgres JSON Column to manage the difference field for each item ?
Thank you
Roberto
Yes you can. I often store the whole $POST value in a JSON field. It’s very flexible and saves having to create many useless columns
1 Like
Thank you very much will start to study it 
Any problems, drop me a line.
1 Like
Strange.
Your DevOps must have setup your Mongo cluster very poorly, bad indexing, or you are using PHP(why?) as on large set full text searching our Mongo clusters far out perform Postgres - you can’t even compare. Same for doing scraping we get unrivalled write speeds using Golang to mongo.
Only thing faster for searching is running Elasticsearch but that costs an arm and a leg plus not everyone knows map reduce.
Out of curiosity which language were you using to do the calls to Mongo?
Node, Python, Golang or… ?
Yeah, maybe. It’s just a bad memory now.