What is the difference between SQL, MySql, Sqlite, Sqlite3

Answer 1

SQL is a programming language to manage data and data definition in RDBMS.
Example: "SELECT * FROM users WHERE lastname = 'Agrawal';"

MySql is a relational database management systems (RDBMS), which hold databases that are based on relations. (Other RDBMS are e.g. Postgresql or MS SQL Server)

SQLite is also a RDBMS but a lightweight one, it doesn't require it's own process, clustering or user management unlike MySQL or others RDBMS. SQLite consist of a single file and a library to make your application interact with it. The typical example is storing bookmarks on a web browser, or minor database in mobile apps.

SQLite3 is the version 3 of SQLite which provides - more compact format for database files, manifest typing and BLOB support, support for both UTF-8 and UTF-16 text, user-defined text collating sequences, 64-bit ROWIDs and Improved Concurrency.

Comments

Please clarify my understanding..

Mysql,sqlite and sqlite3 all are RDMBS and uses SQL language.. right?
and what about oracle...?
Oracle is also RDBMS and it uses SQL language.. right?

---

Yes that true Oracle is also RDBMS with SQL language :)

---

Thanks for helping as always.

---

Actually Mysql, sqlite, SQL, sqlite3 is nothing but a language which we use to retrieve data in our oracle system. Oracle is object-relational database management system. Now I think you will understand.

Answer 2

SQLite (and Berkeley DB, which is architecturally similar although it's a sort of "NoSQL db) are highly useful for standalone apps and apps on small devices.

The big difference is SQLite is a app-resident library, while MySQLis typically used as a client-server DBMS where the client process interacts with the DB server process using some sort of networking.