From: | Manuel Zahariev <m(at)s2x(dot)co> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | s2x 1.1 released (SQL to Anything) |
Date: | 2014-06-02 14:02:55 |
Message-ID: | 1401717775.2822.13.camel@garibaldi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
s2x 1.1 has been released (http://s2x.co)
----------------------------------------------------------------------
s2x ("SQL to Anything") converts SQL functions calls to a variety of
formats (JSON, XML, csv, Excel) and returns result sets over HTTP.
SQL function names and parameters are passed inside HTTP requests.
Multiple calls can be chained into one HTTP request to avoid database
round-trips.
s2x works with PostgreSQL (8.1+) and Apache (2.2+) on Ubuntu, CentOS and
other UNIX systems. GPLv3
http://s2x.co
----------------------------------------------------------------------
Synopsis
========
CREATE FUNCTION listProductNames() RETURNS SETOF varchar AS $$
SELECT name FROM Products;
$$ LANGUAGE 'SQL';
GRANT EXECUTE ON FUNCTION listProductNames() TO s2x;
curl http://s2x.co/json?listProductNames
curl http://s2x.co/listProductNames.json
{"listProductNames":[{"name":"Snow blower"},{"name":"Cordless drill"}]}
curl http://s2x.co/listProductNames.xml
<sql2xml>
<function name="listProductNames">
<set>
<record><value name="name">Snow blower</value></record>
<record><value name="name">Cordless drill</value></record>
</set>
</function>
</sql2xml>
curl http://s2x.co/listProductNames.csv
curl http://s2x.co/listProductNames.xlsx
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Pennella | 2014-06-05 18:27:38 | Postgres Open 2014 Early Bird Tickets and Tutorials on Sale! |
Previous Message | David Fetter | 2014-06-02 03:46:34 | == PostgreSQL Weekly News - June 01 2014 == |