Backend
Databases and API servers. Default to Postgres for app data and SQLite for local or single-writer cases. Reach for ChromaDB when the workload is vector retrieval.
Pages
- postgres: Schema design, indexes, migrations, JSONB.
- prisma: Schema modeling, migrations, transactions, pooling.
- fastapi: Pydantic models, dependency injection, async I/O.
- sqlite: When SQLite is the right database.
- chromadb: Embeddings storage and retrieval.