flask-sqlalchemy

Adds SQLAlchemy support to Flask

https://github.com/pallets-eco/flask-sqlalchemy

Science Score: 13.0%

This score indicates how likely this project is to be science-related based on various indicators:

○
CITATION.cff file
✓
codemeta.json file
Found codemeta.json file
○
.zenodo.json file
○
DOI references
○
Academic publication links
○
Committers with academic emails
○
Institutional organization owner
○
JOSS paper metadata
○
Scientific vocabulary similarity
Low similarity (4.7%) to scientific vocabulary

Keywords

flask flask-sqlalchemy python sqlalchemy

Keywords from Contributors

asyncio unit-testing pydantic json-schema asgi distribution packaging closember parallel mesh

Last synced: 6 months ago · JSON representation

Repository

Adds SQLAlchemy support to Flask

Basic Info

Host: GitHub
Owner: pallets-eco
License: bsd-3-clause
Language: Python
Default Branch: main
Homepage: https://flask-sqlalchemy.readthedocs.io
Size: 1.55 MB

Statistics

Stars: 4,308
Watchers: 113
Forks: 900
Open Issues: 29
Releases: 22

Topics

flask flask-sqlalchemy python sqlalchemy

Created over 15 years ago · Last pushed 8 months ago

Metadata Files

Readme Changelog Contributing License

Flask-SQLAlchemy

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.

Pallets Community Ecosystem

[!IMPORTANT]\ This project is part of the Pallets Community Ecosystem. Pallets is the open source organization that maintains Flask; Pallets-Eco enables community maintenance of Flask extensions. If you are interested in helping maintain this project, please reach out on [the Pallets Discord server][discord].

[discord]: https://discord.gg/pallets

A Simple Example

```python from flask import Flask from flasksqlalchemy import SQLAlchemy from sqlalchemy.orm import DeclarativeBase, Mapped, mappedcolumn

app = Flask(name) app.config["SQLALCHEMYDATABASEURI"] = "sqlite:///example.sqlite"

class Base(DeclarativeBase): pass

db = SQLAlchemy(app, model_class=Base)

class User(db.Model): id: Mapped[int] = mappedcolumn(primarykey=True) username: Mapped[str] = mapped_column(unique=True)

with app.appcontext(): db.createall()

db.session.add(User(username="example"))
db.session.commit()

users = db.session.scalars(db.select(User))

```

Owner

Name: Pallets Ecosystem
Login: pallets-eco
Kind: organization
Email: contact@palletsprojects.com

Website: https://palletsprojects.com
Repositories: 37
Profile: https://github.com/pallets-eco

Community maintained extensions to Pallets projects.

GitHub Events

Total

Issues event: 8
Watch event: 99
Delete event: 1
Issue comment event: 31
Push event: 5
Pull request review event: 1
Pull request review comment event: 2
Pull request event: 15
Fork event: 15
Create event: 5

Last Year

Issues event: 8
Watch event: 99
Delete event: 1
Issue comment event: 31
Push event: 5
Pull request review event: 1
Pull request review comment event: 2
Pull request event: 15
Fork event: 15
Create event: 5

Committers

Last synced: 8 months ago

All Time

Total Commits: 758
Total Committers: 120
Avg Commits per committer: 6.317
Development Distribution Score (DDS): 0.694

Past Year

Commits: 14
Committers: 4
Avg Commits per committer: 3.5
Development Distribution Score (DDS): 0.286

Top Committers

Name	Email	Commits
David Lord	d**m@g**m	232
Armin Ronacher	a**r@a**m	94
dependabot[bot]	4****]	71
dependabot-preview[bot]	2****]	46
Pamela Fox	p**x@g**m	42
Phil Howell	p**l@q**k	32
pre-commit-ci[bot]	6****]	31
Randy Syring	r**y@t**s	24
Adrian Moennich	a**n@p**t	7
Hugo	h****k	7
Grey Li	w**i@g**m	7
Pedro Algarvio	p**o@a**e	7
Zoupers	qy@z****n	6
Ron DuPlain	r**n@w**m	6
Daniel Neuhäuser	d**h@g**m	5
Joe Coburn	C****e	4
Laura Beaufort	3****t	4
Thadeus Burgess	t**s@m**)	3
Sven-Hendrik Haase	sh@l****m	3
Aleksei Maslennikov	m**m@g**m	3
Alex Morega	a**x@g**o	3
Frank Yu	w**y@g**m	3
Michael Elsdoerfer	m**l@e**m	3
Priit Laes	p**s@p**g	3
jqxl0205	j**5@g**m	3
justanr	a**r@g**m	3
Alex Gaynor	a**r@g**m	2
Alistair Lynn	a**n@g**m	2
Christopher Grebs	cg@w****g	2
Florent Xicluna	f**a@g**m	2
and 90 more...

Committer Domains (Top 20 + Academic)

