Database Access

SQLAlchemy 2 (async), psycopg, connection pooling, migrations (Alembic).

Why we need this / what value this brings

Localz's system of record is PostgreSQL via SQLAlchemy 2 — the ORM's async patterns are non-obvious coming from sync SQLAlchemy 1.x.

When to use this

Any schema change or query-performance investigation on the Localz backend.

How to use or implement this

SQLAlchemy 2's async session patterns, Alembic for migrations, EXPLAIN ANALYZE before assuming an index will help.

Research questions

• (add as research surfaces open questions)

---

Empty folder — drop notes, links, and findings here as you research.