Is there any restful api for postgresql?

Question

Im trying to develop a web app using angularjs, restangular and postgresql, im using ubuntu and xampp for development. I found ArrestDB, a restful api for postgresql. In its documentation,

# Get all rows from the "customers" table where the "country" field matches "Australia" (LIKE) GET http://api.example.com/customers/country/Australia/

https://github.com/alixaxel/ArrestDB

While in restangular documentation,

// Just ONE GET to /accounts/123/buildings/456
Restangular.one('accounts', 123).one('buildings', 456).get()

https://github.com/mgonto/restangular

Do you guys know a free RESTful api for postgresql that works well with restangular?

ArrestDB interprets api/{Table}/{Field}/{....} while Restangular interprets api/{table}/{id}/{relations table}. I also tried api/{table}/{id}/{relations table} in ArrestDB but I get error 404.

I also found Postgrest in github but its in haskel, and i'm not familiar with haskel.

Thanks...

I think with a proper authorization it will help to secure the db. — Abdullah
– Abdullah, Commented Feb 3, 2015 at 13:26
I think you can implement your own solution using CodeIgniter and github.com/philsturgeon/codeigniter-restclient. It's friendly for postgresql (and others too) — Joao Polo
– Joao Polo, Commented Sep 13, 2016 at 12:19

Chris Stryczynski · Accepted Answer · 2017-07-07 13:44:51Z

3

Postgrest seems to be a very viable choice. There is no knowledge of Haskell required to interact with it.

answered Jul 7, 2017 at 13:44

Chris Stryczynski

34.8k60 gold badges210 silver badges334 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lemon Cat · Accepted Answer · 2018-01-02 18:13:05Z

2

I have used PostgREST and recommend it. It is written in Haskell but requires no knowledge of Haskell (in the same way that pg is written in C, but no knowledge of C is required to use it). The documentation at postgrest.com is quite helpful and I've been able to get up to speed with it quickly. Best practices are to run pgREST through a reverse proxy (Apache, Nginx, etc.) to control web authentication and authorization. PostgreSQL will enforce permissions GRANTed to the configured pgREST user (INSERT, UPDATE, DELETE, etc.) on the DB served up by pgREST. There are a number of access control options listed in the pgREST documentation for switching user roles as requests come in, so the access control is pretty flexible in accommodating different usage scenarios.

edited Jan 2, 2018 at 18:13

answered Jan 2, 2018 at 17:14

Lemon Cat

1,21213 silver badges15 bronze badges

1 Comment

Lemon Cat Over a year ago

Also try graphile.org to expose a PostgreSQL DB as a GraphQL schema. Code is written in NodeJS, but as a non-javascript person I was still able to get up and running within a few minutes.

l2ysho · Accepted Answer · 2016-10-04 11:30:00Z

0

You can use Express.js and Node.js to create RESTful API for example. It works with PostgreSQL well. I am using it now for my application, so I have a PostgreSQL DB, back-end in Express.js with pg-promise and Node.js and front-end in AngularJS with Restangular.

You can try this tutorial, this guy has a quite good blog about building API and other useful things.

edited Oct 4, 2016 at 11:30

answered Sep 13, 2016 at 12:10

l2ysho

3,1131 gold badge26 silver badges44 bronze badges

Collectives™ on Stack Overflow

Is there any restful api for postgresql?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related