Difference between MySQL and mSQL

1. mSQL :
Mini SQL, or mSQL, is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As its name implies, mSQL offers a subset of SQL as its query interface.

2. MySQL :
MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is developed and managed by Oracle Corporation and initially released on 23 May, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.

Difference between mSQL and MySQL :

1. It was developed By Hughes Technologies in 1994. It was developed By Oracle in 1995.
2. It is commercial. It is open-source.
3. Server operating systems for mSQL are AIX, HP-UX, Linux, OS X, Solaris SPARC/x86, Windows. Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris, Windows.
4. Its primary database model is Relational DBMS. Its primary database model is also Relational DBMS.
5. It supports XML. It does not support XML.
6. A subset of ANSI SQL is implemented. It supports SQL.
7. APIs and other access methods for mSQL are JDBC, ODBC. APIs and other access methods for MySQL are ADO.NET, JDBC, ODBC, Proprietary native API.
8. Programming languages supported by mSQL are C, C++, Delphi, Java, Perl, PHP, Tcl. Programming languages supported by MySQL are Ada, C, C#, C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl.
9. It does not support server-side scripting. It supports server-side scripting using JavaScript.
10. It does not support Triggers. It supports Triggers.
11. It does not support partitioning methods. It supports partitioning methods using Horizontal partitioning, Sharding with MySQL Cluster or MySQL Fabric.
12. It does not provide the concept of Referential Integrity. Hence, there are no Foreign Keys. It provides the concept of Referential Integrity. Hence, there are Foreign Keys.
13. It does not support ACID properties. It supports ACID properties.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

Article Tags :
Practice Tags :

Be the First to upvote.

Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.