express-postgres-sp

This is an Express middleware which provides an HTTP interface to Stored Procedures defined in a PostgreSQL relational database.

In other words, you can code your application's business logic inside the DBMS (using any language supported by Postgres like PL/pgSQL, PL/Tcl, PL/Perl and PL/Python; see here for more details) and use this module to automatically map certain HTTP requests to your Express applications to these functions.

Security note: for security reasons, if you use this module you should setup a dedicated DBMS user/role the module will use to connect with only EXECUTE privileges to the Stored Procedures you want to be publicly accessible over the web and no privileges on other objects (like Stored Procedures that mustn't be accessible to the end user, tables, views, etc).

More documentation will be added soon.