From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Daryl Chance" <dchance(at)valuedata(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Talking with other Dbases. |
Date: | 2000-09-28 15:21:16 |
Message-ID: | 009e01c0295f$bf0e6f00$0200000a@doot |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Daryl Chance | 2000-09-28 15:23:07 | Fw: Talking with other Dbases. |
Previous Message | Tom Lane | 2000-09-28 15:20:55 | Re: detecting NULL column in SPI function |