A Relational Database Management System contained in the C library, SQLite is not a client–server database engine. Rather, it is embedded into the end program and reads and writes directly to the files. This makes it highly popular and preferred choice for mobile app development, allowing both static and dynamic linkages with applications. It supports accessing storage file by calling a simple function.
Apple, Android, Facebook, Skype and Airbus are some of the popular names who are using SQLite database backend.
Unlike other SQL database engines which need a separate server process, SQLite is server-less. You can install, setup, manage and troubleshoot operations without any server process.
As the name suggest, it is a single disk file of less than 500KB. SQLite can easily be located anywhere in the directory structure.
It supports manifest typing. This means you can store any value of any data type into any column, no matter what the declared type of that column is.
No set-up is needed.
Atomic, consistent, isolated, durable (ACID) compliant, even after power failures and system crashes.