Whenever you're ready, walk me through how you'd approach this.
What are the differences between SQL and NoSQL databases, and when would you use each? Compare their data models, schema behavior, consistency and transaction guarantees, querying patterns, scaling characteristics, and operational trade-offs. Give one concrete example of choosing between PostgreSQL and a NoSQL database.