Hey all, not sure if I have this in the right section.
I have a fairly complicated Elixir/Phoenix project currently running using Postgres to store most of the data.
Users come to the site and can post listings which are products they want to sell. The products can be from a number of categories: books, furniture, cars, etc. meaning different attributes are necessary for different categories.
I’ve essentially hit a point where it’s very difficult to represent the data I need in a RDBS and I’m looking for something more flexible. I know there are plenty of tools out there like: MongoDB, ElasticSearch, Cassandra, Redis, etc. but I don’t know which one will work best for my use case.
I need a tool flexible enough to model the unique product attributes for different categories. It needs to be fast and scalable. I’m just hoping somebody can point me in the right direction.