MySQL vs PostgreSQL

Saying “speed”, “scalability” or “easy to use” without et least mentioning what gives this characteristics in compare is really harmful for the whole industry

Because people will spread this knowledge to one another and this will create and develop technologies that does not deserve to be evolved

Nice explanations !! Thank you for the content!

Postgres embrace the concept of schemas, that are basically bd's inside a singular DB.

using postgres since late 2000. in those 23 years, i had exatly 0 data losses due to the db making a fault. it was always "operator error". scalability is a bit harder to do with postgres maybe, but it's doable (like partitioning tables and distributing partitions over several machines), with additional read replicas to separate read/write load, although your application of course has to send read and write queries to separate instances then. one more interesting fact is that afaik the SQLite project does something called "wwpd" in their test cycles. this reads "what-would-postgres-do", so basically they completely ignore what sqlserver or mysql are doing and instead fix their code until the output is 1:1 that of postgres 😄

I don't think mysql is easier to use if you're not using phpmyadmin. Mysql workbench has the most terrible ui across all the desktop apps i ever saw. Indeed if you want to use with php it's easy but not if you don't, except because of mysql workbench is terribly harder.

mysql is easier to manage.

You should have mentioned MySQL was forked over to Maria db and that oracle will end of life it soon.

Great video! I remember this guy on his other channel, what was his name again? Thanks :)

Great breakdown, very useful! I don't know why but I thought postgres was much newer. Had no idea how mature it really was

nice explanation, thanks

Hey Airbyte, really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience

I only hate the importing features in postgres. Very devastating.
If someone could tell me how to import a very large csv file in Postgres without typing out all the columns, i will be greatful

Good job! This is the 4th video I've seen on this and the first one to mention the licensing. Which is mainly what i wanted to hear. Amazing how hard it is to find the info you want. Thanks for being smarter than average. (Yes i could have read up on current licences for both....but i get tured of reading)

When considering data migration between these systems, your ultimate ally is Airbyte. As the leading open-source ELT tool, Airbyte simplifies the migration process, transforming a complex procedure into an intuitive task for engineers.

Hey what about scalability if using PostgreSQL?

Makasih, Video nya sangat bermanfaat bagi saya, ini akan lebih membantu saya jika anda menambahkan subtitle bahasa Indonesia di video mu

Thankyou this is really helpful