SQLite is an Open Source RDBMD (Relational Database Management System) that is provided in the form of a library so that it can be easily embedded within other software packages. It differs from a conventional DBMS such as MySQL or PostgreSQL in several important respects:

The syntax understood by SQLite is mostly compatible with SQL92 but with some omissions. Its dynamic type system is unusual, but should have little or no effect on queries that would be valid in a statically-typed environment. A command-line client is provided in the form of the sqlite3 command.


See also

Further reading