sqlalchemy-upsert-kit 0.1.1

Welcome to sqlalchemy_upsert_kit Documentation

sqlalchemy_upsert_kit provides high-performance bulk upsert operations for SQLAlchemy applications using temporary table staging. It offers three optimized strategies: insert_or_ignore for conflict-free insertion, insert_or_replace for complete record replacement, and insert_or_merge for selective column updates while preserving existing data. Each strategy leverages efficient SQL JOIN operations and temporary tables to achieve ~20x performance improvements over traditional row-by-row upserts, making it ideal for ETL processes, data synchronization, and bulk data operations where speed and reliability are critical.

$ pip install sqlalchemy-upsert-kit

$ pip install --upgrade sqlalchemy-upsert-kit