Re: PostgreSQL 9.5 and process REST calls enquiry

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, James Keener <jim(at)jimkeener(dot)com>, Peter van Eck <peter(at)vaneckzone(dot)net>
Subject: Re: PostgreSQL 9.5 and process REST calls enquiry
Date: 2016-03-06 01:34:13
Message-ID: CAFcOn29++Z7MPM7-f2sn=0zwYBc19qw0gqswiSK0S2KpFu0GRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to extend (and complete) this thread by collecting
programs/frameworks/applications that provide REST services over
Postgres.

I see following categories and open source web frameworks and/or libs:
Those which
* attach Postgres directly, like PostgREST (Haskell) or jsgrest
(JavaScript serverside).
* connect to (m)any db inc. Postgres, like Spring Boot (Java EE) or
sandman2 (Python)

PostgREST looks promising.
But since Postgres 9.5 ff. has good JSON support (and given I like
Python) I'd prefer an even more lightweight solution.
Any suggestions?

:Stefan

2016-02-12 17:46 GMT+01:00 Peter van Eck <peter(at)vaneckzone(dot)net>:
>
>
> On 12/02/16 17:34, Adrian Klaver wrote:
>>
>> On 02/12/2016 08:06 AM, James Keener wrote:
>>>
>>>
>>> https://github.com/begriffs/postgrest also looks interesting!
>>>
>>>
>>> I thought the purpose of Spring/Spring Boot was to provide the REST
>>> services in front of your choice of data store. Not sure how putting
>>> another server in the stack is going to help things.
>>>
>>>
>>> I was simply responding to the original question about accessing the DB
>>> over HTTP.
>>
>>
>> Then I am not sure what the question is.
>>
>> Do you want to know how to use Spring Boot with Postgres or do you want
>> suggestions for programs/frameworks/applications that provide REST services
>> over Postgres?
>>
>> Or is something else that I am entirely missing:)?
>>
>>
> Hi Adrian, James,
>
> Thanks for your replies sofar.
>
> It is exactly my point that for us the request from the developers wasn't
> clear to us as we don't have the knowledge to apparently fully understand
> the question.
> I think it is as you describe Adrian "Do you want to know how to use Spring
> Boot with Postgres"
> So we'll go with that and see when the first release is pushed from the
> developers.
>
> thnaks again.
>
>
> Peter
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-03-06 15:26:38 Re: PostgreSQL 9.5 and process REST calls enquiry
Previous Message Francisco Olarte 2016-03-05 18:53:04 Re: multiple UNIQUE indices for FK