Thread overview | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
March 14, 2017 What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
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. |
March 14, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Suliman | 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
|
March 14, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Suliman | 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 |
March 14, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Paolo Invernizzi | 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?
|
March 14, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
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/
|
March 14, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Suliman | 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
|
March 15, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Paolo Invernizzi | 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 |
March 15, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Dsby | 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 |
March 15, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Daniel Kozak | 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.
|
March 15, 2017 Re: What is PostgreSQL driver is most stable? | ||||
---|---|---|---|---|
| ||||
Posted in reply to Suliman | 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
|
Copyright © 1999-2021 by the D Language Foundation