MSSQL, MySQL & SQLite

SQL stands for Structured Query Language; it is a language designed to access and manage data stored in a Relational Database Management System (RDBMS). You can add, retrieve, remove, or access data within a database with the help of SQL at any time using some basic queries.

In short, SQL not only allows users to access data stored in a Relational Database Management System but also creates, deletes databases and sets permissions on database tables, views and procedures.

MSSQL is a suite of database software published by Microsoft and used extensively within our enterprise. Typically, it includes a relational database engine, which stores data in tables, columns and rows, Integration Services (SSIS), which is a data movement tool for importing, exporting and transforming data, Reporting Services (SSRS), which is used to create reports and serve reports to end users, and also Analysis Services (SSAS), which is a multidimensional database used to query data from the main database engine. Microsoft SQL Server (MSSQL) is widely used in enterprise deployments.

MSSQL is a scalable data platform which includes several ETL (Extract, Transform and Load) tools and reporting services where data can be added, modified and queried using a standardized structured query language (SQL). MSSQL is an evolving data platform used for mission critical business and data solutions on premise, in the cloud and on hybrid platforms.

MySQL is currently the most popular database management system software used for managing the relational database. It is open-source database software, which is supported by Oracle Company. It is fast, scalable, and easy to use database management system in comparison with Microsoft SQL Server and Oracle Database.

It is commonly used in conjunction with PHP scripts for creating powerful and dynamic server-side or web-based enterprise applications. It is developed, marketed, and supported by MySQL AB, a Swedish company, and written in C programming language and C++ programming language.

The official pronunciation of MySQL is not the My Sequel; it is "My Ess Que Ell". Many small and big companies use MySQL. MySQL supports many Operating Systems like Windows, Linux, MacOS, etc. with C, C++, and Java languages.

SQLite is a software library that provides a Relational Database Management System. The lite in SQLite means light weight in terms of setup, database administration, and required resource. SQLite has the following noticeable features: self-contained, serverless, zero-configuration and transactional.

SQLite is the lite form of SQL which runs on low powered devices or the devices with low memory such as mobile devices, Personal Digital Assistant (PDA) or pocket music players. SQLite is not a client–server database engine. Rather, it is embedded into the end program. SQLite is file-based whereas SQL is a server based.