Tech

SQL beats NoSQL, MySQL is the most popular-ADTmag

news

Database Trend Report: SQL outperforms NoSQL, MySQL is the most popular

Good old SQL still dominates the roost of the database, while popular products at NoSQL camps fill the gap, MySQL is the most popular of all.

new 2019 database trends The report from ScaleGrid summarizes the above information from the data collected from the participant survey. DeveloperWeek 2019 Meeting.

“SQL has been a major leader in non-relational alternatives for decades, but NoSQL is rapidly closing the gap with popular databases such as MongoDB, Redis and Cassandra,” the report said. I am. “Many organizations have opted for migrating from legacy databases such as Oracle, but not all are migrating to the NoSQL method. Based on findings, SQL is increasing with increasing demand for systems such as PostgreSQL. Still holds 60%. ”

Of all the databases, MySQL was the first choice reported by respondents, with references from about 39%, followed by MongoDB at about 25%, and PosgreSQL at about 17%. All the remaining individual database responses (Redis, Cassandra, Oracle) received less than about 8% of the responses, while all other products were CouchDB, Berkeley DB, Microsoft SQL Server, Redshift, Firebase. It has been grouped into the “Other” category, which includes. , Elasticsearch and InfluxDB.

ScaleGrid is the top database mentioned in its report DB-Engines For Oracle, a longtime leader in the rankings, especially the latter index, the new report returns to 1.8%. DB-Engines also ranked MySQL high, but its second-ranked database, SQL Server, was pushed to the “Other” category of ScaleGrid reports.

“So which is the most popular database in 2019?” The report asked. “You might think that Oracle stole the show because we know that more than three-fifths of the respondents are using SQL. Guess again. MySQL dominates this report. I did … ”

After noticing the disconnection of DB-Engine, ScaleGrid said, “I expected the presence of Oracle database users to be much higher, but at the world’s largest developer exposition, that expression was low.” ..

Other highlights of the report are:

  • Use of single and multiple databases: “Almost half of the organizations we talked to are actually using multiple types of databases to enhance their applications rather than a single database. 44.3% say they use multiple databases. Reported, 55.7% operate in one database. ”
  • Combination of multiple SQL and NoSQL databases: “75.6% of the use of multiple database types consists of a combination of both SQL and NoSQL databases.”

    The most popular combination of multiple database types
    [Click on image for larger view.]The most popular combination of multiple database types (Source: ScaleGrid)
  • The most popular combination of multiple database types: “A clear winner in more than one-third of the use of multiple database types is the combination of MySQL and MongoDB. MongoDB is often considered an alternative to MySQL, but if properly designed, the two databases Works well. The second most popular combination was MySQL. And with PostgreSQL. These two SQL databases are clearly competitors, but can be used together to store different datasets. . ”
  • The most time-consuming database management task: “Monitoring ranked first with 12.6% of respondents, and backup, disk space management, scaling, and table joins ranked second with 11.6%.

    The most time-consuming database management task
    [Click on image for larger view.]The most time-consuming database management task (Source: ScaleGrid)

    “Standalone in 3rd place maintained and redistributed changes between views and stored programs at 8.7%, and in 4th place tied at 7.2% per cleaning and database setup.”

  • The most important metrics tracked for database performance: “Query response time was not only the most tracked metric, but also the majority, accounting for 51.8% of responses. It was 30.8% from the most time-consuming PostgreSQL administration task report edited in October 2018. So I expected this to lead, but when I extended this question to all database management systems, it increased significantly. Query speed is a slow query that can impact application performance. It’s a very important indicator for continuous tracking so that you can identify. ”

ScaleGrid doesn’t provide a reporting methodology, but says it surveyed “hundreds of developers, engineers, software architects, development teams, and IT leaders.”

ScaleGrid provides a managed Database-as-a-Service (DBaaS) platform that supports MongoDB, Redis, MySQL, and PostgreSQL in both public and private clouds.

About the author

David Ramel is the editor and writer of Converge360.

SQL beats NoSQL, MySQL is the most popular-ADTmag

Source link SQL beats NoSQL, MySQL is the most popular-ADTmag

Related Articles

Back to top button