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 😄

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

Engineers always telling the world they are engineers. "As an engineer, everyone needs to know I'm an engineer"

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?

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)

Just a few things : - Both MySQL and PostgreSQL are fully ACID compliant. (as you should use InnoDB on MySQL) - PostgreSQL doesn't actually have anything bundled for H.A, you have replication but nothing that would trigger and automatic failover for example like would InnoDB clusters (you have to rely on external tool that Stolon that may or may not work or be supported for long) - You have extensibility on MySQL too (via plugins) - MySQL is superior in some of the core security topics like TDE (Transparent Data Encryption) or credential/password management (with password policies, multiple passwords per user for rotations, etc...) - PostgreSQL MVCC is not an advantage actually, it causes TONS of write amplifications and required maintenance (normally automated with autovacuum), InnoDB is vastly superior on this case. A few issues with MySQL still today : - No UUID type - Triggers would not execute on foreign tables modifications (big issue for some case if you rely a lot on triggers)

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

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

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

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.

Nice explanations !! Thank you for the content!

Very good and relevant video, thank you

Thank you bro. Very helpfull.

nice explanation, thanks

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

Hey what about scalability if using PostgreSQL?

Thankyou this is really helpful

make it simple - MySQL is table based relational db... Posgres is more "object" based relational db.

Thanks for this video - joined as a sub

Great video! I remember this guy on his other channel, what was his name again? 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

Can someone pls guide me, which database is preferable for core banking domain between mssql and postgresql? apart from Oracle.

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

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

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

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

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

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

mysql is easier to manage.