#51 2020-03-26 11:26:38

EgonHugeist
Member
From: Germany
Registered: 2013-02-15
Posts: 190

Re: SynDBPostgres - implementation of TSQLDB* for Postgres using libpg

ab wrote:

Is BinaryWireResultMode true by default?
Should we enable it?

It is enabled by default and you may disable it for the ColumnToJSON.

ab wrote:

I have and use libpq.so.5 on my Ubuntu system.
Zeos is not able to find it. I have to specify the library name in the connection URI. See https://github.com/synopse/mORMot/blob/ … s.pas#L709
So it depends on the actual system it runs on... smile
On your system, you can specify libpq.so.4 I guess in the SynDBPostgresLibrary global variable.
I have enhanced TSQLDBPostgresLib to automatically try to load the .so.5 then the .so.4 - see https://synopse.info/fossil/info/d0d2158e9f

curious since its added to the plaindriver locations.. Any ideas?

ab wrote:

We won't support *beep* SQL with bulky comments in our unit.
We are not a one-to-one replacement for TDataSet / SQL statements, but support the SQL generated by our ORM, and dedicated clean SQL.
If there is too much SQL to rewrite, with a lot of *beep* comments in it - just skip SynDB and use Zeos.

Not a problem that's why i wrote nouvice state. Just document you do not support *beep" sqls smile

ab wrote:

I may add a way to remove /* */ comments in any kind of SQL... But the ? as part of the table/column name - no thanks! big_smile
The same about 'extended' 80-bit float support - we have a single floating point type, which is double. So we don't have to circumvent this problem.

Maybe a misunderstanding: Those values can not be converted from string into a double.. i get a overflow exception if i use the doubles.

I've uploaded the whole SynDBZeos.pas again, not as patch might be easier 4u. https://www.file-upload.net/download-13 … s.pas.html
please test and apply the changes.

Offline

#52 2020-03-26 17:41:47

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,347
Website

Re: SynDBPostgres - implementation of TSQLDB* for Postgres using libpg

I have included your patches as https://synopse.info/fossil/info/6b4f978839

Offline

#53 2020-04-03 12:08:29

mpv
Member
From: Ukraine
Registered: 2012-03-24
Posts: 1,325
Website

Re: SynDBPostgres - implementation of TSQLDB* for Postgres using libpg

A small patch #301 to SynDBPostgres for loading dll under Windows (thanks @ab and @EgonHugeist for implementing this in Zeos)

Offline

#54 2020-04-03 13:09:19

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,347
Website

Re: SynDBPostgres - implementation of TSQLDB* for Postgres using libpg

Implemented in all SynDB* units via https://github.com/synopse/mORMot/commi … 0a2e895410

Offline

#55 2020-04-03 14:27:31

mpv
Member
From: Ukraine
Registered: 2012-03-24
Posts: 1,325
Website

Re: SynDBPostgres - implementation of TSQLDB* for Postgres using libpg

Verified - works as expected. Thanks!

Offline

Board footer

Powered by FluxBB