Flutterby™! : PostgREST

Next unread comment / Catchup all unread comments User Account Info | Logout | XML/Pilot/etc versions | Long version (with comments) | Weblog archives | Site Map | | Browse Topics

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.