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.
Install
sqlalchemy_upsert_kit is released on PyPI, so all you need is to:
$ pip install sqlalchemy-upsert-kitTo upgrade to latest version:
$ pip install --upgrade sqlalchemy-upsert-kit1 maintainer
Metadata
1 maintainer
Release files for sqlalchemy-upsert-kit 0.1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy_upsert_kit-0.1.1.tar.gz | 17.7 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_upsert_kit-0.1.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 41.9 kB
Release files / sqlalchemy_upsert_kit-0.1.1.tar.gz
| Download URL | sqlalchemy_upsert_kit-0.1.1.tar.gz |
|---|---|
| Size | 17.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
cedc59a0b8058831211c2f3528cb8cf87510009b086c3a2e9d221b152f7514d3
|
|
BLAKE2b-256 checksum How to use checksums |
b437faf61bb9015838eabeecd69e8558c124265e38000b1608abd1937e94ee4b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.11.8
|
Release files / sqlalchemy_upsert_kit-0.1.1-py3-none-any.whl
| Download URL | sqlalchemy_upsert_kit-0.1.1-py3-none-any.whl |
|---|---|
| Size | 24.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
91970339ffb455d531fc737867cfa8d3dfe050ac7c325c912fb5812a76cf77fd
|
|
BLAKE2b-256 checksum How to use checksums |
df130fb3ea06e37608a764b4cf73c312ef5f0ea94e7016a5b72c436e14335efb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.11.8
|
