MySQL vs PostgreSQL

Step into the world of MySQL and Postgres with our comprehensive comparison video. We dive deep into their individual strengths and weaknesses, guiding you to the perfect database choice for your needs.

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

[oefzdegoeggl]

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 😄

[FamilyKgpg]

Question:
You said MySQL supports pluggable storage engines - INNODB (ACID compliant) & MyISAM (non-ACID compliant) where Postgres supports only MyISAM
In the explaination of Postgres you said, its full ACID Complient
Isn't that contradicting?

[Kyle-wcso]

Your video broadened my understanding of both databases.
Thank you!

[nicholasbicholas]

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

[truesightgrabber]

I wish to use PostGreSQL more, but MySQL is more advanced, suits to more products (like WordPress) and more documented and supported.

[it-kachalka]

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

[PauloSantosk]

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

[Divy]

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

[rembautimes]

Thanks for this video - joined as a sub

[agashamercy]

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

[timavilla]

I regret spending 10 min on this video, 0 useful technical information, only broad statements, and some of them are not even entirely truthful

[sentzeu]

Yeah I’ll have to downvote this, just saying that MySQL is in general more performant is highly misleading and harmful to the industry.

[jay_wright_thats_right]

It's safe to say Airbyte is slowly going out of business.

[scottfrost]

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

[AirbyteHQ]

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.

[TravisTennies]

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)

[sujayxaradhya]

Hey what about scalability if using PostgreSQL?

[andrewjedi]

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

[anonymeister]

Very good and relevant video, thank you

[aliasafpolat]

Nice explanations !! Thank you for the content!