Skip to main content

Flask-SQLAlchemy is an extension for Flask that adds support for SQLAlchemy to your application. It aims to simplify using SQLAlchemy with Flask by providing useful defaults and extra helpers that make it easier to accomplish common tasks.

Installing

Install and update using pip:

$ pip install -U Flask-SQLAlchemy

A Simple Example

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///example.sqlite"
db = SQLAlchemy(app)


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


db.session.add(User(name="Flask", email="example@example.com"))
db.session.commit()

users = User.query.all()

Release files for Flask-SQLAlchemy 2.5.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for Flask-SQLAlchemy 2.5.1
File Size Uploaded
Flask-SQLAlchemy-2.5.1.tar.gz 132.8 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for Flask-SQLAlchemy 2.5.1
File Interpreter ABI Platform
Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl Python 3, Python 2 none any Details

Total release size: 150.5 kB

Release files / Flask-SQLAlchemy-2.5.1.tar.gz

Download URL Flask-SQLAlchemy-2.5.1.tar.gz
Size 132.8 kB
Tags Source
SHA-256 checksum
How to use checksums
2bda44b43e7cacb15d4e05ff3cc1f8bc97936cc464623424102bfc2c35e95912
BLAKE2b-256 checksum
How to use checksums
35f039dd2d8e7e5223f78a5206d7020dc0e16718a964acfb3564d89e9798ab9b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.1 importlib_metadata/3.7.3 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.9.1

Release files / Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl

Download URL Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl
Size 17.7 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
f12c3d4cc5cc7fdcc148b9527ea05671718c3ea45d50c7e732cceb33f574b390
BLAKE2b-256 checksum
How to use checksums
262c9088b6bd95bca539230bbe9ad446737ed391aab9a83aff403e18dded3e75
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.1 importlib_metadata/3.7.3 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.9.1

Release history Release notifications | RSS feed

3.1.1

2 release files

3.1.0

2 release files

3.0.5

2 release files

3.0.4

2 release files

3.0.3

2 release files

3.0.2

2 release files

3.0.1

2 release files

3.0.0

2 release files

This release

2.5.1 This release

2 release files

2.5.0

2 release files

2.4.4

2 release files

2.4.3

2 release files

2.4.2

2 release files

2.4.1

2 release files

2.4.0

2 release files

2.3.2

2 release files

2.3.1

2 release files

2.3.0

2 release files

2.2

2 release files

2.1

1 release file

2.0

1 release file

1.0

1 release file

0.16

1 release file

0.15

1 release file

0.14

1 release file

0.13

1 release file

0.12

1 release file

0.11

1 release file

0.10

1 release file

0.9.1

1 release file

0.9

1 release file

0.6

1 release file

0.5

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page