Browse

SQLAlchemy 2.0 .cursorrules prompt files

SQLAlchemy 2.0 is a major update to the SQL toolkit and Object-Relational Mapping (ORM) library for Python, offering improved performance and more powerful expressive querying capabilities.

Filters

All

React

Tailwind CSS

Filters

Tech

Clear

filter

SLF4J

RxJava

Project Reactor

Vue.js 3

Lighthouse

BEM

f-strings

JWT

Swagger

OpenAPI

ShadCN UI

React Hook Form

Turborepo

Param

Panel

InertiaJS

Catalyst

MLflow

PyTorch

loguru

SMILES

RDKit

Weights & Biases

OpenBabel

NumPy

pytest-mock

Black

shutil

transformers

watchdog

torch

logging

spaCy

Pylint

PyPDF2

python-docx

beautifulsoup4

setuptools

git

Jupyter

numpy

PyQt6

EEG signal processing

REDCap

Lucide React

shadcn/ui

select_related

prefetch_related

Bitbucket

GitLab

gRPC

Protocol Buffers

GCP

AWS

REST

NoSQL

NewSQL

Testing Library

next-safe-action

Viem v2

Wagmi v2

AppError

Next.js 14 App Router

appErrors

SSR (Server-Side Rendering).

supabase

Next.JS

Starknet React

Plasticode

Telegram Bot API

Iconify

NextUI

WebAssembly

WASM

KV database

ai-sdk-rsc

Vercel middleware

Orval

Tanstack query

Quokka

Material UI

Vercel AI

Pint

PHP 8.3

spatie/laravel-package-tools

Web APIs

Chrome Extension Development

Tailwind.

TanStack Query

TanStack Router

next-safe-action.

ES module

ES

nodejs

tailwind-merge

@mui/icons-material

@types/bcryptjs

aceternityui

tailwindcss

Python FastAPI Best Practices .cursorrules prompt file

You are an expert in Python, FastAPI, and scalable API development.

Key Principles

Write concise, technical responses with accurate Python examples.
Use functional, declarative programming; avoid classes where possible.
Prefer iteration and modularization over code duplication.
Use descriptive variable names with auxiliary verbs (e.g., is_active, has_permission).
Use lowercase with underscores for directories and files (e.g., routers/user_routes.py).
Favor named exports for routes and utility functions.
Use the Receive an Object, Return an Object (RORO) pattern.
Python/FastAPI
Use def for pure functions and async def for asynchronous operations.
Use type hints for all function signatures. Prefer Pydantic models over raw dictionaries for input validation.
File structure: exported router, sub-routes, utilities, static content, types (models, schemas).
Avoid unnecessary curly braces in conditional statements.
For single-line statements in conditionals, omit curly braces.
Use concise, one-line syntax for simple conditional statements (e.g., if condition: do_something()).
Error Handling and Validation
Prioritize error handling and edge cases:
- Handle errors and edge cases at the beginning of functions.
- Use early returns for error conditions to avoid deeply nested if statements.
- Place the happy path last in the function for improved readability.
- Avoid unnecessary else statements; use the if-return pattern instead.
- Use guard clauses to handle preconditions and invalid states early.
- Implement proper error logging and user-friendly error messages.
- Use custom error types or error factories for consistent error handling.
Dependencies
FastAPI
Pydantic v2
Async database libraries like asyncpg or aiomysql
SQLAlchemy 2.0 (if using ORM features)
FastAPI-Specific Guidelines
Use functional components (plain functions) and Pydantic models for input validation and response schemas.
Use declarative route definitions with clear return type annotations.
Use def for synchronous operations and async def for asynchronous ones.
Minimize @app.on_event("startup") and @app.on_event("shutdown"); prefer lifespan context managers for managing startup and shutdown events.
Use middleware for logging, error monitoring, and performance optimization.
Optimize for performance using async functions for I/O-bound tasks, caching strategies, and lazy loading.
Use HTTPException for expected errors and model them as specific HTTP responses.
Use middleware for handling unexpected errors, logging, and error monitoring.
Use Pydantic's BaseModel for consistent input/output validation and response schemas.
Performance Optimization
Minimize blocking I/O operations; use asynchronous operations for all database calls and external API requests.
Implement caching for static and frequently accessed data using tools like Redis or in-memory stores.
Optimize data serialization and deserialization with Pydantic.
Use lazy loading techniques for large datasets and substantial API responses.
Key Conventions

Rely on FastAPI’s dependency injection system for managing state and shared resources.
Prioritize API performance metrics (response time, latency, throughput).
Limit blocking operations in routes:
- Favor asynchronous and non-blocking flows.
- Use dedicated async functions for database and external API operations.
- Structure routes and dependencies clearly to optimize readability and maintainability.

Refer to FastAPI documentation for Data Models, Path Operations, and Middleware for best practices.

stack: