DEV Community

Thomas Bnt
Thomas Bnt Subscriber

Posted on • Edited on

3 1

What are the differences between each databases solutions?

For a project that requires a lot of requests to a database, which one would be the best, and what are the differences between them?

Top comments (5)

Collapse
 
dmfay profile image
Dian Fay

Databases are designed to handle "a lot of requests". Your data model is the most important determinant of what database to use, not your throughput, and if you don't have any reasons not to stick with a relational database, the answer is probably Postgres. If your needs diverge from the relational model, this is a good starting point for your research into NoSQL offerings.

Collapse
 
ben profile image
Ben Halpern

I guess it depends what a lot means.

I would err on the side of not overthinking this. Most mainstream databases are pretty damn good at what they do.

We’ve been more than happy with PostgreSQL.

Collapse
 
lisamathew14 profile image
lisamathew

DBMS software (Database management system) is the software that manages a database. Though with different names (Microsoft, Oracle, MySQL, IBM DB2, Sybase). Get the best dbms software in the industry from us. compare price, reviews etc at one place.

Collapse
 
jheijmans profile image
Jeroen Heijmans

As the others have mentioned, you'll be safe picking any of the four big relational databases (Oracle, MySQL, MS SQL, PostgreSQL). It's worth noting that, if you've really picked the wrong one, it's relatively easy to switch. With NoSQL, this is a bit harder as even with similar database models, there's often no shared query language.

Collapse
 
softwaredeveloper profile image
Tarun Jain

A database is a collection of data or records. Database management systems are designed to work with data. Sometimes referred to as database management systems (DBMS), database software tools are primarily used for storing, modifying, extracting, and searching for information within a database.

Credit : Cogxim Technologies

Postmark Image

20% off for developers who'd rather build features than debug email

Stop wrestling with email delivery and get back to the code you love. Postmark handles the complexities of email infrastructure so you can ship your product faster.

Start free

👋 Kindness is contagious

Engage with a wealth of insights in this thoughtful article, valued within the supportive DEV Community. Coders of every background are welcome to join in and add to our collective wisdom.

A sincere "thank you" often brightens someone’s day. Share your gratitude in the comments below!

On DEV, the act of sharing knowledge eases our journey and fortifies our community ties. Found value in this? A quick thank you to the author can make a significant impact.

Okay