Engine and Connection Use

• Engine Configuration
  • Database URLs
    • Creating URLs Programmatically
  • Engine Creation API
    • engine_from_config()
    • make_url()
  • Pooling
  • • Special Keyword Arguments Passed to dbapi.connect()
    • Modifying the DBAPI connection after connect, or running commands after connect
  • Configuring Logging
    • Setting the Logging Name
    • Hiding Parameters
• • Basic Usage
  • • Commit As You Go
    • Connect and Begin Once from the Engine
  • Setting Transaction Isolation Levels including DBAPI Autocommit
    • Setting Isolation Level or DBAPI Autocommit for an Engine
    • Understanding the DBAPI-Level Autocommit Isolation Level
  • • Streaming with a fixed buffer via yield_per
  • Translation of Schema Names
  • • Estimating Cache Performance Using Logging
    • Disabling or using an alternate dictionary to cache some (or all) statements
    • Using Lambdas to add significant speed gains to statement production
  • • Enabling/Disabling the feature
    • Logging and Events
  • Engine Disposal
  • • Invoking SQL strings directly to the driver
    • Calling Stored Procedures and User Defined Functions
  • Registering New Dialects
  • Connection / Engine API
    • CreateEnginePlugin
    • ExceptionContext
    • RootTransaction
    • TwoPhaseTransaction
  • • ChunkedIteratorResult
    • FilterResult
    • IteratorResult
    • Result
    • MappingResult
    • RowMapping
• Core Events
  • • Events.dispatch
  • • PoolEvents
  • SQL Execution and Connection Events
    • DialectEvents
  • • DDLEvents