Lobsters!

I’m after some suggestions on tools/components/ibraries to use for the following use case.

• I want to build a UI that allows a user to build a ‘parts box’, from an available parts database of 100,000 parts.
• The UI should consist of a a filter pane at the top, the parts list itself showing taking the main share of the screen (part name, stock, supplier, price, etc.), and the current parts box selections on the right.
• The user will use the filters in the top pane to search the products available. Changes to the filters should update the parts list very rapidly.
• The parts list will usually be ordered by a ‘score’ which is roughly a sum of the score according to the search filters, and according to relationship of items chosen so far. (For example, some parts are in groups. If there is a part chosen in the box in a group, the other parts in the group will get a higher score in the search results)
• Required filters aren’t all known right now, but will include things like description text search, date range, price filter, size filter, etc. It’s likely there will be reasonably heavy use of tags - either single values or key:pair tags.

I’d be reasonably confident building this for the web, except for the speed issue - the products list must update very quickly as the filters change, to allow the user to carry out the whole process reasonably fast without waiting when the filters change.

I’m not at all sure what database or search tool is best suited to this, so not really sure how to search for what I need.

This is for internal use, so there is no requirements that it runs through a browser, and could have a local server.

Thanks, appreciate any direction, ideas.

james