|
Home > Archive > PostgreSQL Discussion > May 2005 > Just a crazy idea!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Just a crazy idea!
|
|
| Hrishikesh Deshmukh 2005-05-26, 8:24 pm |
| Is it possible to connect a DB in Postgresql to a DB in MySQL!
I know its a crazy idea!
H
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Dann Corbit 2005-05-26, 8:24 pm |
| Of course it is possible. In fact, it's easy.
Just use JDBC or ODBC or OLEDB or a .NET provider and join to both
database systems.
There is nothing to it.
I can make a join where tables from RMS and DB/2 and Oracle and
PostgreSQL and MySQL are all participating in the SQL statement with
ease.
This technology is 15 years old.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Hrishikesh Deshmukh
> Sent: Thursday, May 26, 2005 2:05 PM
> To: Postgresql-General
> Subject: [GENERAL] Just a crazy idea!
>
> Is it possible to connect a DB in Postgresql to a DB in MySQL!
> I know its a crazy idea!
> H
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Hrishikesh Deshmukh 2005-05-26, 8:24 pm |
| Could you point to documentation regarding this. This would be a big help.
Thanks,
Hrishi
On 5/26/05, Dann Corbit <DCorbit@connx.com> wrote:
> Of course it is possible. In fact, it's easy.
>
> Just use JDBC or ODBC or OLEDB or a .NET provider and join to both
> database systems.
>
> There is nothing to it.
>
> I can make a join where tables from RMS and DB/2 and Oracle and
> PostgreSQL and MySQL are all participating in the SQL statement with
> ease.
>
> This technology is 15 years old.
>
> broadcast)---------------------------
>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| |
| Dawid Kuroczko 2005-05-26, 8:24 pm |
| On 5/26/05, Hrishikesh Deshmukh <hdeshmuk@gmail.com> wrote:
> Is it possible to connect a DB in Postgresql to a DB in MySQL!
> I know its a crazy idea!
Why, of course. Been' doing that.
All you need is to write a set of functios, for example in PL/perlU,
some of them being set returning functions.
For my purposes I did a function which connects to mysql to
call its encrypt function, and a function which returns "show databases"
and similar stuff.
Basically -- yes you can do it, though things getting tricky if you want
to have _read_ access to _big_ tables. :)
Regards,
Dawid
PS: For the reference, why do you need to connect to mysql?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| |
| Matt Miller 2005-05-26, 8:24 pm |
| On Thu, 2005-05-26 at 17:21 -0400, Hrishikesh Deshmukh wrote:
> I have a little schema in pgsql and some annotation in mysql;
> ...
> if i could make these two talk
> ...
> So the question and frankly i thought it was crazy thought!
> The replys so far indicate that i am not looney at all ;)
Well the replies seem to indicate that the question does have an
affirmative answer. Whether Hrishikesh is looney, however, is probably
still an open question ...
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| |
| Hrishikesh Deshmukh 2005-05-26, 8:24 pm |
| LOL..............not looney!
On 5/26/05, Matt Miller <mattm@epx.com> wrote:
> On Thu, 2005-05-26 at 17:21 -0400, Hrishikesh Deshmukh wrote:
>
> Well the replies seem to indicate that the question does have an
> affirmative answer. Whether Hrishikesh is looney, however, is probably
> still an open question ...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
| |
| Hrishikesh Deshmukh 2005-05-26, 8:24 pm |
| I have a little schema in pgsql and some annotation in mysql; either
way transfer of schema might result in data types etc conflicts. So if
i could make these two talk then i don't have to worry about schema
transfer. So the question and frankly i thought it was crazy thought!
The replys so far indicate that i am not looney at all ;)
Hrishi
On 5/26/05, Dawid Kuroczko <qnex42@gmail.com> wrote:
> On 5/26/05, Hrishikesh Deshmukh <hdeshmuk@gmail.com> wrote:
>
> Why, of course. Been' doing that.
>
> All you need is to write a set of functios, for example in PL/perlU,
> some of them being set returning functions.
>
> For my purposes I did a function which connects to mysql to
> call its encrypt function, and a function which returns "show databases"
> and similar stuff.
>
> Basically -- yes you can do it, though things getting tricky if you want
> to have _read_ access to _big_ tables. :)
>
> Regards,
> Dawid
>
> PS: For the reference, why do you need to connect to mysql?
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)
| |
| David Fetter 2005-05-26, 8:24 pm |
| On Thu, May 26, 2005 at 05:04:37PM -0400, Hrishikesh Deshmukh wrote:
> Is it possible to connect a DB in Postgresql to a DB in MySQL! I
> know its a crazy idea!
It's called DBI-Link.
http://pgfoundry.org/projects/dbi-link/
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
| |
|
|
|
|
|