In which programming language is a Mysql database written? And how is it differ from Oracle database?

[George Murphy]

In which programming language is a Mysql database written? And how is it differ from Oracle database?

[Albert Cooley]

MySQL is free and open source, was originally developed by a company that incidentally ended up being taken over by Oracle.

MySQL came way after the popular RDBMS of the early days - MS- SQL Server and Oracle who were the most popular (besides Sybase). MySQL was part of the Open source trend and thus became popular among developer communities and also part of the LAMP webapplication stack.

To answer your original question it is developed using C,C++, with yacc (yet another C compiler) for the compilation of the SQL scripts. I am not sure why this matters to you.

They are mostly similar. Besides the price factor (where MySQL scores), there are other differences - Oracle has a better support model, more features and reliability/maturity (having been around for way longer).

Oracle also works well with the other plethora of tech offerings from Oracle and considered enterprise grade, while MySQL is a great choice for small and medium companies.

четверг, 30 марта 2023 г. в 21:38:27 UTC+3, George Murphy:

[Michael Kurz]

I agree with the answer above, and may also add that I personally choose the Oracle database because it has excellent support and works with many other applications. You can also find good tools for it, I regularly use dbforge for schema compare oracle . This saves time and you can use it to automate immigration changes.

пятница, 31 марта 2023 г. в 03:09:00 UTC+3, Albert Cooley: