dpq2 0.1.4

dpq2

This is yet another attempt to create a good interface to PostgreSQL from the D programming language.

It adds only tiny overhead to the original low level library libpq but make convenient use PostgreSQL from D.

Features

• Arguments list support
• Async queries support
• Reading of the text query results to native D text types
• Representation of the binary query results to native D types
• Text types
• Integer and decimal types (except "numeric")
• Timestamp type (with and without timezone)
• Access to PostgreSQL's multidimensional arrays
• LISTEN/NOTIFY support

Building

Bindings for libpq can be static or dynamic.

The static bindings are generated by default. Add --config=dynamic to the dub parameters to generate dynamic bindings.

Example

####Source

#!/usr/bin/env rdmd

import dpq2.all;
import std.stdio: writeln;

void main()
{
    Connection conn = new Connection;
    conn.connString = "dbname=postgres";
    conn.connect();

    // Only text query result can be obtained by this call:
    auto s = conn.exec(
        "SELECT now() as current_time, 'abc'::text as field_name, "
        "123 as field_3, 456.78 as field_4"
        );
    
    writeln( "Text query result: ", s[0][3].as!PGtext );
    
    // Separated arguments query with binary result:
    queryParams p;
    p.sqlCommand = "SELECT "
        "$1::double precision, "
        "$2::timestamp with time zone, "
        "$3::text, "
        "$4::text, "
        "$5::integer[]";
    
    p.args.length = 5;
    
    p.args[0].value = "-1234.56789012345";
    p.args[1].value = "2012-10-04 11:00:21.227803+08";
    p.args[2].value = "first line\nsecond line";
    p.args[3].value = null;
    p.args[4].value = "{1, 2, NULL}";
    
    auto r = conn.exec(p);
    
    writeln( "0: ", r[0][0].as!PGdouble_precision );
    writeln( "1: ", r[0][1].as!PGtime_stamp.toSimpleString );
    writeln( "2: ", r[0][2].as!PGtext );
    writeln( "3 isNULL: ", r[0].isNULL(3) );
    writeln( "4.1: ", r[0][4].asArray.getValue(1).as!PGinteger );
    writeln( "4.2: ", r[0][4].asArray.isNULL(0) );
    writeln( "4.3: ", r[0][4].asArray.isNULL(2) );
}

####Compile and run:

$ cd example
$ dub build --build=release
$ sudo -u postgres ./dpq2-example
Text query result: 456.78
0: -1234.57
1: 0013-Oct-05 03:00:21.227803Z
2: first line
second line
3 isNULL: true
4.1: 2
4.2: false
4.3: true

TODO

• PostGIS binary data support
• Checking types by Oid
• Row by row result reading
• Binary arguments types