Hello
@toby
1. Security: jRDC2 is very secure, with a PHP script or API you must provide security yourself.
2. Performance: The speed is incredible, logically you can take full advantage of the potential of your server.
3. Implementation; It's very easy since all the SQL queries and information of your database are handled from a configuration file.
4. Operation: You must understand that jRDC2 is a middleware that works in Java.
So it only works in the following ways:
Local service: both your database and jRDC2 run locally on a PC or Server connected to a LAN or WIFI network.
It is possible to convert into a PC or Local Server remotely, for that you must request a public Internet IP from your ISP (Internet Service Provider).
Remote Service: You can have jRDC2 and its database running on a VPS (Virtual Private Server), there are several that I like such as DigitalOcean, Google Cloud and VPS Mart.
Personally, I have already made several mobile applications using jRDC2 connected to SQL Server and customers are satisfied with the response speed.