top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+4 votes
3,484 views
What is the difference between SQL, MySql, Sqlite, Sqlite3
posted Mar 10, 2015 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+3 votes

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.

answer Mar 10, 2015 by Salil Agrawal
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.
0 votes

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.

answer Apr 28, 2016 by Karthika Qpt
...