DEV Community

Cover image for MongoDB vs MySQL
Nasirul Islam
Nasirul Islam

Posted on

2

MongoDB vs MySQL

MongoDB

MongoDB is a cross-platform document-oriented database program. And MongoDB is a NoSQL database program. MongoDB uses documents like JSON with optional schema. MongoDB is developed by MongoDB Inc. and licensed under the Server Side Public License.

NoSQL Database

NoSQL Database is a non-relational Data Management System, that does not require a fixed schema. And NoSQL databases are databases that store data in a format other than relational tables. That's is, A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. NoSQL database stands for “Not Only SQL” or “Not SQL.

MySQL

MySQL is an open-source relational database management system from the Oracle Corporation. Like other relational systems, MySQL stores data in tables and uses structured query language (SQL) for database access. When MySQL developers need to access data in an application, they merge data from multiple tables together in a process. In MySQL, we predefine our database schema and set up rules to govern the relationships between fields in our tables.

SQL Database

SQL stands for Structured Query Language which is basically a language used by databases. SQL lets you access and store, manipulate, and retrieve data within relational databases. Data in tables is stored in row and column format at the logical level, but physically it stores data in something called data pages. A data page is the fundamental unit of data storage in SQL Server and it is 8KB in size. Using SQL, you are able to interact with the database by writing queries, which when executed, return any results which meet its criteria.

Conclusion

From this tutorial, we have learned about MongoDB vs MySQL

Learned from the internet.

Thanks for reading

Reach out to me on:

Billboard image

Monitoring as code

With Checkly, you can use Playwright tests and Javascript to monitor end-to-end scenarios in your NextJS, Astro, Remix, or other application.

Get started now!

Top comments (1)

Collapse
 
thenickest profile image
TheNickest

I am missing a bit the versus part. To get an idea when does which make sense.

Billboard image

Imagine monitoring that's actually built for developers

Join Vercel, CrowdStrike, and thousands of other teams that trust Checkly to streamline monitor creation and configuration with Monitoring as Code.

Start Monitoring

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay