We need to design a database model for an (internal) inventory system with the following criteria:
- Inventory can hold only 1 type (
- There might be more than a million
- There is absolutely no use case for querying items for multiple users at once.
- We should be able to query by properties (again user is constant).
We thought about creating a table per user, but at the end we decided to go with
Solr. Is this the right approach? Is there better technology for this particular use case?
Note: We are using
Java for backend and
PostgreSQL as database if it matters.