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 16:43:49.524116+00 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 ascending chronological order (reverse):

#Comment Re: PostgREST made: 2015-01-04 20:07:14.411245+00 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 Re: PostgREST made: 2015-01-06 19:34:30.489006+00 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-07 05:11:00.090533+00 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-07 16:24:59.298935+00 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-12 04:37:05.200914+00 by: ebradway

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-12 15:28:06.664756+00 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.