How different is PostgreSQL from MySQL?

Question

I was asked to support and accept the PostgreSQL application, but am I a MySQL guy - is this a realistic task?

Answer 1

PostgreSQL has some nice features like generate_series , custom aggregate functions, arrays, etc. that can make your life much easier if you take some time to learn them.

On the other hand, it lacks some MySQL functions, such as using and assigning session variables in queries, FORCE INDEX , etc., which is rather unpleasant if you are used to these functions.

If you just use basic SQL , you are unlikely to notice any difference.

Answer 2

How different is PostgreSQL from MySQL?

It depends if you are talking only about SQL (which is basically the same) or about stored procedures (which are completely different).

Is this a realistic task?

That's right. PostgreSQL has very good documentation and community. There are also many ppl who have experience with MySQL and PostgreSQL.

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

Answer 3

PostgreSQL compared to MySQL is like any other DBMS pair. What they have in common is non-functional, in particular, the consequences of each of them are open. In terms of capabilities, uses and strengths, they are no closer to each other than PostgreSQL, Oracle or DB2 refers to Sybase.

Now to your real question: you are a SQL guy , although one who has not yet had experience with PostgreSQL. This is a completely realistic task for you and good, because you will expand your understanding of the DBMS varieties and get an idea of ​​MySQL that you cannot work with, working exclusively in your field.

As someone who was once in the same position, I assume that you quickly pick up PostgreSQL and may even be embarrassed to return to MySQL; -).

Answer 4

You can take a look at these pages: Why PostgreSQL instead of MySQL: Comparison of reliability and speed in 2007 , Why PostgreSQL instead of MySQL 2009 .

Answer 5

If you are interested in various SQL options, here are a few resources (although some may be deprecated):

• SQLZoo
• Wikibook SQL Dialog Reference
• Tips for writing portable SQL
• Bible sql

Answer 6

I faced the same situation about a month ago ... I did a great job with postgres. There is a strong online community for postgres and you should be able to find help if you run into any problem and learn easily :)

Answer 7

It didn't take me long to switch from MySQL to PostgreSQL when I first started using PostgreSQL in the wrath of the previous company. I found this very beautiful and very refreshing (not that MySQL was bad) compared to the MySQL that I used earlier. PostgreSQL was also a good step for Oracle, which I use in my current company. I liked that he had a suitable command line application such as MySQL, but the configuration options are more complicated, but if you do not configure it, then there is no problem.