Python SQLModel: Typed CRUD with FastAPI
Model a table, run CRUD in short sessions, and separate persisted data from your API public contracts.
Explore our technical articles, practical tutorials, and career guides.
The fuel for your journey in the Python Universe.
Model a table, run CRUD in short sessions, and separate persisted data from your API public contracts.
Retry transient failures with explicit limits, randomized waits, observability, and fast deterministic tests.
Turn annotated functions into a maintainable CLI with generated help, validation, subcommands, and focused tests.
Automate fast checks before each commit with pinned pre-commit hooks and the same validation in CI.
Centralize application configuration with pydantic-settings and fail early when required environment values are missing.
Define lightweight contracts with typing.Protocol and accept compatible objects without requiring explicit inheritance.
Coordinate related tasks with asyncio.TaskGroup while understanding results, failures, cancellation, and gather.
Organize shared API logic with FastAPI Depends, Annotated, sub-dependencies, yield, and test overrides.
Build clearer tests with fixtures, temporary files, and monkeypatch without testing mocks instead of behavior.
Turn a DataFrame into an interactive Streamlit dashboard with filters, metrics, charts, and deliberate caching.
Version schema changes with Alembic and SQLAlchemy, reviewing generated migrations before applying them safely.
Use Ruff for linting, import sorting, and formatting with a small configuration and predictable CI checks.