GitHub

Local Data Workflow: Postgres (Docker) + SQLAlchemy + Pandas + VS Code

. ├── docker-compose.yml # Configuração do container PostgreSQL ├── setup_banco.py # Script Python para criação da tabela e carga inicial ├── analise_vendas.py # Script de extração SQL, agregação e ...
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)

Change the URL to postgresql+psycopg2:// or pin SQLAlchemy to before 2.1 to get it into a working state first (Chapter 2). If moving to psycopg 3, find the 9 syntax patterns from Chapter 3 in your ...
GitHub

FastAPI + PostgreSQL + SQLAlchemy + PGAdmin Docker Template

The RESTful API created using FastAPI, SQLAchemy, and PostgreSQL. This project contains a sample homepage, a pre-configured FastAPI app, and a sample setup of SQLAlchemy + PostgreSQL.
note

Connecting to Neon (Lakebase) Postgres from SQLAlchemy

There are only 5 steps to follow. Create a project in Neon (Tools used: Neon Console (browser)) Install the Postgres driver (Tools used: pip install psycopg2-binary) First, verify connectivity with ...