![]() ![]() MySQL has a plethora of problems and shortcomings, but it’s gradually improving (akin to PHP with the introduction of PHP 7) → This means that MySQL is the de facto industry standard.MySQL is one of the world’s most popular databases.The positive effects of this acquisition is outlined by Markus Winand in his blog post titled One Giant Leap For SQL: MySQL 8.0 Released: Upon acquisition by Oracle, MySQL has improved tremendously. Here’s the good news: MySQL fixed it! However, it only happened in April 2019, so it’s easy for most developers to end up out of the loop. MySQL has always been criticized for this odd behavior - after all, other relational databases (Db2, Oracle DB, PostgreSQL, SQLite, etc.) don’t have this problem. A good example is the check constraints which are ignored in the create table statement. In this environment, it’s easy to miss all the changes that happened to MySQL over the years. Of course, this is a more typical scenario for businesses rather than individual users - the IT departments often cannot explain the benefits of investing X thousand dollars and Y man-hours into upgrading, and so all in-house developers of this company are stuck with, say, MySQL 3.0. Switching to a different database system (or upgrading to a new version, for that matter) is too costly, so business/users are stuck with older software. Our experience tells us that this problem of “database conservativeness” is rooted in the costs. This problem has been highlighted by an SQL expert Markus Winand who often starts his conference speeches with a (somewhat) humorous question: If you’re still using SQL-92, why aren’t you using Windows 3.1? It was released in 1992 as well! ![]() Just like many websites are still running outdated technologies like JQuery, many companies are still using outdated MySQL versions. Still, SQL is as in-demand as ever - and it becomes a real advantage when applying for jobs.ĭatabase architecture is always easy to criticize because companies are usually reluctant to change it. SQL is often viewed as an “obscure back-end-only technology” which the hip new generation doesn’t really need. ![]() This statement is echoed by a machine learning expert Vicki Boykis in her blog post titled Data science is different now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |