vibe-d-postgresql 2.0.1-alpha.1

PostgreSQL support for Vibe.d


To use this package, run the following command in your project's root directory:

Manual usage
Put the following dependency into your project's dependences section:

PostgreSQL support for Vibe.d

API documentation

Please help us to make documentation better!

Example:

module vibe.db.postgresql.example;

import vibe.d;
import vibe.db.postgresql;

PostgresClient client;

void test()
{
    auto conn = client.lockConnection();

    try
    {
        immutable result = conn.execStatement(
            "SELECT 123 as first_num, 567 as second_num, 'abc'::text as third_text "~
            "UNION ALL "~
            "SELECT 890, 233, 'fgh'::text as third_text",
            ValueFormat.BINARY
        );

        assert(result[0]["second_num"].as!PGinteger == 567);
        assert(result[1]["third_text"].as!PGtext == "fgh");

        foreach (val; rangify(result[0]))
            logInfo("Found entry: %s", val.as!Bson.toJson);

        import core.memory;
        GC.collect();
    }
    catch(ConnectionException e)
    {
        conn.resetStart();
        logWarn(e.msg);
    }
    catch(Exception e)
    {
        logWarn(e.msg);
    }
}

static this()
{
    // params: conninfo string, maximum number of connections in
    // the connection pool
    client = new PostgresClient("dbname=postgres user=postgres", 4);

    test();
}

Output:

Found entry: 123
Found entry: 567
Found entry: "abc"
Authors:
Sub packages:
vibe-d-postgresql:example
Dependencies:
dpq2, vibe-d:core
Versions:
3.1.3 2023-Apr-13
3.1.2 2022-Dec-06
3.1.1 2022-Aug-23
3.1.0 2022-May-25
3.1.0-rc.1 2020-Sep-07
Show all 69 versions
Download Stats:
  • 38 downloads today

  • 153 downloads this week

  • 695 downloads this month

  • 51070 downloads total

Score:
4.0
Short URL:
vibe-d-postgresql.dub.pm