Engine and Connection Use

• Engine Configuration
  • Database Urls
    • MySQL
    • Microsoft SQL Server
    • Others
  • 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
• Working with Engines and Connections
  • Using Transactions
  • Library Level (e.g. emulated) Autocommit
  • Using Server Side Cursors (a.k.a. stream results)
  • Translation of Schema Names
  • • Configuration
    • How much memory does the cache use?
    • Using Lambdas to add significant speed gains to statement production
  • Working with Driver SQL and Raw DBAPI Connections
    • Working with the DBAPI cursor directly
  • Registering New Dialects
  • Connection / Engine API
• Connection Pooling
  • Switching Pool Implementations
  • Constructing a Pool
  • Pool Events
  • • Disconnect Handling - Pessimistic
    • More on Invalidation
  • Using Connection Pools with Multiprocessing or os.fork()
• Core Events
  • Schema Events