Jump to page: 1 2
Thread overview
What is PostgreSQL driver is most stable?
Mar 14
Suliman
Mar 14
Suliman
Mar 15
Dsby
Mar 19
denizzzka
Mar 15
Suliman
Mar 15
Suliman
March 14
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
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
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
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
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
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
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
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
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
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
« First   ‹ Prev
1 2