note

If you get 'No module named 'psycopg'' in SQLAlchemy 2.1, add +psycopg2 to the URL—3 ways to fix it, and 9 SQL statements that will fail in psycopg 3 (measured in Docker)

I installed SQLAlchemy 2.1.1 and psycopg2-binary in a verification environment (Python 3.13 inside Docker). In that environment, passing a URL starting with postgresql:// to create_engine () caused it ...
GitHub

Python RESTful API

├── config/ # Application configuration & environment settings ├── controller/ # API routes & request handling ├── service/ # Business logic layer (payload in, payload out) ├── repository/ # Database ...
GitHub

FastAPI CRUD Operations

FastAPI-CRUD-Operations/ ├── main.py # FastAPI app, Pydantic schemas, and CRUD routes ├── models.py # SQLAlchemy ORM model for Todo ├── database.py # DB engine, session, and Base setup ├── index.py # ...
blog.csdn

【FDE系列】阶段2：Day 35：Python + SQL — 工单接入 MySQL + 本周收官

本内容遵循CC 4.0 BY-SA版权协议 见文档结尾附录。 阶段2·Day 35：Python + SQL — 工单接入 MySQL + 本周收官 FDE 学习系列教程 · 第二阶段 · 第 3 周 · Day 5 预计时长：3 小时 | 难度：★★★★☆ ...
note

2026年9月29日 19:20

검증용 환경 (Docker 내 Python 3.13)에 SQLAlchemy 2.1.1과 psycopg2-binary를 설치했습니다. 해당 환경에서 postgresql://로 시작하는 URL을 create_engine ()에 전달하자 'ModuleNotFoundError: No module named 'psycopg'' 오류가 발생하며 중단되었습니다.
blog.csdn

SQLAlchemy三件套：Engine、Session、Model （一）

本内容遵循CC 4.0 BY-SA版权协议 ORM层：将数据库表映射为Python类（如User类对应users表），通过类实例的创建/修改/删除实现数据 ...