SQLite is a relational database management system based on the SQL language but optimized for use in small environments such as mobile phones or small applications. SQLite it is self-contained, serverless, zero-configuration and transactional. It is very fast and lightweight, and the entire database is stored in a single file. SQLite is built for simplicity and speed compared to a hosted client-server relational database such as MySQL. It sacrifices sophistication for utility and complexity for size. Queries in SQLite are almost identical to other SQL calls.
Before starting we would highly recommend all user to install DB Browser for SQLite. The browser can be downloaded from their official page easily. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It will help us to see the databases being created and edited in real time.
- CONNECTING to a Database
- CREATING a Table
- INSERTING records in a TABLE
- SELECTING records from the TABLE
- UPDATING Records in the TABLE
- DELETE Operation
- Example walk trough