pgator 0.3.11

Application server that transforms JSON-RPC calls into SQL queries for PostgreSQL

To use this package, put the following dependency into your project's dependencies section:



Build Status <img align="right" src="pgator.png" /> Stories in Ready Gitter Chat

Application server that transforms JSON-RPC and Web REST calls into SQL queries for PostgreSQL.


Quick start guide

Dlang stuff installation (Debian example)

Since pgator written in the Dlang you will need to install the DMD or LDC2 compiler and the DUB package builder:

$ cat /etc/apt/sources.list.d/d-apt.list 
deb dmd main #APT repository for D
$ sudo aptitude update
$ sudo aptitude install -t unstable ldc dub
pgator downloading and building
$ git clone --depth=1
$ cd pgator
$ dub build --build=release --compiler=ldc2
Example pgator config
		"maxConn": 3,
		"connString": "host= dbname=exampledb user=worker"
	"sqlAuthVariables": {
		"username": "pgator.username",
		"password": "pgator.password"
	"listenAddresses": ["", "::1"],
	"listenPort": 8080,
	"sqlPgatorTable": "pgator_calls"
pgator RPC calls table example

Simple method code that just returns one passed argument:

SELECT method, sql_query, args, result_format FROM pgator_calls WHERE method = 'test.echo';
  method   |            sql_query            |       args       | result_format 
 test_echo | select $1::text as passed_value | {value_for_echo} | CELL
(1 row)
Methods calling:

At first, it is need to start pgator:

$ ./pgator --config=my_pgator.conf 
Number of methods in the table "pgator_calls": 1, failed to prepare: 0
Listening for requests on
Listening for requests on http://[::1]:8083/

(Option --check=true allows to check methods from table without server start.)

Calling a test method described in the previous table in manner JSON-RPC 2.0:

$ curl -X POST -H 'Content-Type: application/json' -H 'Accept: application/json' --data '
    "jsonrpc": "2.0",
    "method": "test_echo",
    "params": { "value_for_echo": "Hello, world!" },
    "id": 1


{"jsonrpc":"2.0","result":"Hello, world!","id":1}

Same method calling using Vibe.d REST client:


interface ITest
    string getTextEcho(string value_for_echo);

void main()
    auto m = new RestInterfaceClient!ITest("");

    assert(m.getTextEcho("Hello, world!") == "Hello, world!");
More methods options

You can find more methods options in the .testpgatorrpc_table.sql file comments

How to run pgator as daemon

Please use systemd, supervisor or somethig like that.

Denis Feklushkin <>
Sub packages:
vibe-d-postgresql, vibe-d:http
0.3.15 2018-Feb-27
0.3.14 2018-Feb-25
0.3.13 2018-Feb-11
0.3.12 2017-Dec-30
0.3.11 2017-Oct-16
Show all 35 versions
Download Stats:
  • 0 downloads today

  • 0 downloads this week

  • 0 downloads this month

  • 119 downloads total