Zeoslib Portal

Jan,

Thank You for Your support. At least we remove cwstring require from our new library.
So problem is not resolved but not exists at this moment. I hope we will have spare time for this problem return.

Best regards.

Hello Jan,

I use plain fpc 2.6.4. Tomorrow I try 3.0.2 and I try to make testcase. What kind of test console app will be best ?
This is utf/ansi conversion problem so console entered data depends of console settings. National data at source code ?
I can’t make gui app.

Hello, My new library request to add cwstring unit to uses statement. It is unix os - freebsd. After cwstring uses add my zeos connection writes wrong national data. Reading is correct but writing is corrupted. I tried latest 7.2.4. Without cwstring add everything works fine. Any suggestion please ?...

Ok
I'll try this but this is old stuff and perhaps there can be problems with Metadata turned off.

But my performance tests was with metadata turned on in both cases.
Do You mean that Metadata feature is slower in newer ZEOS versions ?

Regards

Hi,

Tested in sample app:
Turning UseMetadata to False reduce loading time but version difference is still present:

ZEOS 7.0.6 - Load data - was 47,674 s - is 40,453 s
ZEOS 7.1.4 - Load data - was 59,327 s - is 53,265 s

Regards

Hi, I prepared simple demo with sql database script. "Create data" buton insert demo data to database. It tooks some time - about 10 minutes. "Load data" makes simple SELECTS on inserted data. Delphi XE7 32 bit PostgreSQL 9.4 Windows 7 64 bit Intel i7 2.8 GHz 12 GB RAM ZEOS 7.0.6...

Hi, Several days ago we switch to 7.1 Zeos Lib at Delphi XE7 (before it was 7.0.3 at Delphi 2010). After upgrade our customers asked us about poor application performace. After some test we found Zeos Lib speed malfunction. We made simple tests (XE7) at 7.0.6, 7.1 and last SVN 7.2. It was very simpl...

Jan !!
Thank You very much !

It looks like everything is ok. This patch is probably not for 7.1 but i did changes manually and my code passed few tests.
I'l be testing next few days - if something will be wrong i'll make a call

Thanks Jan again.

Regards Jaromir

Hello, Recently i upgrade from Delphi2010 to XE7. I used Zeos 6 before but now i had to switch to 7.1 stable release. After upgrade i have problem with tableoid postgresql tables hidden column. Simple example: CREATE DATABASE test_zeos; CREATE TABLE table_a ("int" integer, text text); When...

Hi, From a few days i tried to resolve zeos problem with PostgreSQL VARCHAR type columns. In Zeos 7 it works ok (tested only on DELPHI) but in 6.6.6 not. In connection with PostgreSQL 8 there is a problem with string fields length on columns VARCHAR. DB is UTF8 and everything is OK until you have VA...

It seems that solution is like above: DBConnection.Properties.Clear; DBConnection.Properties.Add('codepage=UTF8'); DBConnection.Properties.Add('client_encoding=UTF8'); Even if you have DB encoded for example in WIN1250 (as me). I think that with above properties there is online reencoding from WIN12...

Hi, I have a problem with zeos in Delphi 2010. Environment: Delphi 2010, Zeos 7 (SVN 794), PostgreSQL (latest 8.4) I'm sorry for image but it's simplest for me: http://www.sunsoft.pl/tmp/ZeosBug.gif Picture has upper and lower parts. In upper part we have connection to UTF8 database and in lower par...

Thank You Mark for Your support.

Jaromir

Hi mdaems,

It was my mistake. That was FPC 2.2.0 version not 2.2.2. After upgrade to 2.2.2 compile was succesful.

Another my question is:

In windows You need a library: libpq74.dll. Is in FreeBSD system instaled another postgres client so aditionaly library isn't needed ??

Regards:
Jaromir

Hello. I have problem with compile easy sample with zeos using. FPC 2.2.2. Newest zeos version. Problem is in ZTokenizer.pas in line 1093 where is operation String := Strnig + Char In this line i got a error: invalid combination of opcode and operands I understand what does it mean but I don't know ...