My company has a huge database that receives many (many) events from several sources for monitoring and reporting. Until now, each new panel or graphic information from the data is a new Rails application with additional tables in a huge database and full access to the contents of the database.
Recently, the idea came up that our customers have external (both in our company and its subsidiaries) clients, and it was decided that we should provide a read-only RESTful API to consult our data.
My point: should we use the API for our own projects? Does access to the RESTful API hinder even "local" projects instead of directly accessing the database? I think it would pay off in terms of uniting our data access team - but is it worth the extra back and forth? And can the RESTful API support requirements for running around 20 queries per second and presenting results via JSON?
Thanks for any input!
source
share