Write a blog about sqlalchemy and fastapi

[kigawas]

title: FastAPI and Async Sqlalchemy: the catalyst for Python web development

[kigawas]

• Why to use fastapi, compared with flask, django (non async framework) or sanic/aiohttp (async frameworks)
• Why to use gino, compared with tortoise-orm, orm or async sqlalchemy
• How to use fastapi: a minimal example to start with
• How to use gino: manage relations cleverly
• Best practices: pre-commit, flake8, mypy

[kigawas]

Why fastapi

Competitive performance, even compared with Java or Go without much tuning

Python web framework benchmarks

Note that the word "performance" means throughput, rather than speed Actually, async web frameworks may make some requests obviously slower (it's highly variant in latency)

[Wrk result here]

Performance: uvloop-based frameworks are on the top among Python frameworks, more specifically (req/s): Generally uvicorn > sanic > starlette > fastapi >>> flask/django

Read from db: Fastapi ~= spring (Java)

Write to db: Fastapi > spring (Java) > gin (Golang)

[Benchmark here]

What if ORM?

• ORM is undoubtedly much slower than raw queries like asyncpg

How to solve?

• Baked query

Documentation included

Web API -> OpenAPI? OpenAPI -> Web API?

[kigawas]

Gino -> Async SqlAlchemy