Postgrest for mysql

by

PostgREST for MySQL

PostgREST is a web server, written in Haskell, that serves a RESTful API directly from a PostgreSQL database. It automatically exposes the tables, views, and stored procedures of the PostgreSQL database as RESTful endpoints.

However, PostgREST is specifically designed for PostgreSQL databases and does not support MySQL out of the box. If you want similar functionality for MySQL, you can consider using other tools that provide RESTful API generation for MySQL databases. Some popular options include:

  • LoopBack: LoopBack is a highly-extensible, open-source Node.js framework that can be used to create RESTful APIs for various databases, including MySQL. It provides a convenient way to define models, relationships, and access controls, and automatically generates RESTful endpoints.
  • Django REST Framework: Django is a high-level Python web framework that includes the Django REST Framework, which can be used for building RESTful APIs. Django supports MySQL as a database backend, allowing you to generate RESTful endpoints for your MySQL database.
  • Sails.js: Sails.js is a full-featured MVC framework for Node.js that can be used to build real-time, data-driven web applications. Sails.js supports MySQL as a database adapter, and it provides built-in support for generating RESTful APIs.

Here’s an example of how you can use LoopBack to generate a RESTful API for a MySQL database: 


$ npm install -g loopback-cli
$ lb
? What's the name of your application? myapp
? Which version of LoopBack would you like to use? 4.x (current)
? What kind of application do you have in mind? api-server (A LoopBack API server with local User auth)
$ cd myapp
$ lb datasource
? Enter the data-source name: mydb
? Select the connector for mydb: MySQL (supported by StrongLoop)
? Connection String url to override other settings (eg: mysql://user:pass@host/db): mysql://user:password@localhost/mydatabase
$ lb model
? Enter the model name: Customer
? Select the data-source to attach Customer to: mydb (mysql)
? Select model's base class: PersistedModel
? Expose Customer via the REST API? Yes
? Custom plural form (used to build REST URL): customers
? Common model or server only? Common
$ lb migration
? Enter a name for the migration: AddAddressToCustomer
? Select the version of LoopBack where the migration will be executed: 4.x (current)
$ lb run

This example demonstrates how to create a LoopBack application, connect it to a MySQL database, define a model for the “Customer” table, and generate RESTful endpoints (e.g., GET /customers, POST /customers, etc.). You can then use these endpoints to interact with the MySQL database through the generated API.

The other frameworks mentioned, Django REST Framework and Sails.js, also have similar workflows for generating RESTful APIs for MySQL databases. You can refer to their respective documentation for more detailed examples and instructions.

Leave a comment