What is SQLite ?
SQLite is an RDBMS (Relational Database Management System) and is a part of C Library, which is widely used in programming. A database is a place where all information is usually stored in rows and columns. And can be updated, retrieved, deleted and added.
If you consider other databases like MySQL or other DB, then this is not client-server based but embedded into the program. SQLite follows ACID property (Atomicity, Concurrency, Integrity and Durability). The syntaxes are similar to PostgreSQL Command Line Interface (CLI).
SQLite is good for Web Browser where embedded database software for local storage. This database is not only related to C programming but also other programming languages. Hence, it’s library has binding to various language.
Why to use SQLite ?
Self – Contained
The database does not require it’s a dependency from any other database, it’s isolated and hence, independent from the other databases. It is totally stand-alone and can run on any Operating System.
The database is serverless and hence it does not require to load request and response from the server’s database. Thus it’s much faster. In other words, if a process accesses the database for read or write operations from the database files on disk, then it does not require the intermediate server to do the process.
But this also comes with a disadvantage. Being serverless, it can consist of bugs from client-side applications or could corrupt memory if not handled properly. But the main advantage you can get from this is that you don’t need separate server process to set up, manage and configure all the operations.
Every transaction or query executed is somewhat unique and isolated from the other. Hence the concurrent query can be executed easily on the SQLite database. SQLite consist of serializable transactions that follow the ACID property and hence you can process the request without any system crash or power loss.
The SQLite consist of a distinctive feature of using a single ordinary disk file that can be found in the system. If reading the disk file is possible then numerous other operation is also possible. And this file can easily be shared or copied to other locations.
The SQLite does not require installation and can be used directly. It does not require the help of the server to configure the database operations like start, stop, etc. And also it can work without the help of an administrator to create a new database instance of to grant or revoke a permission.
SQLite simply works, there is no need for troubleshooting or analyze system power failure or system crash. While in other SQL, some might require complex installation procedures and permission from the system.
If you want to know more information and installation about SQLite, you can go through the Official SQLite link.