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)
SQLite suitable for cloud, but PostgreSQL not? I think you got them mixed.
Beginners may find this about SQLite useful: devopedia.org/sqlite
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?