Jesus Christ, that's JSON Bourne.
post
Yes that's right, it goes into postgres.
replies:
“You know what ELSE everybody likes? Postgres! Have you ever met a person, you say, ‘Let’s use some Postgres,’ they say, ‘Hell no, I don’t like Postgres’? Postgres is perfect!”
replies:
who needs any of that when you have microsoft access
replies:
Yeah, I took one course where we used MongoDB. I was like "still unconvinced, but I'll keep this in mind if I run into situations not covered by PostgreSQL." ...I've not run into situations not covered by PostgreSQL. Everything will be covered by PostgreSQL.
Yeah, but is it web scale?
replies:
Just use Mongo, it scales so well!
Never understood why anyone chose Mongo. Though I have some funny memories getting rid of it because it was slowing the app down sooo much.
If you need something for storing JSONs and querying, just use ElasticSearch/OpenSearch.
replies:
Had to roll my own JSON storage system after spending weeks trying to get sqlite to work on Godot/android.
It took a day and will suck at scale because there are no indexes. It just goes through the whole file, line by line when you search for an id.
BUT IT WORKS.
Hopefully the repos and stuff I piled on top have made it abstract able enough I can move it to a real database if the issue ever gets resolved.
replies:
I manage instances of both mongo and postgres at work.
I'll say Mongo OpsManager is pretty sweet, and HA is way easier on Mongo.
Wait you guys don't just write data to a .txt file?
/s
replies:
Pros and cons
I really dislike JSonB in Postgres. Just use a ORM at that point.
replies:
top 58 comments