SQL vs NoSQL

Audrus
Audrus
Jul 28, 2017 · 1 min read

I have to choose a database for this project (my previous articles). I have been working with MySQL and PostgreSQL for about 10 years. I know SQL syntax, optimisations, ORM very well. But for this project I saw NoSQL databases like MongoDB. For this project a database will have to save data blocks: users’ authentication and authorization, articles, comments, users’ behavior, logs, payment plans and etc…

So, I woud like to choose MongoDB, because it is popular, and the queries have JSON format, and a big community. Yes, I know about MongoDB attacks, about headache for it’s transactions, not enough analytics and etc… But I can choose other NoSQL salutions like CouchDB with ACID support. I don’t want any database problems in future.

I chose two databases: SQL and NoSQL. MySQL database in this project works with users, articles, payment plans blocks and MongoDB — comments, users’ behavior, logs and other blocks.

Audrus

Written by

Developer: Spring, Nodejs, Reactjs.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade