MySQL vs MongoDB

So, you may know these databases, but I would like to know what you thing about it. I know how to use both, but I don’t know which one to use. This is for a project I am working on. So some support would be nice.

  • MongoDB
  • MySQL

0 voters

I like mongo as its very easy to use and I can see all the changes and documents when I’m testing it

5 Likes

Yep I agree mongodb is easy to use and best

2 Likes

If your using a host or VPS, MongoDB is good from what I’ve heard, but I have had lots of trouble installing the MongoDB driver on my Raspberry Pi.

1 Like

Good point. I plan on using their free their until I can’t.

I use nedb which is just MongoDB but is more of a lighter version.

You’ll mostly find people using mongodb because it’s easy to use with node but mysql is just one single server that supports sql out of many

1 Like

i prefer redis (speed mostly)

@TurboBiscuit i am trying to keep it cheap, so I don’t think I’d use redis.

There are lots of free mysql hosts and even some postgresql, mongodb also offically has free 512mb hosting

Yeah, but most MySQL hosts have bad uptime or REALLY strict rules.

1 Like

Really? Mine, doesn’t have much rules and maintence only occurs once every few months. I get it from pythonanywhere.com 's database section. They might be generous enough to give you a free postgresql database also

I prefer mongodb for its really easy to use with node.js projects, and you can host it for free with Atlas. Which also makes latency low if you choose aws east server.

1 Like

mongodb atlas, i always go for AWS-west (Ireland) so i can get a better connection to my database

So. For a little bit, I have been making an API with MongoDB. I have made one with MySQL. I find Mongo to be easier to code, but MySQL has the upper hand when it comes to functions. For instance to find something is Mongo, I have to use .findOne(jsonhere) but with MySQL, I can do (“SELECT FROM ‘table’ where (blah blah blah)”)

I prefer MySQL, I self host the server so we get really good performance and speeds out of it (less than 1ms), but if you really need a free database, go for MongoDB Atlas (though I’ve experienced some very slow query speeds with MongoDB Atlas during testing, 100-200ms) or sqlite3 when you can. I mostly chose MySQL since I’m very familiar with SQL and I don’t really like the MongoDB structure.

Whenever I am using Glitch, I always go for AWS (which Glitch hosts with) and one of the free American locations, as I assume the Glitch servers would be hosted in America too, so therefore I would get the fastest speeds possible :slight_smile: After all, I don’t need a better connection to the database, the app does.

2 Likes

S I have chosen to use Mongoose over MySQL. I am not gonna close the poll cause l’d like to see what other people think.

1 Like

I use quick.db because its name actually describes pretty well how fast it goes.

1 Like

I need something I can use with other hosts and that can’t be wiped by corruption