Engine and Connection Use

• Engine Configuration
  • Supported Databases
  • Database URLs
    • Escaping Special Characters such as @ signs in Passwords
    • Creating URLs Programmatically
    • Backend-Specific URLs
  • Engine Creation API
    • create_engine()
    • engine_from_config()
    • create_mock_engine()
    • make_url()
    • create_pool_from_url()
    • URL
  • 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
    • Commit As You Go
    • Begin Once
    • Connect and Begin Once from the Engine
    • Mixing Styles
  • Setting Transaction Isolation Levels including DBAPI Autocommit
    • Setting Isolation Level or DBAPI Autocommit for a Connection
    • Setting Isolation Level or DBAPI Autocommit for an Engine
    • Maintaining Multiple Isolation Levels for a Single Engine
    • Understanding the DBAPI-Level Autocommit Isolation Level
  • Using Server Side Cursors (a.k.a. stream results)
    • Streaming with a fixed buffer via yield_per
    • Streaming with a dynamically growing buffer using stream_results
  • 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
    • Caching for Third Party Dialects
    • Using Lambdas to add significant speed gains to statement production
  • “Insert Many Values” Behavior for INSERT statements
    • Current Support
    • Disabling the feature
    • Batched Mode Operation
    • Correlating RETURNING rows to parameter sets
    • Non-Batched Mode Operation
    • Statement Execution Model
    • Controlling the Batch Size
    • Logging and Events
    • Upsert Support
  • 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 and User Defined Functions
    • Multiple Result Sets
  • Registering New Dialects
    • Registering Dialects In-Process
  • Connection / Engine API
    • Connection
    • CreateEnginePlugin
    • Engine
    • ExceptionContext
    • NestedTransaction
    • RootTransaction
    • Transaction
    • TwoPhaseTransaction
  • Result Set API
    • ChunkedIteratorResult
    • CursorResult
    • FilterResult
    • FrozenResult
    • IteratorResult
    • MergedResult
    • Result
    • ScalarResult
    • MappingResult
    • Row
    • RowMapping
    • TupleResult
• Connection Pooling
  • Connection Pool Configuration
  • Switching Pool Implementations
  • Using a Custom Connection Function
  • Constructing a Pool
  • Reset On Return
    • Disabling Reset on Return for non-transactional connections
    • Custom Reset-on-Return Schemes
    • Logging reset-on-return events
  • Pool Events
  • Dealing with Disconnects
    • Disconnect Handling - Pessimistic
    • Disconnect Handling - Optimistic
    • More on Invalidation
    • Supporting new database error codes for disconnect scenarios
  • Using FIFO vs. LIFO
  • Using Connection Pools with Multiprocessing or os.fork()
  • Using a pool instance directly
  • API Documentation - Available Pool Implementations
    • Pool
    • QueuePool
    • SingletonThreadPool
    • AssertionPool
    • NullPool
    • StaticPool
    • ManagesConnection
    • ConnectionPoolEntry
    • PoolProxiedConnection
    • _ConnectionFairy
    • _ConnectionRecord
• Core Events
  • Events
    • Events.dispatch
  • Connection Pool Events
    • PoolEvents
    • PoolResetState
  • SQL Execution and Connection Events
    • ConnectionEvents
    • DialectEvents
  • Schema Events
    • DDLEvents
    • SchemaEventTarget