ADS vs PG

[unixkd]

Hi all

A lot have been said about ads and postgresql most especially on this vibrant forum.

I am just been curious, are there comparable reason for want to choose one over the other for a large enterprise projects.

Thanks

Joe

[Tom]

Hi, Joe.

ADS has reached EoL twelve (!) years ago. Meanwhile, it's hard to buy licenses, and this may get harder. Modern operating systems are not officially supported, since they were not known when the development stopped. On the technology side, ADS is more than just outdated. It's technology from the nineties. In shorter words: Bad idea. Don't use the ADS.

PG is a robust, fast, very good and extremely cheap (costs: zero) modern SQL-server. The question is not whether to use it or not, but how to use it. You have a wide range of models, starting at the ISAM-emulation with the PGDBE and ending at direct, native use of SQL. You may begin with PGDBE and end with native use.

[rdonnay]

ADS is a very reliable solution for both ISAM and SQL, however Tom is right that there will be no support in the future.

If you are interested in updating an existing application to Client/Server, with SQL and ISAM capabilities, PostGreSql via PGDBE is finally ready for prime time.
This has been a Hurculean effort by the Alaska team over many years of development and was much more difficult to develop than ADSDBE.
The ADS database server was always ISAM where the PostGreSql database server was always SQL, so implementing ISAM in PGDBE was not easy to do, yet Alaska did it.

[Auge_Ohr]

hi,

PG is a robust, fast, very good and extremely cheap (costs: zero) modern SQL-server.

You may begin with PGDBE and end with native use.

to use PGDBE you have to pay extra Lizence so it is NOT "free".
Only when use Postgre "native" it is "free"

[Tom]

The PostGreSQL server is for free.