This Asphalt framework component provides connectivity to relational databases.

It is a wrapper for the SQLAlchemy library.

Table of contents

• Configuration
  • Setting session options
  • Multiple databases
• Using engines and sessions
  • Transactions
  • Working with core queries
  • Working with the Object Relational Mapper (ORM)
  • Loading data at application startup
• Using SQLAlchemy events with Asphalt
• Testing with asphalt-sqlalchemy
  • Setting up the SQLAlchemy component and the database connection
• Tips and tricks
  • How to automatically print emitted SQL
  • Handling schema migrations
• Version history

• API reference