I am looking to buy a Raspberry Pi 2, which I intend to use it as a database server for a small business.
The database will be PostgreSQL and the OS, Raspbian. "Small business" means that will be used in a school (small one), where students can view classes and check their grades. There will be 50-100 user accounts.
What I am afraid, and I would like to ask for your opinions, is if the Raspberry Pi 2 can handle scenarios like:
- 10 users (or less than 30) send queries at the same time
- 20 users (or more) are connected at the same time
- ... and other scenarios that are focused on connectivity or database operations.
At the beginning, users will have only the permission to read from database (but in future they might add or update data).
All in all, can Raspberry Pi 2 be used as a database server with low to medium traffic? (and maybe with the scenario mentioned above?)