Here we will learn sqlite introduction, what is sqlite, why we need to use sqlite, features of sqlite, advantages and disadvantages of sqlite with examples.
SQL (Structured Query Language) is a special programming language that is designed for handling and managing data held in a Relation database management system (RDBMS).
As the name suggest, SQLite is a lightest version of SQL. It does not require any Server, No configuration.
In the simplest terms, SQLite is a public-domain software package that provides a relational database management system, or RDBMS.
The “Lite” in SQLite does not refer to its capabilities. Rather, SQLite is lightweight when it comes to setup complexity, administrative overhead, and resource usage.
SQLite is an open source embedded relational database management system or RDBMS contained in a C programming library. Relational database systems are used to store data in large tables.
In contrast to other popular RDBMS products like Oracle Database, IBM’s DB2, and Microsoft’s SQL Server, SQLite does not require any administrative overhead or any setup complexity.
As the other databases are working as a standalone process, SQLite is a not working as a standalone process. You have to link it with your application statically or dynamically.
SQLite uses dynamically and weakly typed SQL for column. It means you can store any value in any column, regardless of the data type. SQLite implements most of the SQL92 standard.
Following are the features of SQLite databases.
Server less: SQLite does not require a separate server process or system to operate. The SQLite library accesses its storage files directly.
Zero Configuration: No server means no setup. Creating a SQLite database instance is as easy as opening a file.
Cross-Platform: A complete SQLite database is stored in a single cross-platform disk file, requiring no administration.
Self-Contained: A single library contains the entire database system, which integrates directly into a host application.
Transactional: SQLite transactions are fully ACID-compliant means all queries are Atomic, Consistent, Isolated, and Durable.
Light-weight: As the name suggests “Lite”, SQLite is very small and light weight.
Familiar language: Familiar query language for database developers and admins.
Highly Reliable: The SQLite development team takes code testing and verification very seriously.
Following are the drawbacks of SQLite database.
These are the features, advantages and disadvantages of using SQLite in our applications.