How different is PostgreSQL to MySQL? [closed]

C

7

68

I've been asked to support and take on a PostgreSQL app, but am a MySQL guy - is this a realistic task?

Chump answered 7/4, 2009 at 9:46 Comment(0)

E

37

PostgreSQL has some nice features like generate_series, custom aggregate functions, arrays etc, which can ease your life greatly if you take some time to learn them.

On the other hand it lacks some features of MySQL like using and assigning session variables in queries, FORCE INDEX, etc., which is quite annoying if you are used to these features.

If you just use basic SQL, then you will hardly notice any difference.

Epergne answered 7/4, 2009 at 10:0 Comment(0)

N

14

How different is PostgreSQL to MySQL?

That depends if you're talking about SQL only (which is mostly the same) or the stored procedures (which are quite different).

is this a realistic task?

Absolutely. PostgreSQL has very good documentation and community. There are also lot of ppl, who have experience with MySQL and PostgreSQL.

"MySQL vs PostgreSQL wiki" — centers on "which is better", but gives you some idea of differences.

Newburg answered 7/4, 2009 at 9:53 Comment(3)

Link no longer works – Filler 27/12, 2016 at 14:5

The latest copy of the link on Archive.org: web.archive.org/web/20160827010904/www.wikivs.com/wiki/… – Uel 30/7, 2017 at 8:0

Link makes eternal redirection ... – Leotaleotard 8/5, 2018 at 23:33

C

6

PostgreSQL compared to MySQL is as any other pair of DBMSs compared. What they have in common is non-functional, specifically the consequences of each being open source. In terms of features, use, and strengths they are no closer to each other than PostgreSQL is to Oracle or DB2 is to Sybase.

Now on to your real question: you are a SQL guy, albeit one who has not yet had experience with PostgreSQL. This is a completely realistic task for you, and a good one since you'll expand your understanding of the varieties of DBMSs and gain a perspective on MySQL that you can't get from working solely within its sphere.

As someone who was once in exactly the same position, my guess is that you'll quickly pick up PostgreSQL and might even hesitate to return to MySQL ;-).

Caritta answered 8/4, 2009 at 0:26 Comment(0)

R

5

If you're interested in the different flavors of SQL, here are a few resources (though some may be outdated):

Regelate answered 8/4, 2009 at 0:27 Comment(0)

T

3

You may want to take a look at these pages: Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007, Why PostgreSQL Instead of MySQL 2009.

Tetrabrach answered 7/4, 2009 at 10:10 Comment(0)

M

1

I faced the same situation about a month ago.... I have been doing fine with postgres. There is a strong online community for postgres and you should be able to find help if you run into any trouble and learn stuff easily :)

Mennonite answered 7/4, 2009 at 9:52 Comment(0)

L

1

I didn't take very long to switch from MySQL to PostgreSQL back when I first started using PostgreSQL in anger at a previous company. I found it very nice and very refreshing (not that MySQL was bad) compared to MySQL which I had used previously. PostgreSQL was also a good stepping stone to Oracle which I use at my current company. I liked that it had a proper command line application like MySQL, but the configuration options are harder - but if you're not setting it up then there is no problem.

Leanoraleant answered 7/4, 2009 at 10:13 Comment(1)

You could also go for MariaDB now a days. – Karli 8/2, 2018 at 17:30

Recommended topics

Hot tags