Flutterby™! : PostgREST

PostgREST

2015-01-04 17:43:49.524116+01 by Dan Lyke 6 comments

PostgREST: Simple REST client for PostgreSQL databases written in Haskell. It does depend on the database security rules, which means you have to have a very well adminned Postgres installation.

[ related topics: Open Source Databases ]

comments in descending chronological order (reverse):

#Comment Re: PostgREST made: 2015-01-12 16:28:06.664756+01 by: Jack William Bell

Cool. Except ArrestDB is PHP.

Not that I'm hating on PHP or anything, but I would prefer something in Python or Node.js. Even Java!

Truth is, I'm not really interested in a Haskell solution much either, but the performance numbers for PostgREST looked awful sweet.

#Comment Re: PostgREST made: 2015-01-12 05:37:05.200914+01 by: ebwolf

I've found ArrestDB do be quite handy when dealing with MySQL. Evidently it works for PostgreSQL as well.

#Comment Re: PostgREST made: 2015-01-07 17:24:59.298935+01 by: Dan Lyke

I haven't done much around this, but I know there are ways, either the CORS header, or... I need to look at what the Meteor real-time server does, because I know I've used that to do a simple chat client, expected to find problems, and didn't.

#Comment Re: PostgREST made: 2015-01-07 06:11:00.090533+01 by: Jack William Bell

So far I haven't found how you can use PostgREST to store anything except data in JSON format. Kind of a downside for that kind of server implementation. Given same origin rules you'll have to front-end it with Apache or NginX if you want to do anything really interesting.

Which is OK for big projects. But I want something more useful in the small.

#Comment Re: PostgREST made: 2015-01-06 20:34:30.489006+01 by: Dan Lyke

I need to learn enough of one of the various JavaScript front-ends for this.

Configuring security via the database server might be a PITA, but the idea of doing away with CGI middleware feels like it could be pretty cool...

#Comment Re: PostgREST made: 2015-01-04 21:07:14.411245+01 by: Jack William Bell

That is amazingly cool. And the performance numbers show what can be done using non-blocking IO in conjunction with lightweight threads. I'll admit I know little about Haskell as a language, but in this case it may not matter as the real skills you need are PostgreSQL and an understanding of REST.

I'm already trying to think of use cases where I can implement something using PostgREST.

Comment policy

We will not edit your comments. However, we may delete your comments, or cause them to be hidden behind another link, if we feel they detract from the conversation. Commercial plugs are fine, if they are relevant to the conversation, and if you don't try to pretend to be a consumer. Annoying endorsements will be deleted if you're lucky, if you're not a whole bunch of people smarter and more articulate than you will ridicule you, and we will leave such ridicule in place.

Flutterby™ is a trademark claimed by

Dan Lyke

for the web publications at www.flutterby.com and www.flutterby.net.