![Top Features of Vision-Based Workplace Safety Tools [2025]](https://static.wixstatic.com/media/379e66_7e75a4bcefe14e4fbc100abdff83bed3~mv2.jpg/v1/fit/w_1000,h_884,al_c,q_80/file.png?#)
![How to Use AI as a Productivity Tool with Mike Kaput [MAICON 2025 Speaker Series]](https://www.marketingaiinstitute.com/hubfs/v2MAICON-Speaker_Series.png)
![[The AI Show Episode 152]: ChatGPT Connectors, AI-Human Relationships, New AI Job Data, OpenAI Court-Ordered to Keep ChatGPT Logs & WPP’s Large Marketing Model](https://www.marketingaiinstitute.com/hubfs/ep%20152%20cover.png)
![[DEALS] Microsoft Visual Studio Professional 2022 + The Premium Learn to Code Certification Bundle (97% off) & Other Deals Up To 98% Off](https://www.javacodegeeks.com/wp-content/uploads/2012/12/jcg-logo.jpg){kind=logo}
![PSA: Widespread internet outage affects Spotify, Google, Discord, Cloudflare, more [U: Fixed]](https://i0.wp.com/9to5mac.com/wp-content/uploads/sites/6/2024/07/iCloud-Private-Relay-outage-resolved.jpg?resize=1200%2C628&quality=82&strip=all&ssl=1)
![Apple Shares Teaser Trailer for 'The Lost Bus' Starring Matthew McConaughey [Video]](https://www.iclarified.com/images/news/97582/97582/97582-640.jpg)
Cassandra + ElasticSearch VS PostgreSQL or MySQL
Assuming we want to build a shop like Amazon with millions of products in dozens of different categories, where each category has its own specific properties but also shares some common properties, I am wondering: is a SQL-based database like MySQL or PostgreSQL a better choice, or should I go with a NoSQL solution like Cassandra combined with Elasticsearch? I’m not a professional web developer but I’m working on an MVP app for a startup and would like to understand which option would be better. I have more experience with Cassandra and its denormalization concept, and I also know a bit about Elasticsearch, but I’m wondering if I might be going in the wrong direction if using PostgreSQL or MySQL would be a better option. My main concern is to have a home screen like Amazon’s, where users can filter products by one, two, or even ten different properties. For example, they should be able to choose to see only products from categories A and C, or see only products from category B that are within a specific price range and have a red color and will be shipped tomorrow, etc. etc.
Assuming we want to build a shop like Amazon with millions of products in dozens of different categories, where each category has its own specific properties but also shares some common properties, I am wondering: is a SQL-based database like MySQL or PostgreSQL a better choice, or should I go with a NoSQL solution like Cassandra combined with Elasticsearch?
I’m not a professional web developer but I’m working on an MVP app for a startup and would like to understand which option would be better.
I have more experience with Cassandra and its denormalization concept, and I also know a bit about Elasticsearch, but I’m wondering if I might be going in the wrong direction if using PostgreSQL or MySQL would be a better option.
My main concern is to have a home screen like Amazon’s, where users can filter products by one, two, or even ten different properties.
For example, they should be able to choose to see only products from categories A and C, or see only products from category B that are within a specific price range and have a red color and will be shipped tomorrow, etc. etc.
