Databases to look for in 2021
Tags: database, cloudskills, devops, dbms
Published: 2021-02-10 04:18:50

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 :smile: 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 :wink: 
# 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](https://www.linkedin.com/in/mursalfurqan/) for new articles. Till then, #HappyLearning :wave:

<img width="100%" style="width:100%" src="https://media.giphy.com/media/xUPOqo6E1XvWXwlCyQ/giphy.gif">