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?
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.
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.
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.
MySQL is the world's most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With