SQLAlchemy
SQLAlchemy is an open-source SQL toolkit and ORM library for Python. It provides a high-level API for communicating with relational databases, including schema creation and modification, an SQL expression language, and database connection management. The ORM layer abstracts away the complexities of the database, allowing developers to work with Python objects instead of raw SQL statements.
QuestDB implements a dialect for SQLAlchemy using the QuestDB Connect Python package.
Please note that the SQLAlchemy ORM and metadata operations are only partially supported.
#
Prerequisites- Python from 3.9 to 3.11
- Psycopg2
- SQLAlchemy <=1.4.47
- A QuestDB instance
#
InstallationYou can install this package using pip
:
#
Example usage#
See also- The SQLAlchemy tutorial
- The QuestDB Connect GitHub