Needs advice
on
PostgreSQLPostgreSQL
and
RedisRedis

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!

READ LESS
4 upvotes·143 views
Replies (3)

Both depending on the workload. Usually redis is pretty good at in-memory applications and can do key-based persistence. Postgres is more made for SQL and can do key value persistence as well. I would rather choose PostgreSQL, with a bit of redis for specific parts.

READ MORE
2 upvotes·1 comment·20 views
Michael Wyllie
Michael Wyllie
·
February 26th 2022 at 3:20AM

Thanks for the feedback

·
Reply
Recommends
on
PostgreSQL
Redis

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.

READ MORE
7 upvotes·1 comment·213 views
Michael Wyllie
Michael Wyllie
·
February 26th 2022 at 3:07AM

Thanks for the feedback

·
Reply
View all (3)
Avatar of Laurent Valdes

Laurent Valdes

Architect