PostgreSQL

When to Use

• PostgreSQL database operations
• SQL query optimization
• Schema design and migrations
• JSONB document storage within a relational model
• Full-text search without a dedicated search engine
• Complex analytical queries with window functions and CTEs

When NOT to Use

• NoSQL-only projects where no relational database is involved
• In-memory databases like Redis or SQLite used purely for caching or ephemeral storage
• File-based storage scenarios that do not require a database engine