Shulou(Shulou.com)06/03 Report--

This article mainly shows you "what are the differences between postgresql and mysql". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn the article "what are the differences between postgresql and mysql".

The difference between PostgreSQL and MySQL

Full outer join full outer join: the PostgreSQL full outer join returns all rows from two participating tables, using null padding if they do not match on the opposite table. The full outer join combines the results of the left outer link and the right outer join and returns all rows (matching or mismatching) in the table at both ends of the join subsentence.

Disadvantages of using MySQL (disadvantages of MySQL) transactions related to system directories are not ACID compliant (transactions related to system directories are not ACID compliant) sometimes server crashes may destroy system directories (sometimes server crashes may destroy system directories) there is no pluggable authentication module to prevent centralized management accounts (no pluggable authentication module prevents centralized management accounts) does not support roles Therefore, it is difficult to maintain privileges for many users (roles are not supported, so it is difficult to maintain permissions for many users) stored procedures are not cacheable (stored procedures are not cacheable) tables for procedures or triggers are always pre-locked (tables for programs or triggers are always pre-locked)

Which is better, PostgreSQL or MySQL

Disadvantages of using PostgreSQL (disadvantages of Postgresql) the current external solution requires a higher learning curve (the current external solution requires a higher learning curve) there is no upgrade tool for the major version (there is no major version of the upgrade tool) data needs to be exported or copied to a new version (data needs to be imported or copied to the new version) dual storage (L) is required during the upgrade process Index cannot be used to return query results directly (index cannot be used to return query results directly) query execution plan is not cached (query execution plan is not cached) bulk load operation may be limited by CPU (bulk load operation may be limited by CPU) sparse independent software vendor support (sparse independent software vendor support)

After comparing the two, we can say that MySQL does a great job of improving itself to maintain relevance, but on the other hand, you don't need any license for PostgreSQL. It also provides table inheritance, rule systems, custom data types and database events. Therefore, it must be higher than MySQL.

The above is all the content of the article "what are the differences between postgresql and mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.