
Security News
Meet Socket at Black Hat and DEF CON 2025 in Las Vegas
Meet Socket at Black Hat & DEF CON 2025 for 1:1s, insider security talks at Allegiant Stadium, and a private dinner with top minds in software supply chain security.
|Build Status| |docs| |pypi| |python| |license|
Quart-DB is a Quart extension that provides managed connection(s) to postgresql or sqlite database(s).
Quart-DB is used by associating it with an app and a DB (via a URL)
and then utilising the g.connection
connection,
.. code-block:: python
from quart import g, Quart, websocket from quart_db import QuartDB
app = Quart(name) db = QuartDB(app, url="postgresql://user:pass@localhost:5432/db_name")
@app.get("/int:id") async def get_count(id: int): result = await g.connection.fetch_val( "SELECT COUNT(*) FROM tbl WHERE id = :id", {"id": id}, ) return {"count": result}
@app.post("/") async def set_with_transaction(): async with g.connection.transaction(): await db.execute("UPDATE tbl SET done = :done", {"done": True}) ... return {}
@app.get("/explicit") async def explicit_usage(): async with db.connection() as connection: ...
Quart-DB is developed on GitHub <https://github.com/pgjones/quart-db>
. If you come across an issue,
or have a feature request please open an issue <https://github.com/pgjones/quart-db/issues>
. If you want to
contribute a fix or the feature-implementation please do (typo fixes
welcome), by proposing a merge request <https://github.com/pgjones/quart-db/merge_requests>
_.
Testing
The best way to test Quart-DB is with `Tox
<https://tox.readthedocs.io>`_,
.. code-block:: console
$ pip install tox
$ tox
this will check the code style and run the tests.
Help
----
The Quart-DB `documentation
<https://quart-db.readthedocs.io/en/latest/>`_ is the best places to
start, after that try searching `stack overflow
<https://stackoverflow.com/questions/tagged/quart>`_ or ask for help
`on gitter <https://gitter.im/python-quart/lobby>`_. If you still
can't find an answer please `open an issue
<https://github.com/pgjones/quart-db/issues>`_.
.. |Build Status| image:: https://github.com/pgjones/quart-db/actions/workflows/ci.yml/badge.svg
:target: https://github.com/pgjones/quart-db/commits/main
.. |docs| image:: https://readthedocs.org/projects/quart-db/badge/?version=latest&style=flat
:target: https://quart-db.readthedocs.io/en/latest/
.. |pypi| image:: https://img.shields.io/pypi/v/quart-db.svg
:target: https://pypi.python.org/pypi/Quart-DB/
.. |python| image:: https://img.shields.io/pypi/pyversions/quart-db.svg
:target: https://pypi.python.org/pypi/Quart-DB/
.. |license| image:: https://img.shields.io/badge/license-MIT-blue.svg
:target: https://github.com/pgjones/quart-db/blob/main/LICENSE
FAQs
Quart-DB is a Quart extension that provides managed connection(s) to database(s).
We found that quart-db demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Meet Socket at Black Hat & DEF CON 2025 for 1:1s, insider security talks at Allegiant Stadium, and a private dinner with top minds in software supply chain security.
Security News
CAI is a new open source AI framework that automates penetration testing tasks like scanning and exploitation up to 3,600× faster than humans.
Security News
Deno 2.4 brings back bundling, improves dependency updates and telemetry, and makes the runtime more practical for real-world JavaScript projects.