Re: PostgreSQL and Firebird comparison via digg

Abdullah Kauchali wrote:
"Antti Kurenniemi"
"Ability to query databases on other servers local or remote" - that's a no-no for security reasons, don't want that!

Have you never used Linked Servers on SQL Server? Very convenient.



It's very convenient and fairly important for a Enterprise application.

For example, where I work we have a lot of vendor supplied M$ SQL servers. I like to do all my internal work in PGSQL as it's a waste of money to buy expensive M$ SQL licenses for the stuff we need internally.
Even MySQL can handle that for 99% of internal apps.

By using DBLINK_TDS, which provides access to MS SQL server from PostgreSQL I can pull in any data I need from the vendor supplied apps and write all my business logic in PLpgSQL stored procs/functions.

It's certainly not a no-no for security reasons.
.