Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

For a beginner, is there much difference between MySQL and PostgreSQL [closed]

IS there much difference between MySQL and PostgreSQL for a beginner like me, using basic select statements and the like, or are the main differences with using more advanced queries?

like image 926
user476145 Avatar asked Oct 30 '10 16:10

user476145


People also ask

Should I start with MySQL or PostgreSQL?

In general, PostgreSQL is best suited for systems that require execution of complex queries, or data warehousing and data analysis. MySQL is the first choice for those web-based projects which require a database merely for data transactions and not anything intricate.

Is MySQL or Postgres easier?

If you're looking for an easy, fast, and popular database that will be reliable and easy to understand, MySQL may be the better option. But if you're looking for a much larger database or more features and complexity, PostgreSQL may be the better choice.

Do I need to learn SQL before PostgreSQL?

Different SQL dialects Popular dialects include MySQL, SQLite, and SQL Server, but we recommend starting with PostgreSQL—it's the closest to standard SQL syntax so it's easily adapted to other dialects. Of course, if your company already has a database, you should learn the compatible dialect.

Is MySQL easy for beginners?

MySQL is the world's most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use.


1 Answers

The reason why I usually suggest PostgreSQL before MySQL is because MySQL is far from the standards (SQL-wise). It does not support the use of window functions (8.4 version), common table expressions (8.4), CHECK constraints, EXCEPT/MINUS operator, even FULL OUTER JOINs... Even though you may have never heard of these words, you'll have to use those concepts at some point.

I strongly suggest you to start with PostgreSQL, then you can learn what "real" SQL is. Then, you can decide if MySQL is sufficient or not.

P.S. I started with MySQL and I regretted it. I now use PostgreSQL and I love it.

like image 178
Vincent Savard Avatar answered Oct 26 '22 19:10

Vincent Savard