Hacker News Reader

Comment by michaelchisari | Hacker News Reader

I have a use for this. I'll be evaluating it. Anyone know of any similar projects?

If you don't mind propietary software, my employer Denodo has recently released an "Express" version of its data virtualization platform: http://www.denodo.com/denodo-platform/denodo-express

One of its features is to provide a RESTful view of relational tables in a database, in a manner reminiscent of PostgREST. One difference is that with Denodo Express you must explicitly import tables from the "wrapped" database into the Denodo server that works as intermediary. The Denodo server can wrap other databases besides Postgres.

I wrote a bit about it here: http://productivedetour.blogspot.com.es/2014/12/connecting-t... (although I don't really cover the REST aspect.)

Yes: http://www.zenqry.com/

ZenQuery is similar in that it creates REST API endpoints for your database tables / specific SQL queries. However, it's database-agnostic and runs as an independent web application.

May I ask what your use case is?

HTSQL[1,2] by Clark Evans is similar.

1- http://htsql.org/doc/overview.html

2- https://en.wikipedia.org/wiki/HTSQL

https://github.com/pgrest/pgrest

https://wiki.postgresql.org/wiki/HTTP_API

You should probably consider OpenRESTy.

Another +1 vote for OpenRESTy, its simply brilliant ..

http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-ng...

sandman for python

i.e. https://github.com/jeffknupp/sandman a REST api for all sql databases using sqlalchemy.

The website http://www.sandman.io/ seems to be down - expired last November.

That probably is because he rewrote it:

https://github.com/jeffknupp/sandman2

www.zazler.com works with Postgres, MySQL, SQLite and SQL server

Reply on news.ycombinator.com