live.nl: 1 nickwhyte.com: 1 davidbaumgold.com: 1 spyoung.com: 1 crosscompute.com: 1 wp.pl: 1 justinlilly.com: 1 nwsnet.de: 1 nextday.fi: 1 qq.com: 1 devktr.pl: 1 devkcr.org: 1 itrooz.fr: 1 spendship.com: 1 oracle.com: 1 nobien.net: 1 indeed.com: 1 saucelabs.com: 1 tencent.com: 1 thadeusb-desktop.(none): 1

Issues and Pull Requests

Last synced: 6 months ago

All Time

Total issues: 97
Total pull requests: 166
Average time to close issues: 2 months
Average time to close pull requests: 23 days
Total issue authors: 84
Total pull request authors: 35
Average comments per issue: 2.87
Average comments per pull request: 0.78
Merged pull requests: 115
Bot issues: 0
Bot pull requests: 78

Past Year

Issues: 8
Pull requests: 19
Average time to close issues: about 11 hours
Average time to close pull requests: about 5 hours
Issue authors: 7
Pull request authors: 9
Average comments per issue: 1.13
Average comments per pull request: 0.11
Merged pull requests: 3
Bot issues: 0
Bot pull requests: 5

View more stats

Top Authors

Issue Authors

davidism (4)
yuxiaoy1 (2)
andreasc-kuehn (2)
cainmagi (2)
mweinelt (2)
six1203 (2)
ibraheemalayan (2)
iTrooz (2)
alexjironkin (2)
mmcmNew (1)
guillermohs9 (1)
baijingetangzichen (1)
YlguYtrid (1)
AdamVerner (1)
jacquesfize (1)

Pull Request Authors

dependabot[bot] (82)
davidism (28)
pre-commit-ci[bot] (23)
pamelafox (13)
yuxiaoy1 (9)
cainmagi (5)
greyli (4)
ZongXR (3)
anon-ghub (2)
s-t-e-v-e-n-k (2)
cjwatson (2)
Sparrow0hawk (2)
Zoupers (2)
javacruft (2)
dpgaspar (2)

Top Labels

Issue Labels

docs (5) pagination (2) bug (1)

Pull Request Labels

dependencies (82) python (44) github_actions (25) docs (11)

Packages

Total packages: 4
Total downloads:
- pypi 15,603,041 last-month
Total docker downloads: 1,052,795,703

Total dependent packages: 154
(may contain duplicates)
Total dependent repositories: 18,171
(may contain duplicates)
Total versions: 41
Total maintainers: 4

pypi.org: flask-sqlalchemy

Add SQLAlchemy support to your Flask application.

Documentation: https://flask-sqlalchemy.palletsprojects.com
License: BSD License
Latest release: 3.1.1
published over 2 years ago

Versions: 35
Dependent Packages: 153
Dependent Repositories: 18,171
Downloads: 15,603,010 Last month
Docker Downloads: 1,052,795,703

Rankings

Dependent repos count: 0.1%

Downloads: 0.1%

Dependent packages count: 0.1%

Docker downloads count: 0.3%

Average: 0.5%

Stargazers count: 1.1%

Forks count: 1.3%

Maintainers (1)

Pallets Community Ecosystem

Last synced: 6 months ago

pypi.org: flask-sqlalchemy-custom

Add SQLAlchemy support to your Flask application.

Documentation: https://flask-sqlalchemy-custom.readthedocs.io/
License: BSD-3-Clause
Latest release: 3.0.3
published almost 3 years ago

Versions: 1
Dependent Packages: 0
Dependent Repositories: 0

Rankings

Stargazers count: 1.1%

Forks count: 1.3%

Dependent packages count: 7.2%

Average: 11.1%

Dependent repos count: 34.8%

Maintainers (1)

apploi

Last synced: about 1 year ago

spack.io: py-flask-sqlalchemy

Add SQLAlchemy support to your Flask application.

Homepage: https://github.com/pallets-eco/flask-sqlalchemy
License: []
Latest release: 3.0.2
published about 3 years ago

Versions: 2
Dependent Packages: 1
Dependent Repositories: 0

Rankings

Dependent repos count: 0.0%

Stargazers count: 2.6%

Forks count: 3.0%

Average: 15.7%

Dependent packages count: 57.3%

Maintainers (1)

charmoniumq

Last synced: about 1 year ago

pypi.org: flask-sqlalchemy-compat-backend-py37

Flask SQLAlchemy backend supporting the Python 3.7 version of Flask SQLAlchemy compat.

Documentation: https://flask-sqlalchemy.palletsprojects.com
License: Copyright 2010 Pallets Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
Latest release: 3.1.0.dev3
published about 1 year ago

Versions: 3
Dependent Packages: 0
Dependent Repositories: 0
Downloads: 31 Last month

Rankings

Dependent packages count: 9.9%

Average: 32.8%

Dependent repos count: 55.8%

Maintainers (1)

cainmagi

Last synced: 6 months ago

Dependencies

.github/workflows/lock.yaml actions

dessant/lock-threads v4 composite

