More PGDBE questions

[rdonnay]

have you try to send more that 1 x INSERT to use full CACHE Power
i can send more than 8 x INSERT using ";" in oPG:exec( cIns ) to speed up UPSIZE

I am still using Alaska's DbfUpsize() function.
We don't have the source for that function, so I don't know how they are handling the INSERTs when upsizing.
Are you saying that you wrote a replacement for DbfUpsize() ?
Can you share some code? Is oPG a DacSession()? There is no exec() method in DacSession.

[Auge_Ohr]

hi Roger,

I am still using Alaska's DbfUpsize() function.
We don't have the source for that function, so I don't know how they are handling the INSERTs when upsizing.
Are you saying that you wrote a replacement for DbfUpsize() ?

YES , i do not use any ALASKA PG Stuff and still on v1.9.355

i do use native Way using OT4XB and LIBPG.DLL direct to UPSIZE DBF into PostgreSQL.
i have to look how i can make a small Sample as the UPSIZE CODE is part of my PGU Util

[Tom]

No, Jimmy did not write a replacement for Alaska's DbfUpsize. He never used this or the PGDBE.

[unixkd]

I had always believed that pgdbe is a misadventures and unnecessary.

SQL Express or powersql is the way to go.

Features like ability to use .net and vcl components would be more useful than this road to nowhere called pgdbe.

I use sqlexpress and loved it. Cut my codes in reporting by more than 40 percent and pretty fast too.

Migrating to sqlexpress is pretty simple and straightforward.

I wonder why Roger is waisting his time on the so call pgdbe

Joe

[rdonnay]

I wonder why Roger is waisting his time on the so call pgdbe

I will let you know when I feel like I am wasting my time.
I have 6 more weeks to evaluate PostGreSql, PGDBE, the client's application and commitment, and Alaska's commitment before I recommend PGDBE as a short-term solution, a long -term solution, or no solution.

In my programming career, I have had many experiences of when I had to face reality.
25 years ago, many people said that Xbase++ was a dead end, and also ADSDBE.
After Clipper 5.2, it took me very little time to realize that Visual Basic, Clipper 5.3, Visual Objects, and many others were a waste of time when needing to migrate large Clipper projects to Windows.
I also stay clear from as many 3rd-party products as I can. I will use them, temporarily, until Alaska provides a better solution.
This was true for Xb2net, JazzAge ActiveX, and others that were retired over time.
If I can do the job with 100% Xbase++ and a few ActiveX controls I find that I am always more successful and productive, in the end, and it will not lead my clients down a rabbit hole.

The Medallion program has been running successfully, managing New York City taxis, for over 25 years with no downtime due to Xbase++ or ADSDBE failures.
The New York Court system has been running 1200 Municipal courts using an Xbase++ / eXpress++ for over 25 years.
Now they are needing a robust Client/server solution and are wanting me to evaluate PostGreSQL and PGDBE.
So far, I have seen no deal breakers. Upsizing existing data at 1200 locations does not look like it will be a problem but may be a challenge.
If I have to bypass DbfUpsize on some of the tables, I will do it in 100% Xbase++ code.

As far as wasting time is concerned, I know whom, on this forum, has been a waste of my time.

[Auge_Ohr]

hi Roger,

where to send the Sample to ?

i have try to send to : 'Support@Donnany-Software.com'
but got Error Message

greetings Jimmy
Auge_Ohr@Web.de

[Wolfgang Ciriack]

Hi Jimmy,
it is donnay not donnany.

[Auge_Ohr]

hi,

it is donnay not donnany.

Thx,
i see i made a Typo in Mail-Adresse

[Tom]

i do use native Way using OT4XB and LIBPG.DLL direct to UPSIZE DBF into PostgreSQL.

This is not the same kind of "upsizing" as the Alaska DbfUpsize does. You are just migrating tables to PostGres. This is useless for an application based on the PGDBE.

[Tom]

I had always believed that pgdbe is a misadventures and unnecessary. SQL Express or powersql is the way to go.

I can't understand why this "my church is the better" bullshit keeps coming up. It's not about which stupid church is the better one. It's about pragmatic solutions for a concrete, worldly task.