Release: 2.0.36
current release
| Release Date: October 15, 2024
SQLAlchemy 2.0 Documentation
SQLAlchemy Core
- SQL Statements and Expressions API
- Schema Definition Language
- SQL Datatype Objects
- Engine and Connection Use¶
- Core API Basics
Project Versions
- Previous: Base Type API
- Next: Engine Configuration
- Up: Home
- On this page:
Engine and Connection Use¶
- Engine Configuration
- Working with Engines and Connections
- Basic Usage
- Using Transactions
- Setting Transaction Isolation Levels including DBAPI Autocommit
- Using Server Side Cursors (a.k.a. stream results)
- Translation of Schema Names
- SQL Compilation Caching
- “Insert Many Values” Behavior for INSERT statements
- Engine Disposal
- Working with Driver SQL and Raw DBAPI Connections
- Registering New Dialects
- 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
- Using FIFO vs. LIFO
- Using Connection Pools with Multiprocessing or os.fork()
- Using a pool instance directly
- API Documentation - Available Pool Implementations
- Core Events
Previous:
Base Type API
Next:
Engine Configuration
© Copyright 2007-2024, the SQLAlchemy authors and contributors.
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 7.2.6. Documentation last generated: Fri 08 Nov 2024 08:41:19 AM EST