.github/workflows/tests.yaml actions

actions/cache v3 composite
actions/checkout v3 composite
actions/setup-python v4 composite

.github/workflows/publish.yaml actions

actions/cache 627f0f41f6904a5b1efbaed9f96d9eb58e92e920 composite
actions/checkout ac593985615ec2ede58e132d2e21d2b1cbd6127c composite
actions/download-artifact 9bc31d5ccc31df68ecc42ccf4149144866c47d8a composite
actions/setup-python d27e3f3d7c64b4bbf8e4abfb9b63b83e846e0435 composite
actions/upload-artifact 0b7f8abb1508181956e8e162db84b466c27e18ce composite
pypa/gh-action-pypi-publish c7f29f7adef1a245bd91520e94867e5c6eedddcc composite

pyproject.toml pypi

Flask >=2.2
SQLAlchemy >=1.4.18

requirements/dev.in pypi

coverage * development
pip-compile-multi * development
pre-commit * development
pytest-cov * development
tox * development

requirements/dev.txt pypi

build ==0.10.0 development
cachetools ==5.3.1 development
cfgv ==3.3.1 development
chardet ==5.1.0 development
click ==8.1.3 development
colorama ==0.4.6 development
coverage ==7.2.7 development
distlib ==0.3.6 development
filelock ==3.12.2 development
identify ==2.5.24 development
nodeenv ==1.8.0 development
pip-compile-multi ==2.6.3 development
pip-tools ==6.13.0 development
platformdirs ==3.8.0 development
pre-commit ==3.3.3 development
pyproject-api ==1.5.2 development
pyproject-hooks ==1.0.0 development
pytest-cov ==4.1.0 development
pyyaml ==6.0 development
toposort ==1.10 development
tox ==4.6.3 development
virtualenv ==20.23.1 development
wheel ==0.40.0 development

requirements/docs.in pypi

pallets-sphinx-themes *
sphinx *
sphinx-issues *
sphinxcontrib-log-cabinet *

requirements/docs.txt pypi

alabaster ==0.7.13
babel ==2.12.1
certifi ==2023.5.7
charset-normalizer ==3.1.0
docutils ==0.20.1
idna ==3.4
imagesize ==1.4.1
jinja2 ==3.1.2
markupsafe ==2.1.3
packaging ==23.1
pallets-sphinx-themes ==2.1.1
pygments ==2.15.1
requests ==2.31.0
snowballstemmer ==2.2.0
sphinx ==7.0.1
sphinx-issues ==3.0.1
sphinxcontrib-applehelp ==1.0.4
sphinxcontrib-devhelp ==1.0.2
sphinxcontrib-htmlhelp ==2.0.1
sphinxcontrib-jsmath ==1.0.1
sphinxcontrib-log-cabinet ==1.0.1
sphinxcontrib-qthelp ==1.0.3
sphinxcontrib-serializinghtml ==1.1.5
urllib3 ==2.0.3

requirements/mypy.in pypi

mypy *
pytest *
sqlalchemy *

requirements/mypy.txt pypi

greenlet ==2.0.2
iniconfig ==2.0.0
mypy ==1.4.1
mypy-extensions ==1.0.0
packaging ==23.1
pluggy ==1.2.0
pytest ==7.4.0
sqlalchemy ==2.0.17
typing-extensions ==4.6.3

requirements/tests-min.in pypi

flask ==2.2.5 test
sqlalchemy ==1.4.18 test
werkzeug <2.3 test

requirements/tests-min.txt pypi

click ==8.1.3 test
flask ==2.2.5 test
greenlet ==2.0.2 test
itsdangerous ==2.1.2 test
jinja2 ==3.1.2 test
markupsafe ==2.1.3 test
sqlalchemy ==1.4.18 test
werkzeug ==2.2.3 test

requirements/tests.in pypi

blinker * test
pytest * test

requirements/tests.txt pypi

blinker ==1.6.2 test
iniconfig ==2.0.0 test
packaging ==23.1 test
pluggy ==1.2.0 test
pytest ==7.4.0 test

flask-sqlalchemy

Science Score: 13.0%

Keywords

Keywords from Contributors

Repository

Basic Info

Statistics

Topics

Metadata Files

README.md

Flask-SQLAlchemy

Pallets Community Ecosystem

A Simple Example

Owner

GitHub Events

Total

Last Year

Committers

All Time

Past Year

Top Committers

Committer Domains (Top 20 + Academic)

Issues and Pull Requests

All Time

Past Year

Top Authors

Issue Authors

Pull Request Authors

Top Labels

Issue Labels

Pull Request Labels

Packages

pypi.org: flask-sqlalchemy

Rankings

Maintainers (1)

pypi.org: flask-sqlalchemy-custom

Rankings

Maintainers (1)

spack.io: py-flask-sqlalchemy

Rankings

Maintainers (1)

pypi.org: flask-sqlalchemy-compat-backend-py37

Rankings

Maintainers (1)

Dependencies