What is difference between SQLite and SQL

Question

I know SQLite Data Base is used in mobile devices (Android, iPhone) and it is light, takes only Kb space. Is there any limitation in SQLite? I want to know how they are different.

Solution 1

Every SQL database uses its own implementation of the language that varies slightly. While basic queries are almost universal, there are notable nuances between MySQL, PostgreSQL, Microsoft SQL Server, Oracle Database, etc.

What's particularly notable about SQLite is that unlike all the others mentioned above, this database software doesn't come with a daemon that queries are passed through. This means that if multiple processes are using the database at once, they will be directly altering the data through the SQLite library and making the read / write data calls to the OS themselves. It also means that the locking mechanisms don't deal with contention very well.

This isn't a problem for most applications that where one would think of using SQLite -- the small overhead benefits and easy data retrieval are worth it. However, if you'll be accessing your database with more than one process or don't consider mapping all your requests through one thread, it could be slightly troublesome.

Solution 2

Sqlite is very light version of SQL supporting many features of SQL. Basically is been developed for small devices like mobile phones, tablets etc.

SQLite is a third party ,open-sourced and in-process database engine. SQL Server Compact is from Microsoft, and is a stripped-down version of SQL Server.They are two competing database engines.

SQL is query language. Sqlite is embeddable relational database management system.

Edit : ( Source from following comment on my answer )

Sqlite also doesn't require a special database server or anything. It's just a direct filesystem engine that uses SQL syntax. ( By : Adam Plocher )

Techinically, SQLite is not open-source software but rather public domain. There is no license. ( By : Larry Lustig )

Solution 3

SQL is query language. Sqlite is embeddable relational database management system.

Unlike other databases (like SQL Server and MySQL) SQLite does not support stored procedures.

SQLite is file-based, unlike other databases, like SQL Server and MySQL which are server-based.

Comments

[Adam Plocher]

Sqlite also doesn't require a special database server or anything. It's just a direct filesystem engine that uses SQL syntax.

[Larry Lustig]

Techinically, SQLite is not open-source software but rather public domain. There is no license.

[Navin Israni]

SQLite can't compete with SQL Server, both are meant for different purposes and hence their comparison is invalid.

[Jeremy Parker]

SQLite is not DBMS

[carloswm85]

Wikipedia informs, "SQLite is a relational database management system contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program. SQLite generally follows PostgreSQL syntax."