What are the most popular and relevant databases for modern web development, and what are the key factors to consider when choosing a database to learn for web development purposes? Which one should I master in order to maximise my job opportunities in 3 years. I am geographically situated in Europe.
It depends definitely on the software you develop.
If you want to become a developer for websites, I guess the most popular database is still MySQL/MariaDB,
If you want to develop web applications for business purposes you need to evaluate if a relational or a document oriented database is the better choice. In my opinion Postgres and Mongo are the most upcoming databases today.
On the other hand there are still the good old Microsoft lover who work with asp .dot and MSSql.
At the end the company you will work for will choose the database and you need to learn it. Me, as a Freelancer for over 40 years, have used nearly any database one time in the past.
That said, a general understanding of database design/normalization and SQL (and No-SQL for comparison) will benefit you no matter what database software you end up using - it’s a case where Theory means a lot more than Syntax, until you get to the very specific optimizations.
Thank you for the great response. SQL is indeed a good option
Great response, thank you!
Hello this is Gulshan Negi
Well, there are most database available some of the best option which you can use are MongoDB and MySQL. And while selection you need to keep some factors in mind such as Scalability, Performance, Reliability, Cost.
SQL is a standardized language, but you were asking about specific databases
my advice is learn whatever database you wish, because if it uses SQL, you will learn its version of SQL, and that knowledge can then easily be transferred to another database which uses a slightly different version of SQL
I would like to suggest MongoDB and MySQL as both are the most popular and easy to use even for beginners.
MongDB and easy to use?
Even the installation is a nightmare…
First of all thank you for taking the time to reply and advice.
It seems like I have to learn all options. But a good place to start is SQL.
Database design is much more than SQL. For one thing, there are many versions of SQL depending on purpose, and I do not mean syntax. For example SQL - Wikipedia says:
SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).
The syntax of all of those is less important than the concepts of what they are used for.
Master MongoDB as it is more Document-oriented database, Flexible data model and easy to model DBMS.
So? What are the advantages of that?
That can be seen as an upside and certainly makes is easy when writing data, but it has downsides as well. All of a sudden you’ve lost all guarantees when reading data.
These are the best databases for Web development in 2023.
When I worked with WordPress I should never consider anything but MySQL. They are bound to each other sort of. This applies also to Drupal or any type of CMS that favor MySQL.
I should select Postgresql for all other purposes. Because it can handle both SQL and is pretty good at handling JSON (close to noSQL)
MySQL has market share of appr 46% PostgreSQL has market share of appr 18% according to 6sense.com. But according to StackOverflow Survey 2022 for Professional Developers PostgreSQL just barely took over the first place spot from MySQL. 46% vs 45%.