Which would be more powerful for an enterprise-grade web-based application like marketplace e-commerce or an industrial application? Based on your experience, what would be the main reason for you to choose one of them? Please help share some insights. Thanks a lot!
Probably both. They're apples and oranges.
PostgreSQL is ideal for storing long-term non-volatile data items, like your stock, users, orders and so on.
Redis is ideal for volatile/cache storage, for things like session and transient message queues.
If you're building an enterprise-grade web based app, you will probably end up using both.
These are vastly different tools. Redis might be great for FAST access or caching something temporarily, but it doesn't really work as a primary data store.
If you're going enterprise-grade, you might have an RDS like PostgreSQL doing the bulk of the work, but the employ something like Redis to handle some form of caching or temporary data to take load off your RDS servers.
It's also important to note, that Redis does not really support complex queries and data schemas, even though there's ways of implementing them. It's more like shared memory than data storage.
