In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/01 Report--
This article focuses on "what are the reasons for choosing PostgreSQL instead of MySQL". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the reasons for choosing PostgreSQL over MySQL?"
The current version of MySQL/MariaDB is 5.7.6 (MariaDB is a MySQL branch created by Monty Widenius, the creator of MySQL), and the version of PostgreSQL is 9.4.1. Bolton compares the latest versions of the two from the following aspects:
ANSI standards compatibility: MySQL has come a long way from previous versions, but the philosophy behind MySQL is that if customers like it, they will support non-standard extensions, while PostgreSQL builds standards into the platform from the beginning. However, the two have the same goal, and there is little difference between them.
ACID compliance: PostgreSQL has one storage engine and MySQL has nine, but only MyIsam and InnoDB are relevant to most users, where the latter is the default storage engine. Both InnoDB and PostgreSQL fully follow ACID, with little difference
Lock-free table modification: MyIsam uses table-level locks to speed up, which results in write mutexes. However, both PostgreSQL and InnoDB use row-level locks, with little difference.
Subquery: this has been a weakness of MySQL for a long time. Although 5.6.5 has been greatly improved, PostgreSQL supports table joins better, especially MySQL does not support all external joins. Therefore, PostgreSQL is better than MySQL in this respect.
JSON support and NoSQL:PostgreSQL have recently added JSON support, which provides greater data storage flexibility than traditional relational databases, so PostgreSQL is better than MySQL in this respect.
In addition, Bolton points out that there are the following reasons for choosing PostgreSQL:
Better license: PostgreSQL uses a license agreement similar to MIT, which allows developers to do anything, including commercial use in open source or closed source products, while MySQL clients follow the GPL license agreement, so developers must pay Oracle or open source their own applications.
Better data consistency: PostgreSQL performs strict validation before data insertion and update to ensure that the data is legal, but in MySQL, developers need to set the server to strict SQL mode to achieve the same goal, otherwise irregular data may be generated
Server extensions: MySQL provides the plug-in API, which supports CCompact + or any C-compliant language, and supports full-text search starting from version 5.7.3. PostgreSQL has a similar system but supports more languages, including CCompact +, Java, .net, Perl, Python, Ruby, Tcl, ODBC, etc. It can even run user-provided code in a separate process. In addition to the general information about databases, tables, and columns that all relational databases contain, PostgreSQL system catalogs can also contain information about data types, functions, and access methods that developers can extend by modifying this information.
At this point, I believe you have a deeper understanding of "what are the reasons for choosing PostgreSQL instead of MySQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.