www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - What is PostgreSQL driver is most stable?

reply Suliman <evermind live.ru> writes:
I need to develop App that should work on Linux and Windows. It 
need PostgreSQL driver. I tried Vadim's ddbc for PostgreSQL but 
it's fail on x64 version of PostgreSQL and possible will not on 
x64 PG on Linux (I can't test it now).

Could anybody advice me good driver without problems? I seen some 
pg-wrapers on code.dlang.ru, but do not have test all of them.
Mar 14
next sibling parent Daniel Kozak via Digitalmars-d-learn <digitalmars-d-learn puremagic.com> writes:
Dne 14.3.2017 v 14:13 Suliman via Digitalmars-d-learn napsal(a):

 I need to develop App that should work on Linux and Windows. It need 
 PostgreSQL driver. I tried Vadim's ddbc for PostgreSQL but it's fail 
 on x64 version of PostgreSQL and possible will not on x64 PG on Linux 
 (I can't test it now).

 Could anybody advice me good driver without problems? I seen some 
 pg-wrapers on code.dlang.ru, but do not have test all of them.
ddbc works fine for me
Mar 14
prev sibling next sibling parent reply Paolo Invernizzi <paolo.invernizzi gmail.com> writes:
On Tuesday, 14 March 2017 at 13:13:31 UTC, Suliman wrote:
 I need to develop App that should work on Linux and Windows. It 
 need PostgreSQL driver. I tried Vadim's ddbc for PostgreSQL but 
 it's fail on x64 version of PostgreSQL and possible will not on 
 x64 PG on Linux (I can't test it now).

 Could anybody advice me good driver without problems? I seen 
 some pg-wrapers on code.dlang.ru, but do not have test all of 
 them.
I'm using ddb [1], a full-D implementation of the PostgreSQL protocol. Not everything it's in place, but it does its works, and the codebase is pretty simple, so it's not difficult to contribute if you need to add some feature that's missing for your use case. [1] https://github.com/pszturmaj/ddb --- Paolo
Mar 14
parent reply Suliman <evermind live.ru> writes:
On Tuesday, 14 March 2017 at 13:21:39 UTC, Paolo Invernizzi wrote:
 On Tuesday, 14 March 2017 at 13:13:31 UTC, Suliman wrote:
 I need to develop App that should work on Linux and Windows. 
 It need PostgreSQL driver. I tried Vadim's ddbc for PostgreSQL 
 but it's fail on x64 version of PostgreSQL and possible will 
 not on x64 PG on Linux (I can't test it now).

 Could anybody advice me good driver without problems? I seen 
 some pg-wrapers on code.dlang.ru, but do not have test all of 
 them.
I'm using ddb [1], a full-D implementation of the PostgreSQL protocol. Not everything it's in place, but it does its works, and the codebase is pretty simple, so it's not difficult to contribute if you need to add some feature that's missing for your use case. [1] https://github.com/pszturmaj/ddb --- Paolo
Does it work fine on Linux with x64 Postgres?
Mar 14
parent reply Paolo Invernizzi <paolo.invernizzi gmail.com> writes:
On Tuesday, 14 March 2017 at 13:32:31 UTC, Suliman wrote:
 On Tuesday, 14 March 2017 at 13:21:39 UTC, Paolo Invernizzi 
 wrote:
 On Tuesday, 14 March 2017 at 13:13:31 UTC, Suliman wrote:
 [...]
I'm using ddb [1], a full-D implementation of the PostgreSQL protocol. Not everything it's in place, but it does its works, and the codebase is pretty simple, so it's not difficult to contribute if you need to add some feature that's missing for your use case. [1] https://github.com/pszturmaj/ddb --- Paolo
Does it work fine on Linux with x64 Postgres?
Yes --- Paolo
Mar 14
parent reply Dsby <dushibaiyu yahoo.com> writes:
On Tuesday, 14 March 2017 at 16:24:31 UTC, Paolo Invernizzi wrote:
 On Tuesday, 14 March 2017 at 13:32:31 UTC, Suliman wrote:
 On Tuesday, 14 March 2017 at 13:21:39 UTC, Paolo Invernizzi 
 wrote:
 On Tuesday, 14 March 2017 at 13:13:31 UTC, Suliman wrote:
 [...]
I'm using ddb [1], a full-D implementation of the PostgreSQL protocol. Not everything it's in place, but it does its works, and the codebase is pretty simple, so it's not difficult to contribute if you need to add some feature that's missing for your use case. [1] https://github.com/pszturmaj/ddb --- Paolo
Does it work fine on Linux with x64 Postgres?
Yes --- Paolo
We used dpq. http://code.dlang.org/packages/dpq
Mar 15
parent Paolo Invernizzi <paolo.invernizzi gmail.com> writes:
On Wednesday, 15 March 2017 at 08:50:11 UTC, Dsby wrote:
 On Tuesday, 14 March 2017 at 16:24:31 UTC, Paolo Invernizzi 
 wrote:
 On Tuesday, 14 March 2017 at 13:32:31 UTC, Suliman wrote:
 On Tuesday, 14 March 2017 at 13:21:39 UTC, Paolo Invernizzi 
 wrote:
 On Tuesday, 14 March 2017 at 13:13:31 UTC, Suliman wrote:
 [...]
I'm using ddb [1], a full-D implementation of the PostgreSQL protocol. Not everything it's in place, but it does its works, and the codebase is pretty simple, so it's not difficult to contribute if you need to add some feature that's missing for your use case. [1] https://github.com/pszturmaj/ddb --- Paolo
Does it work fine on Linux with x64 Postgres?
Yes --- Paolo
We used dpq. http://code.dlang.org/packages/dpq
I'm curious: ddb does not support yet arbitrary precision numbers [1], does dpq support them? Thanks, Paolo [1] https://www.postgresql.org/docs/9.5/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
Mar 15
prev sibling parent reply Daniel Kozak via Digitalmars-d-learn <digitalmars-d-learn puremagic.com> writes:
Dne 14.3.2017 v 14:21 Daniel Kozak napsal(a):

 Dne 14.3.2017 v 14:13 Suliman via Digitalmars-d-learn napsal(a):

 I need to develop App that should work on Linux and Windows. It need 
 PostgreSQL driver. I tried Vadim's ddbc for PostgreSQL but it's fail 
 on x64 version of PostgreSQL and possible will not on x64 PG on Linux 
 (I can't test it now).

 Could anybody advice me good driver without problems? I seen some 
 pg-wrapers on code.dlang.ru, but do not have test all of them.
ddbc works fine for me
s/ddbc/ddb/
Mar 14
parent reply Suliman <evermind live.ru> writes:
On Tuesday, 14 March 2017 at 13:36:04 UTC, Daniel Kozak wrote:
 Dne 14.3.2017 v 14:21 Daniel Kozak napsal(a):

 Dne 14.3.2017 v 14:13 Suliman via Digitalmars-d-learn 
 napsal(a):

 I need to develop App that should work on Linux and Windows. 
 It need PostgreSQL driver. I tried Vadim's ddbc for 
 PostgreSQL but it's fail on x64 version of PostgreSQL and 
 possible will not on x64 PG on Linux (I can't test it now).

 Could anybody advice me good driver without problems? I seen 
 some pg-wrapers on code.dlang.ru, but do not have test all of 
 them.
ddbc works fine for me
s/ddbc/ddb/
Am I rightn understand that DBRow! is allow to get only single row, and if I need array of rows I need to use foreach? If I am wrong could you provide an example please.
Mar 15
parent reply Paolo Invernizzi <paolo.invernizzi gmail.com> writes:
On Wednesday, 15 March 2017 at 09:18:16 UTC, Suliman wrote:
 On Tuesday, 14 March 2017 at 13:36:04 UTC, Daniel Kozak wrote:
 Dne 14.3.2017 v 14:21 Daniel Kozak napsal(a):

 Dne 14.3.2017 v 14:13 Suliman via Digitalmars-d-learn 
 napsal(a):

 I need to develop App that should work on Linux and Windows. 
 It need PostgreSQL driver. I tried Vadim's ddbc for 
 PostgreSQL but it's fail on x64 version of PostgreSQL and 
 possible will not on x64 PG on Linux (I can't test it now).

 Could anybody advice me good driver without problems? I seen 
 some pg-wrapers on code.dlang.ru, but do not have test all 
 of them.
ddbc works fine for me
s/ddbc/ddb/
Am I rightn understand that DBRow! is allow to get only single row, and if I need array of rows I need to use foreach? If I am wrong could you provide an example please.
The retrieval of records is done via the execution of a (prepared) sql query, that returns a range object (PGResultSet), and the element of that range is the DBRow, in one of its form. So, basically, the elements are retrieved on demand while you popFront that range, leveraging what the PostgreSQL stream protocol provide. --- Paolo
Mar 15
parent Suliman <evermind live.ru> writes:
 The retrieval of records is done via the execution of a 
 (prepared) sql query, that returns a range object 
 (PGResultSet), and the element of that range is the DBRow, in 
 one of its form.

 So, basically, the elements are retrieved on demand while you 
 popFront that range, leveraging what the PostgreSQL stream 
 protocol provide.

 ---
 Paolo
Could you give an example when it's better to use DBRow and where to get data in structure?
Mar 15