Using PostgreSQL with MySQL
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...
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?
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.
Anyway, I just wondered what kind of resources are available for this sort
of thing.
Thanks.
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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