RESTp - RESTful Web Service For Performing CRUD Operations Using PDOModel

RESTp – RESTful web service for performing CRUD operations using PDOModel

RESTp is a complicated RESTFul Web service developed using PHP that lets you carry out crud operation. You can mechanically generate all endpoints for crud operation of your database.

It is constructed on high of the favored database abstraction script
“ PDOModel”
and helps Mysql, sqlite, pgsql and MSSQL. You can simply carry out Insert/Update/Delete/Read operation using RESTp api.

Most of the Mobile and Web Apps require communication with server using some API to ship and obtained information. REST is by far essentially the most generally used model for designing APIs, particularly within the cellular world.
These Mobile and web apps usually requires to carry out crud operation i.e Insert information, learn information, replace information and delete information using API.
To write code for the crud operations for every particular person cellular app and web app is kind of cumbersome job. That’s the place RESTp comes into motion.

RESTp is a REST-based mostly answer that simplifies CRUD operations for any cellular or web software. With RESTp, you merely join it to your database, and it mechanically generates all the required sources to deal with CRUD operations, saving you useful effort and time.

For each desk in database, it supplies endpoints to carry out CRUD operations. An instance of all RESTp API endpoints for a desk are under

GET /{table_name} – Retrieves an inventory of all data of desk identify “{table_name}”
GET /{table_name}/12 – Retrieves a particular data of desk identify “{table_name}” with ID 12
POST /{table_name} – Creates a brand new entry in {table_name}
PUT /{table_name}/12 – Updates report of ID #12 in {table_name}
DELETE /{table_name}/12 – Deletes report with ID #12 {table_name}

So when you have desk identify “orders” in your database, it mechanically generate customary relaxation finish factors as under.

GET /orders – Retrieves an inventory of all data of desk identify “orders”
GET /orders/12 – Retrieves a particular data of desk identify “orders” with ID 12
POST /orders – Creates a brand new order
PUT /orders/12 – Updates order #12
DELETE /orders/12 – Deletes order with ID #12

RESTp is construct on high of our standard database abstraction script PDOModel. So customers will get a free copy of PDOModel additionally (value $13).

You can use any type of software to hook up with RESTp api. Whether it’s .NET web app or android cellular or iphone app or php web app, You can join every kind of software to this api and carry out CRUD operation. You can ship information both as json or regular type submission (x-www-type-urlencoded) and obtained information as json, xml, html desk.

Features

Single api to carry out CRUD operation on any database
Supports a number of completely different database (Mysql, PGSQL, SQLITE and SQLSERVER)
Build on high of standard database abstraction script PDOModel
Multiple Input and Output varieties supported
Action filtering as per request sort (GET, PUT, POST, DELETE)
Autogenerates endpoint as per the desk names
Supports fairly url in addition to non fairly urls (if mod_rewrite not enabled)
IP based mostly filters (Allow entry and block based mostly on IP)
Allow or block entry of specific desk (useful resource)
Authentication using JWT

FAQs

What is Rest?
REST means “REpresentational State Transfer”. It is an architectural model for creating web companies.
REST requires {that a} consumer request the server so as to retrieve or modify information on the server.

What is PDOModel?
PDOModel – Database abstraction and helper PHP class that helps to do insert,
replace, delete, choose operation using PDO with out writing any queries and with a lot lesser code.
It helps Mysql, Postgres,SQlite and SQL Server database.PDOModel supplies a whole answer to
carry out CRUD operations on three several types of database (Mysql, Postgres and Sqlite).

For extra particulars about PDOModel, please
click here