All geek questions in one place

MySQL & # 8594; RESTful API

Is there anything that assumes that the MySQL database can create RESTful web service endpoints? I'm fine with this doing stupid basic things to start with while the data model is being tuned after.

For bonus points, he can understand foreign keys for combining data and create search endpoints for indexed columns.

+4
source share
3 answers

PHP REST SQL may be the starting point.

+2
source

There is a DBSlayer that provides a "JSON over HTTP" interface for MySQL. However, it does not have a REST interface.

+1
source

Check out restSQL . This is an open source layer, ultra lightweight emphasis. This is sufficient for basic CRUD and some basic filtering support.

It is built in support for MySQL and PostgreSQL, but can be decrypted for other RDBMS. It works in standard JEE containers, for example. Tomcat, or comes as a Docker container.

You can take it for rotation using an isolated instance and examine the documents at http://restsql.org .

0
source

Source: https://habr.com/ru/post/1286051/

More articles:


All Articles