You’re designing how a conversational search product should store and retrieve user search history across web and mobile surfaces. The history needs to support fast timeline views, thread-level retrieval, deletion requests, and future features like personalization and analytics. You want to choose between a SQL system, a NoSQL system, or a hybrid approach before the team commits to implementation.
How would you analyze the trade-offs between SQL and NoSQL databases for storing and retrieving conversational search history?