DEV Community

Cover image for Databases to look for in 2021
Mursal Furqan Kumbhar
Mursal Furqan Kumbhar

Posted on

Databases to look for in 2021

Being a dev. from the beginning, I didn't like working on Databases. Rather if I should compare, I like them as much as one would like ice-cream on their french fries 😄 But for my current job, I needed to learn databases. And as this has been my practice, I don't just learn, I first research, and then I learn.
So here's a list of 5 databases that, according to many websites, will remain the top trend in 2021. And by top trend here I mean, will be mostly recommended by clients, companies, and stakeholders that we SEs know of 😉

Databases to look for in 2021 (Top 5)

1. MySQL

Description: MySQL is used in almost all the open-source web projects that require a database at the backend. MySQL is part of the powerful LAMP stack.

  • LAMP : LAMP is known for its free and open-source approach to back end development. It contains Linux OS, Apache web server, MySQL database, and PHP. Besides PHP, developers can also use Python and Perl as an alternative.

Platforms: Generally, you can use almost any platform or MySQL, but it is preferred to use:

  • Linux
  • Windows
  • Mac

Compatible Languages: MySQL works best with C, C++, Java, PHP, Python, Perl, Oracle

2. PostgreSQL

Description: PostgreSQL is an advanced, enterprise-class, and open-source relational database system, It supports both, SQL for relational and JSON for non-relational queries.

Platforms: Generally, you can use almost any platform or PostgreSQL, but it is preferred to use:

  • Linux
  • Windows
  • Mac

Compatible Languages: PostgreSQL works best with the following programming languages R, Python, Java, PHP, Ruby,

3. MongoDB

Description: MongoDB is an open-source NoSQL database management program. MongoDB is a document-oriented NoSQL database used for high volume data storage.

Platforms: MongoDB is one of the few available databases that can be used for Cross-Platform data integration.

Compatible Languages: MongoDB works best with C, C++, C#, Java, Ruby, Perl

4. Microsoft SQL

Description: Microsoft SQL or SQL Server is a database server by Microsoft. It is a special-purpose programming language designed to handle data in the relational Database management system.

Platforms: Microsoft SQL Server is compatible with Docker, Ubuntu, SUSE Linux Enterprise Server, and Red Hat Enterprise Linux.

Compatible Languages: Microsoft SQL Server is best compatible with C, C++, C#, and Java programming languages.

5. SQLite

Description: SQLite is an in-process library that will implement a self-contained, serverless, zero-configuration, transactional SQL database engine. In contrast to other databases, SQLite is not a client-server database engine. Rather, it is embedded into the end program.

Platforms: SQLite can be used be with Blackberry, Symbian, Maemo, Android, MeeGo, WebOS, NetBSD, FreeBSD, illumos, Solaris 10, Windows, Tizen

Compatible Languages: Generally, SQLite is supported by all the upcoming major languages in the market, but C, C++, C#, Java, PHP, Python, and Ruby are still the most suitable languages to work with SQLite.

I hope so You would have had gained something new from this article. Stay updated with my LinkedIn for new articles. Till then, #HappyLearning 👋

Top comments (3)

Collapse
 
ivolimmen profile image
Ivo Limmen

SQLite suitable for cloud, but PostgreSQL not? I think you got them mixed.

Collapse
 
arvindpdmn profile image
Arvind Padmanabhan

Beginners may find this about SQLite useful: devopedia.org/sqlite

Collapse
 
gat786 profile image
Ganesh Tiwari

I cant help but notice that you have mentioned PostgreSQL as not compatible with cloud. Can I get to know what do you mean by that?