RE: Talking with other Dbases.

If memory serves me correctly, Virtuoso (OpenLinkSW) and AOLserver both claim
inter-database connections.

>===== Original Message From "Mitch Vincent" <mitch(at)venux(dot)net> =====
>> Hi,
>>
>> I'm pretty new to PgSQL (been lurking) and am wondering if
>> it's possible to talk with other DB's easily? I'm using
>> FreeBSD atm and the project I'm working on will be moving
>> from dbase to postgres in the next release. It will also
>> have a web based side to it that I plan on using MySQL for
>> possibly, since all it's going to do is return records.
>> (I have yet to do some testing between postgres and mysql
>> to determine if pgsql would be sufficient or mysql would
>> work better).
>
>If you're talking about connecting to another RDBMSs from within PostgreSQL
>I suppose it would be possible with custom written functions (since most
>RDBMSs have a C API) but it being easy depends on your level of experience
>with C (and the two database APIs)..
>
> > Is it possible to write data to other databases? Also
>> is it possible to get a secure connection between 2 postgres
>> databases, or other databases for that matter? Either through
>> ssh or Kerberos(sp?) etc etc.
>
>You can tunnel virtually anything through SSH, sure.
>
>I know MySQL is fast but just remember, it's just "A filesystem with an SQL
>interface" -- that's ALL... :-)
>
>-Mitch