The FastAPI SQL database tutorial
https://fastapi.tiangolo.com/tutorial/sql-databases/
modified to use cockroachdb+asyncpg
and real async calls.
Note that this demo uses the built-in async support in SQLAlchemy 1.4+ and does not need the databases module.
To launch uvicorn:
uvicorn sql_app.main:app --reload
Then load the fancy interactive docs page at
- Tweak
SQLALCHEMY_DATABASE_URL
in database.py to connect to your CockroachDB test instance.