ddb

ddb copied to clipboard

slow query with vibe.d

7

I use ddb in vibe.d project. I updated my project to vibe.d 0.8.3 but my queries is very slow. Any suggestion?

zafer06

exception during tcpConnection.write() and connection pool.

1

This is a following of #71. Unfortunately I'm still having exceptions during the write, as PostgreSQL is disconnecting after some inactivity time: ``` object.Exception@../../../../root/.dub/packages/vibe-core-1.3.0/vibe-core/source/vibe/core/net.d(639): Error writing data to socket. [main(eDjH)...

pinver

Memory allocation failed

15

I am trying to build simple app Windows 10 that produce select query to PG 9.6. But on example I am getting error: `core.exception.OutOfMemoryError@src\core\exception.d(696): Memory allocation failed` I am using...

bubnenkoff

I need to look at result prepared statement. ``` cmd.query = `SELECT ST_POINT($1, $2), 4326 FROM admin)`; cmd.parameters.add(1, PGType.FLOAT8).value = nearestroaddistance.lon; // FLOAT8 = double cmd.parameters.add(2, PGType.FLOAT8).value = nearestroaddistance.lat; writeln(cmd.query);...

bubnenkoff

How can I use transaction with ddb? Is there any example?

zafer06

Slow down on x64 bit mode on Windows

1

App do SELECT queries to PostgreSQL. ``` string sql_distance = `SELECT osm_id, ST_DISTANCE(geometry::geography, ST_SetSRID(ST_POINT(37.72308, 55.47957), 4326), true) as dist FROM roads WHERE (SELECT bool_or(ST_Contains(geometry, ST_SetSRID(ST_POINT(37.72308, 55.47957), 4326))) FROM admin) ORDER...

bubnenkoff

Null values

8

Let's imagine that I have this struct ``` dlang struct V { int x; int y; } // Query auto cmd = new PGCommand(conn, "select x, y from vectors"); auto...

llaine

See https://github.com/pszturmaj/ddb/blob/f45f0ba7961929254e6a63b346b20199e802f422/source/ddb/postgres.d#L1049 This was supposed to be temporary, until I'd finish other parts, but stayed here until now. It needs to be rewritten to reuse the buffer if possible. I...

pszturmaj

in the isNullable template check also against std.typecons.Nullable

1

actually the template fails to return true if a struct is using the std.typecons.isNullable (dmd 2.067.1): ``` D import std.typecons; struct Foo { Nullable!(ubyte[]) bar; } ```

pinver

There are some problems with the Nullable implementation in ddb: 1. The way `Variant` is used, with a `void*` it doesn't compile. It think it's because `null` has its own...

jacob-carlborg