Download as PDF, PPTX
Uploaded byMindfire Solutions
Getting Started with SQLite
This document summarizes a presentation on getting started with SQLite. The presentation covers what SQLite is, who uses it, where it can be used, its key features, constraints and functions. It concludes with a live demo of installing SQLite, creating databases and tables, and performing basic operations using a database manager tool.
Getting Started with SQLite
- 1. Getting started withSQLite Presenter: Harsh Wardhan, Mindfire Solutions
- 2. Presenter: Harsh Wardhan,Mindfire Solutions Agenda - What is SQLite? - Who is using SQLite? - Where to use SQLite? - What makes SQLite different? - Understanding SQLite constraints. - Understanding SQLite Functions. - Live demo.
- 3. Presenter: Harsh Wardhan,Mindfire Solutions What is SQLite? - Created by D. Richard Hipp. - A self contained, serverless, zero- configuration, transactional database engine. - Small footprint around 0.5 MB. - Entire database in a single file. - ACID transactions. - In public domain.
- 4. Presenter: Harsh Wardhan,Mindfire Solutions Who is using SQLite?
- 5. Presenter: Harsh Wardhan,Mindfire Solutions Where to use SQLite? - Stand alone applications. - Local database cache. - Session database. - Embedded devices. - Internal or temporary databases. - Application file format. - Don't use in client/server applications, high volume websites, high concurrency requirements.
- 6. Presenter: Harsh Wardhan,Mindfire Solutions What makes SQLite different? - Zero-configuration and serverless. - Single file database. - Stable cross platform database files. - Manifest typing. - Variable length record.
- 7. Presenter: Harsh Wardhan,Mindfire Solutions Features not supported - Right and full outer join. - Complete alter table support. - Complete trigger support. - Writing to views. - Grant and Revoke.
- 8. Presenter: Harsh Wardhan,Mindfire Solutions SQLite Constraints - Not null. - Unique. - Primary key. - Foreign key. - Check. - Default.
- 9. Presenter: Harsh Wardhan,Mindfire Solutions SQLite Functions - Core functions. - Aggregate functions. - Date & Time functions.
- 10. Presenter: Harsh Wardhan,Mindfire Solutions Time for a Live Demo. - Install SQLite. http://www.sqlite.org/download.html - Create SQLite database and tables. - Basic operations using SQLite. - Let's get a database manager. http://sqlitestudio.pl/?act=download
- 11. Presenter: Harsh Wardhan,Mindfire Solutions Question and Answer
- 12. Presenter: Harsh Wardhan,Mindfire Solutions Thank you