How can I use SQL with Python?

How can I use SQL with Python?

You can use libraries like SQLite, SQLAlchemy, or pandas to interact with SQL databases in Python.

Can you show me an example using SQLite?

Sure! First, you need to import sqlite3. Then, you can connect to a database and execute queries like this:

import sqlite3

# Connect to the database
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
conn.commit()

# Query the users
cursor.execute('''SELECT * FROM users''')
print(cursor.fetchall())

# Close the connection
conn.close()

What if I want to use a different database like PostgreSQL?

For PostgreSQL, you can use the psycopg2 library. The connection and query execution are similar, but you'll need to install the library first.