restfuld is a naive RESTful web service implementation for MySQL database server. It is designed to be simple and is currently used in a test environment. The code has been uploaded on to GitHub to make it publicly availabe but more work is required to make it production ready.
Please see the open issues in GitHub repository and feel free to create new Pull Requests.
You need to have MySQL client development files (mysql.h and libmysqlclient) installed on your system. Please check with your operating system's package manager whether these files are installed along with the MySQL client software by default.
To compile restfuld, simply type make inside the main directory. Use make clean to remove resulting object files and executables.
The code has been tested and is developed on a FreeBSD host machine which uses Clang and BSD make, but you should be able to compile and run the source on any UNIX like system. Be aware, FreeBSD make is derived from pmake not GNU make, which is the default make implementation on GNU/Linux and macOS/Darwin, hence slight modifications may be needed in the Makefile.
After building the source, you just need to run the resulting executable from the command line.
The daemon process will start listening the TCP port, which could be specified via -p command line parameter, for incoming HTTP GET requests.
Once a request is received, an appropriate SQL query is constructed from the name-value pairs contained in the HTTP GET request and sent to MySQL server.
The response from the server is then sent back to the client in JSON format.
Please see the open issues in GitHub repository.
restfuld is distributed under the 2-clause BSD License.