'MySQL -> RESTful API [closed]
Is there anything out there that given a MySQL database can create RESTful webservice endpoints? I'm ok with it doing stupid basic things to start with, as long as the data model is tunable after.
For bonus points it could understand foreign keys to join data, and create searching endpoints for indexed columns.
Solution 1:[1]
PHP REST SQL might be a starting point.
Solution 2:[2]
There is DBSlayer, which provides a "JSON over HTTP" interface to MySQL. It doesn't have a REST interface, though.
Solution 3:[3]
Check out restSQL. It's an open-source, ultra-lightweight persistence layer. It's a got enough for basic CRUD and a little bit of basic filtering support.
It has built in support for MySQL and PostgreSQL, but is architected to be extended to other RDBMSes. It runs in standard JEE containers, e.g. Tomcat, or is bundled as a Docker container.
You can take it for a spin using the sandboxed instance and explore the docs at http://restsql.org.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Paul Morgan |
| Solution 2 | trendels |
| Solution 3 |