Page 1 of 2
PostGreSQL questions
Posted: Sat Nov 25, 2017 3:46 pm
by rdonnay
I tried working with PostGreSQL a few years ago and found that the ISAM simulation via PGDBE was just not ready to advise my customers that they should use it instead of ADS.
Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.
So I installed PostGreSQL 8.3.7 on my Windows 10 workstation. This is the installation provided by Alaska Software on their website. I noticed that the pgAdmin III that came with the installation (1.8.4) does not look at all like the screens shown in the Alaska documentation. It appears to be much older.
Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?
Re: PostGreSQL questions
Posted: Sat Nov 25, 2017 4:10 pm
by Auge_Ohr
rdonnay wrote:Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.
and what about communicate with Alaska ...
what does communication have to do with (bad) Performance of PgDBE ?
is any Guy of Alaska a PostgreSQL "Expert"
try to ask in SQL Forum about Concept of "ISAM Emulation" ...
they just will answer "who was the BEGINNER" who made the Concept
rdonnay wrote:Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?
PostgreSQL 10.1 "native" (Phil Ide 2003)
Re: PostGreSQL questions
Posted: Sun Nov 26, 2017 10:55 am
by rdonnay
and what about communicate with Alaska?
That has always been my biggest complaint about Alaska.
Their support forum, especially. It doesn't exist.
The only reason I'm looking into PostGreSQL now is because I am being pulled in that direction from customers.
This is the last thing I want to be doing, but maybe I can be of some help.
Re: PostGreSQL questions
Posted: Mon Nov 27, 2017 8:49 am
by PedroAlex
rdonnay wrote:I tried working with PostGreSQL a few years ago and found that the ISAM simulation via PGDBE was just not ready to advise my customers that they should use it instead of ADS.
Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.
So I installed PostGreSQL 8.3.7 on my Windows 10 workstation. This is the installation provided by Alaska Software on their website. I noticed that the pgAdmin III that came with the installation (1.8.4) does not look at all like the screens shown in the Alaska documentation. It appears to be much older.
Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?
Hello!
I have some stuffs in remote mode
PostgreSQL 9.5 and pgAdmin III or pgAdmin 4 v2.
I have PostGre DB installed on a Win SVR2012 and my app acess data remotely.
I have workstations runing on Win7 and Win10
I works fine for me.
Re: PostGreSQL questions
Posted: Mon Nov 27, 2017 8:57 am
by rdonnay
I have workstations runing on Win7 and Win10
I works fine for me.
Are you using PGDBE or ODBCDBE (or maybe SQLexpress) ?
Are you working in ISAM mode or all SQL statements?
Re: PostGreSQL questions
Posted: Mon Nov 27, 2017 10:14 am
by patito
Hi Roger
The easiest way is to use the api postgresql
Native mode is much faster and easier to implement
Attached example using express , and wrapper ot4xb the Pablo
Best regard
Hector Pezoa
Re: PostGreSQL questions
Posted: Mon Nov 27, 2017 10:51 am
by rdonnay
Ok, I see what you are doing here.
This is a bit like SQLexpress.
It does not use Workareas.
I agree that this is a faster method but I'm trying to help customers with a PostGreSQL migration strategy for large applications.
Re: PostGreSQL questions
Posted: Tue Nov 28, 2017 11:33 am
by rdonnay
The easiest way is to use the api postgresql
I promised Steffen that I would work with the PGDBE. I intend to write a generic client program that allows me to connect to any database and execute SQL statements.
I'm trying to just get a list of databases. This works in pgAdmin but I don't know how to make it work in Xbase++:
select datname from pg_database where datistemplate = false
Re: PostGreSQL questions
Posted: Tue Nov 28, 2017 12:22 pm
by Auge_Ohr
try
Code: Select all
::cQuery := "SELECT table_name FROM information_schema.tables " + ;
"WHERE table_schema = 'public'"
.or.
Code: Select all
::oR_Table := oPG:Select( "pg_tables",, "schemaname = 'public'" )
METHOD PGSql:Select( cTable, cField, cWhere, cOrder, cLimit, cOffset )
Re: PostGreSQL questions
Posted: Tue Nov 28, 2017 12:53 pm
by rdonnay
This doesn't even compile:
Code: Select all
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'
My question is how to do this with PGDBE and the SELECT command.
You have apparently created a different interface to PostGreSQL.