ConceptIntermediate
What are the main components of SQLAlchemy Core?
SQLAlchemy Core's main components, according to the source, include an Engine object that implements the DB-API standard, URLs that express the SQL server type and driver and the specific database collection, client-server connection pools, transactions, SQL dialect differences, direct SQL text queries, and queries in the SQLAlchemy Expression Language.
Key points
- Core is the base layer of SQLAlchemy and does not have to be used with the ORM.
- Its Engine object implements the Python DB-API standard.
- Core uses URLs to specify the SQL server type, driver, and particular database collection.
- It provides client-server connection pools, transactions (COMMIT and ROLLBACK), and handling of SQL dialect differences.
- It supports direct SQL text queries as well as the SQLAlchemy Expression Language for expressing queries in Python.
Related questions
FastAPI: Modern Python Web Development
Bill Lubanovic;
First Edition · O'Reilly Media, Inc.