I’m working on a new project and struggling with the right setup.
Topic is a database of products of a specific branch/industry sector, where producers can register their products (Article No., Description, Price, etc.) on a website (csv-upload for example).
Different software providers of the branch/industry sector should then be able to implement the API so the users can lookup the products.
Because of the potential huge amount of queries and the different programs I’m not really sure which type of API should be used for the best performance and compatibility of different software developed in different languages.
My first thought would be a REST API which can be handled by nearly all development environments, would you recommend that?
And which database type would be the best for data amount of more than 2-3 M. entries (additional with different table joins because of separation of manufacturer and items). And many different queries of the software users also the same time.
**1) Which type of API is recommended? (REST-API?)
2) Which type of database is recommended for performance?
3) Is there a server sided must have?
Thank you very much in advance for your thoughts,
Christian