DB-Tools.com - system comparision
21st May 2019, Tuesday

 

Home > System Comparision

MySQL System Properties

Please Choose another system to see its propertiess Click here

Editorial information provided by DB-Tools
 System MySQL
  Db-Tools Ranking

Trend Rank   

Score : #13.21

Rank :  #2  Overall
       #2  Database
 Name MySQL
 Version MySQL 8.0.11 (2018-04-19, General Availability)
 Drawbacks -Does not support a very large database size as efficiently
-Does not support ROLE, COMMIT, and Stored procedures in versions less than 5.0
-Transactions are not handled very efficiently
-It has got a few Stability Issues
-It suffers from Relatively Poor Performance Scaling
-Its functionality Heavily Dependant On Addons
 Advantages -Open-Source
-Easy To Use
-Support is always readily available
-Inexpensive and still very much industry standard
 Languages Supported Perl, PHP, Python, ASP, C, C++, JAVA
 Website www.mysql.com
 XML Support yes
 JSON Support yes
 Brief description -open-source relational database management system
-fast, reliable, scalable, stable and true multi-user, multi-threaded sql database server
-works in client/server or embedded systems

-open-source relational database management system
-fast, reliable, scalable, stable and true multi-user, multi-threaded sql database server
-works in client/server or embedded systems

 Database Model Relational Database, Supports ER Diagram Model and we can create and manipulate a model graphically
 Technical Documentation dev.mysql.com/doc/
 License MySQL is Open Source, licensed under the GNU GPL.
 Cloud-based / SaaS Integrated with Oracle Cloud Services for development and deployment
 Implementation Language C and C++
 Operating System Supported AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64
 Options for Integration / Access API Both X DevAPI, Connectors & APIs available. Connector/C++ X DevAPI, Connector/J X DevAPI, Connector/NET X DevAPI, Connector/Node.js X DevAPI, Connector/Python X DevAPI, Shell JavaScript API, Shell Python API, PHP Connector, Connector/ODBC, ClusterJ, C API, MySQL for Excel, MySQL for Visual Studio
 Consistency Yes
 Foreign Keys No
 Streaming Support Yes
 Data Storage Schema NA
 Analytics Support NA
 Notable Users Most of the startups and SME use this stable open source database.
 Key Differentiator Was the GoTo Open Source Database. new features have been slow after oracle acquisition.
 Concurrency Yes
 Partitioning No
 Replication Yes
 Secondary Indexes Yes
 SchemaLess No
 SQL Query Yes