Introduction to SQLite

SQLite is a self-contained, file-based database system that allows you to store and manage data in a structured way. It's a great choice for small to medium-sized projects, and is widely used in many applications.

Installing SQLite

To get started with SQLite, you'll need to install it on your system. You can download the latest version from the official SQLite website.

Interacting with SQLite using Python

Python has a built-in module called sqlite3 that allows you to interact with SQLite databases. Here's an example of how to create a new database and add a table:

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)')

cursor.execute('INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')')

cursor.execute('INSERT INTO users (name, email) VALUES ('Jane Doe', 'jane@example.com')')

conn.commit()
conn.close()

Retrieving Data from SQLite

To retrieve data from your SQLite database, you can use the SELECT statement. Here's an example:

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('SELECT * FROM users')

rows = cursor.fetchall()
for row in rows:
    print(row)

conn.close()

Updating and Deleting Data

You can also update and delete data in your SQLite database using the UPDATE and DELETE statements. Here's an example:

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('UPDATE users SET email = 'john2@example.com' WHERE name = 'John Doe'')

cursor.execute('DELETE FROM users WHERE name = 'Jane Doe'')

conn.commit()
conn.close()
``