MongoDB, Cassandra, DynamoDB and etc.
Also, do you use VM or container to run it?
MongoDB, Cassandra, DynamoDB and etc.
Also, do you use VM or container to run it?
Iām currently working on a project using RavenDb.
For dev weāre running it in docker, for prod just using RavenDb Cloud
Took a while getting used to it coming from SQL with very little MongoDB experience, but now quite like it.
I just use PostgreSQL, including for nosql stuff, when I need some advanced features then it has it, without needing to add āyet anotherā database of something else.
Yep, tbh Postgres has everything we need, from GeoJSON to just JSON support with good support for querying inside the JSON.
Iāve to work with Mongo for one of my clients, I just want to leave this world each time Iāve to interact with Mongo.
But it seems that SurrealDB is good. Iāve never tried tho.
What is the biggest problem with MongoDB?
I saw replies that they use PostgreSQL instead (if possible).
I think itās an issue with NoSQL.
No joints, not ACID, duplication of data, constraints on read rather on write.
Some NoSQL tries to solve this ālackā of features.
I said lack with quotes because usually thatās what youāre seeking for when choosing NoSQL.
The biggest pain point for me is querying, especially nested stuff. This drives me crazy.
Nevertheless, I go with PG as default, if I need to store JSON, Iāll go for JSONB in PG. Same for GeoJSON, Iāll use PostGIS, etc.
Thought it doesnāt support sharding, but thereās other way to get this mechanism in SQL.
Iāve used DynamoDB to act like an event store, same goes for Firebase.
At work weāve a MongoDB database, with Rails backend, the thight coupling beteween MongoDB and the models make the migration task almost impossible, or weāll have to cut the development of any feature during 6 months or moreā¦
We were initially using CouchDB for a year or two, then we move to CouchServer. Its replication capabilities is what we like the most.
Weāre on Azure, and we are using CosmosDB.
Plus PostgreSQL is pluggable, if you need some extremely fast KV storage or document storage or so you can use PGSQL straight, but you can also install a plugin for, say, a new table type that has that nosql speed for that specific type of data, all within the same system and no changes to your code. There is really no reason to use anything but postgresql unless you want easier and faster transparent scaling or so (and pgsql is really good at scaling now too, just has to be a bit more planned in comparison, but its vastly easier than itās ever been before)
Iād say PG too if you really need it⦠just ask yourself whether you do or not
Welcome back ODL
If I start a project from scratch, this is also the way Iād choose
Btw: If someone likes experimenting:
https://newdatabase.com/en/default.html
I choose Postgres as the default. The only reason to look for something else is when Postgres does not solve a specific problem well. I have put JSON documents in Postgres, and it works great.
Problems that Postgres did not solve well:
My vote goes to PG as well
I didnāt know that you can use PostgreSQL as a NoSQL database. I know it can store JSON, but I didnāt know it has that full functionality of a NoSQL db.
I donāt worked with nosql databases. But in one time I studied the types of databases. And prefer for future my projects use mongodb or redis.