Re: Talking with other Dbases.

> 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