skip to content

database (2)

DuckDB — Embedded Analytics Database

Run fast analytical SQL queries in-process with DuckDB. Covers Python API, CSV/Parquet ingestion, pandas interop, Arrow, window functions, and persistent databases.
python duckdb sql analytics olap parquet pandas arrow

SQLModel — Typed ORM for FastAPI

Define database models with Python type hints using SQLModel. Covers table creation, CRUD, relationships, FastAPI integration, Pydantic validation, and async sessions.
python sqlmodel orm sql fastapi pydantic sqlalchemy database