How can I integrate a database into my Flask app?

How can I integrate a database into my Flask app?

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

I'm thinking of using PostgreSQL. What are the steps?

First, install the necessary packages using pip. Then, configure your database URI in your Flask app's config. Finally, define your models and create the database.

Can you show me an example of a model?

Sure! Here's a simple example:

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)

This defines a User model with an ID and a username.

How do I create the database tables?

You can create the tables by running db.create_all() in your Flask shell or in your app's startup code.