Engine and Connection Use

• Engine Configuration
  • Supported Databases
  • Database Urls
    • PostgreSQL
    • MySQL
    • Oracle
    • Microsoft SQL Server
    • SQLite
    • Others
  • Engine Creation API
  • Pooling
  • Custom DBAPI connect() arguments / on-connect routines
    • Special Keyword Arguments Passed to dbapi.connect()
    • Controlling how parameters are passed to the DBAPI connect() function
    • Modifying the DBAPI connection after connect, or running commands after connect
    • Fully Replacing the DBAPI connect() function
  • Configuring Logging
    • More on the Echo Flag
    • Setting the Logging Name
    • Setting Per-Connection / Sub-Engine Tokens
    • Hiding Parameters
• Working with Engines and Connections
  • Basic Usage
  • Using Transactions
    • Nesting of Transaction Blocks
  • Library Level (e.g. emulated) Autocommit
  • Setting Transaction Isolation Levels including DBAPI Autocommit
  • Using Server Side Cursors (a.k.a. stream results)
  • Connectionless Execution, Implicit Execution
  • Translation of Schema Names
  • SQL Compilation Caching
    • Configuration
    • Estimating Cache Performance Using Logging
    • How much memory does the cache use?
    • Disabling or using an alternate dictionary to cache some (or all) statements
    • Using Lambdas to add significant speed gains to statement production
  • Engine Disposal
  • Working with Driver SQL and Raw DBAPI Connections
    • Invoking SQL strings directly to the driver
    • Working with the DBAPI cursor directly
    • Calling Stored Procedures
    • Multiple Result Sets
  • Registering New Dialects
    • Registering Dialects In-Process
  • Connection / Engine API
  • Result Set API
• Connection Pooling
  • Connection Pool Configuration
  • Switching Pool Implementations
  • Using a Custom Connection Function
  • Constructing a Pool
  • Reset On Return
  • Pool Events
  • Dealing with Disconnects
    • Disconnect Handling - Pessimistic
    • Disconnect Handling - Optimistic
    • More on Invalidation
  • Using FIFO vs. LIFO
  • Using Connection Pools with Multiprocessing or os.fork()
  • API Documentation - Available Pool Implementations
• Core Events
  • Connection Pool Events
  • SQL Execution and Connection Events
  • Schema Events