mORMot Open Source

EgonHugeist

Member

From: Germany

Registered: 2013-02-15

Posts: 190

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

Is BinaryWireResultMode true by default?
Should we enable it?

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

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...
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?

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

I may add a way to remove /* */ comments in any kind of SQL... But the ? as part of the table/column name - no thanks!
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.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,205

Website

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

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

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,539

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)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,205

Website

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

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

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,539

Website

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

Verified - works as expected. Thanks!