Publish REST API

[fuinyroot]

Like Auto-generated REST API for MySQL table, so we will have zero coding for this part but simply configuration

Reference

MySQL Router

• https://blogs.oracle.com/mysql/post/introducing-the-mysql-rest-service
• https://dev.mysql.com/doc/mysql-shell-gui/en/mysql-shell-vscode-rest-services.html
• https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-rest-api-setup.html
• sudo apt install mysql-router

Mariadb MaxScale

• https://mariadb.com/kb/en/mariadb-maxscale-mariadb-maxscale-23/
• https://mariadb.com/kb/en/mariadb-maxscale-23-02/

[fuinyroot]

Notes

• fork 1.2k star 19k https://github.com/Budibase/budibase
• fork 1k star 3.4k https://github.com/mevdschee/php-crud-api :green_heart:
  • https://github.com/thipages/js-crud-api
  • https://github.com/mevdschee/php-api-auth
  • https://github.com/mevdschee/php-crud-ui
  • https://github.com/mevdschee/php-crud-admin
  • https://github.com/mevdschee/php-sp-api
  • https://github.com/nlware/vue-crud-ui
• fork 116 star 1.9k https://github.com/dbohdan/automatic-api :green_heart:
• fork 293 star 1.4k https://github.com/dreamfactorysoftware/dreamfactory
  • https://blog.dreamfactory.com/create-a-mysql-rest-api-in-minutes-using-dreamfactory/
• fork 47 star 149 https://github.com/o1lab/xmysql
• fork 15 star 73 https://github.com/simonw/datasette.io
  • https://datasette.io/
• https://www.integrate.io/pricing/#api?
• https://github.com/tryretool
  • https://retool.com/api-generator/

[fuinyroot]

Sample URL

• http://localhost:2080/api.php/records/gav?filter=group_id,eq,org.opencadc&size=10

[fuinyroot]

Plug-in

• JS-CRUD-API: A JavaScript client library for the API of PHP-CRUD-API
• PHP-API-AUTH: Single file PHP script that is an authentication provider for PHP-CRUD-API
• PHP-CRUD-UI: Single file PHP script that adds a UI to a PHP-CRUD-API project.
• PHP-CRUD-ADMIN: Single file PHP script that adds a database admin interface to a PHP-CRUD-API project.
• PHP-SP-API: Single file PHP script that adds a REST API to a SQL database.
• VUE-CRUD-UI: Single file Vue.js script that adds a UI to a PHP-CRUD-API project.