Summary: This tutorial provides a brief overview of SQLite and its unique features that make it the most widely deployed SQL database engine.
What is SQLite
SQLite is a software library that provides a relational database management system. The “lite” in SQLite means lightweight nature regarding setup, database administration, and required resources.
SQLite has the following notable features:
- Self-contained
- Serverless
- Zero-configuration
- Transactional
Serverless
An RDBMS such as MySQL or PostgreSQL typically requires a separate server process to run. The applications that need to access the database server use TCP/IP protocol to send and receive requests. This setup is known as client/server architecture.
The following diagram illustrates the client/server architecture of an RDBMS: