s2x 1.1 released (SQL to Anything)

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

Browse pgsql-announce by date

  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 ==