Articles tagged "SQLAlchemy"

SQLAlchemy
2 min read

Using python SQLAlchemy with SQLlite3 tutorial

Learn here how to use SQLIte3 with SQLAlchemy step by step. First, we are going to define some models and then we will see how to connect and make some queries. We are going to learn about the Unit of Work pattern, which is a very important concept on sqlalchemy.

Python sqlalchemy postgresql performance database
15 min readIntermediate

SQLAlchemy Bulk Insert: Fastest Methods Benchmarked — Core insert(), ON CONFLICT, COPY (240x)

Benchmark SQLAlchemy bulk insert: execute(insert()), bulk_save_objects, ON CONFLICT upserts, PostgreSQL COPY via psycopg2 — 240x faster than add_all().