There are many reasons for choosing SQLite, including
Performance SQLite performs database operations efficiently and is faster than other free databases such as MySQL and PostgreSQL.
Size SQLite has a small memory footprint and only a single library is required to access databases, making it ideal for embedded database applications.
Portability SQLite runs on many platforms and its databases can be ported easily with no client/server setup or ongoing administration required.
Stability SQLite is ACID-compliant, meeting all four criteriaAtomicity, Consistency, Isolation, and Durability.
SQL support SQLite implements a large subset of the ANSI-92 SQL standard, including views, subqueries, and triggers.
Interfaces SQLite has language APIs for C/C++, PHP, Perl, Python, Tcl, and many more beyond those covered in this book.
Cost SQLite is in the public domain and therefore is free to use for any purpose without cost and can be freely redistributed.