What is "sqlite"
Sqlite is a software library that implements a engine SQL database self-contained, serverless, unshaped and transactional. Sqlite is the engine SQL database most widely deployed in the world. The source code for Sqlite is public domain.
Sqlite is a relational database management system contained in a small (~ 350 KB) C library. In contrast to other database management systems, Sqlite is not a separate process, which is accessed from the client application, but an integral part of it.
Sqlite is ACID criteria and implements most of the SQL standard, using SQL syntax dynamically and without type stiffness that does not guarantee domain integrity.
Design
Unlike client-server database management systems, the engine Sqlite does not have autonomous processes with which the application program communicates. Instead, the Sqlite library is linked to the process and becomes an integral part of the application program.
The application program uses Sqlite functionality through simple function calls, which reduce latency in database access: function calls within a single process are more efficient than inter-process communication. Sqlite stores the entire database as a single cross-platform file on one machine host.
Sqlite is not a client library used to connect to a large database server, but rather the server itself. The Sqlite library reads and writes directly to and from the database file on disk.