How can I connect my Flask app to a database?

How can I connect my Flask app to a database?

You can connect your Flask app to a database using SQLAlchemy or Flask-SQLAlchemy. Do you have a specific database in mind?

I'm thinking of using PostgreSQL. What do I need to do?

First, install the necessary packages using pip: pip install Flask-SQLAlchemy psycopg2. Then, configure your app to connect to the PostgreSQL database.

Can you show me an example of the configuration?

Sure! Here’s a basic example:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://username:password@localhost/dbname'
db = SQLAlchemy(app)

What if I want to use SQLite instead?

For SQLite, you can simply change the URI to sqlite:///yourdatabase.db. It’s that easy!