What is SQLite?
SQLite is an in-process library that implements a stand-alone, serverless transactional SQL database with zero configuration. The source code for SQLite exists in the public domain and is free for private and commercial purposes.
SQLite is Atomicity, Consistency, Isolation, Durability (ACID) compliant. This embedded relational database management system is contained in a small C programming library and is an integral part of client-based applications.
SQLite uses dynamic SQL syntax and multitasking to read and write at the same time. The reads and writes are done directly on normal disk files.
A SQLite library is called dynamically, and application programs use SQLite functionality through simple function calls, which reduces latency in database access. These programs save entire databases as individual cross-platform files on host computers. This simple design is implemented by locking the entire database file during a write operation.
SQLite implements the SQL-92 standard for SQL and uses an unusual system for SQL-compatible database management systems. Types are assigned individual values, which makes columns more flexible when tied to dynamic scripting languages. Full Unicode support in SQLIte is optional.