How do I use SQLite with Python?

How do I use SQLite with Python?

You can use the sqlite3 module in Python to interact with SQLite databases. Would you like a code example?

Yes, please provide a simple example.

Sure! Here's a basic example:

import sqlite3

# Connect to a database (or create it if it doesn't exist)
conn = sqlite3.connect('example.db')

# Create a cursor object
cursor = conn.cursor()

# Create a table
cursor.execute('''CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)''')

# Insert a user
cursor.execute('''INSERT INTO users (name) VALUES ('Alice')''')

# Commit the changes and close the connection
conn.commit()
conn.close()

What if I want to retrieve data from the database?

You can use a SELECT statement to retrieve data. Here's how:

# Connect to the database
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# Retrieve data
cursor.execute('''SELECT * FROM users''')
rows = cursor.fetchall()

for row in rows:
    print(row)

conn.close()