Re: Using PostgreSQL with MySQL - Mailing list pgsql-general

From David Blomstrom
Subject Re: Using PostgreSQL with MySQL
Date
Msg-id CAA54Z0gus3HLHyunUosQa6atrfE-0Ov6qh5nB0QqZABU4e2ATw@mail.gmail.com
Whole thread Raw
In response to Re: Using PostgreSQL with MySQL  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Oh my God, Whatcom County. I went to school in Bellingham years ago, when the population was just 50,000. It was such a beautiful place, I'd be afraid to go back. ;)

Thanks for the tips.

On Sun, Oct 25, 2015 at 10:46 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/25/2015 09:37 AM, David Blomstrom wrote:
I've already learned that I can install and use MySQL and PostgreSQL
simultaneously on my laptop, though I haven't yet learned how to connect
to my Postgre database from a web page, write a query, etc. So here's
what I'm planning...

FYI, the short version of the name is Postgres.


I have several big, complex websites driven by a MySQL database. I'd
like to install PostgreSQL online and use it alongside MySQL in a
limited way, until I have time to learn it more fully and upgrade my
database tables and queries. Are there any major snags or pitfalls you
can see in such an arrangement?

Well you could go the FDW(Foreign Data Wrapper) route:

https://wiki.postgresql.org/wiki/Fdw#Foreign_Data_Wrappers

Though that is a later chapter thing.


I work night shift and am going to be overwhelmed during the holiday
season. I'm hoping to get a major website(s) upgrade published before
Thanksgiving. So I'm hoping to hire someone to help me get up to speed -
create one table the proper way, make a connection and query, then
recreate everything online.

Do you think there are people in the community who'd be willing to do
something like that for $100? I don't think it would take more than an hour.

I've found a Seattle PostgreSQL Users Group, but there's no contact
information, and they only meet once a month - at night. So I can't make
their meetings, unless I slip in for the first half hour or so.

Well if you find yourself heading North you might see what is on the docket at Whatcom PostgreSQL(http://www.meetup.com/Whatcom-PostgreSQL/). We meet at night also so it may not work, but it is another source of local contacts.


Anyway, I just wondered what kind of resources are available for this
sort of thing.

This mailing list is probably the best place to start. Ask a question, there will someone that has done it or has an opinion on how to do it:)


Thanks.


--
Adrian Klaver
adrian.klaver@aklaver.com



--
David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
www.geobop.org

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using PostgreSQL with MySQL
Next
From: Adrian Klaver
Date:
Subject: Re: Recursive Arrays 101