RESTp - RESTful web service for performing CRUD operations using PDOModel

RESTp - RESTful web service for performing CRUD operations using PDOModel

It is built on top of the popular database abstraction script “ PDOModel” and supports Mysql, sqlite, pgsql and MSSQL. You can easily perform Insert/Update/Delete/Read operation using RESTp api.

Most of the Mobile and Web Apps require communication with server using some API to send and received data. REST is by far the most commonly used style for designing APIs, especially in the mobile world. These Mobile and web apps often requires to perform crud operation i.e Insert data, read data, update data and delete data using API. To write code for the crud operations for each individual mobile app and web app is quite cumbersome task. That’s where RESTp comes into action.

RESTp is a REST-based solution that simplifies CRUD operations for any mobile or web application. With RESTp, you simply connect it to your database, and it automatically generates all the necessary resources to handle CRUD operations, saving you valuable time and effort.

For every table in database, it provides endpoints to perform CRUD operations. An example of all RESTp API endpoints for a table are below

• GET /{table_name} – Retrieves a list of all records of table name “{table_name}”
• GET /{table_name}/12 – Retrieves a specific records of table name “{table_name}” with ID 12
• POST /{table_name} – Creates a new entry in {table_name}
• PUT /{table_name}/12 – Updates record of ID #12 in {table_name}
• DELETE /{table_name}/12 – Deletes record with ID #12 {table_name}

So if you have table name “orders” in your database, it automatically generate standard rest end points as below.

• GET /orders – Retrieves a list of all records of table name “orders”
• GET /orders/12 – Retrieves a specific records of table name “orders” with ID 12
• POST /orders – Creates a new order
• PUT /orders/12 – Updates order #12
• DELETE /orders/12 – Deletes order with ID #12