PostgreSQL Advantage2016-10-20 21:36 686 People read comments (0) favorite reports Classification:MySQL Database (5)PostgreSQL is a free object-relational database server (database management system), which is very powerful. Includes support for
PostgreSQL is an open-source SQL database that supports standard SQL and allows users to connect to PostgreSQL via the JDBC driver for application development. The user extends the PostgreSQL function, allowing the developer to access the SEQUOIADB
Comparison between PostgreSQL and MySQL
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run multiple mysqld instances.
First, the environmentVM Virtual MachinesName="Ubuntu"VERSION="12.04.4 LTS, precise pangolin" Second, the process1. Install make and do not load now.Install Make Make--3.81 2006 for for I686-pc-linux-gnu2. Get the source codeBut now there is
1. Download the source code
$ mkdir /usr/downloads$ wget -c http://cn2.php.net/distributions/php-5.6.20.tar.gz$ tar -xvf php-5.6.20.tar.gz$ mv php-5.6.20 /usr/local/src$ cd !$ & cd php-5.6.20
2. Read the installation Instructions
$ ls -also$ less
Operating System: Debian 3.0 r2
Kernel used: linux-2.4.23
The module used in the experiment: ipvsadm-1.21, PostgreSQL (detailed usage of ipvsadm command please refer to here)
Function Description: This is a simple experiment on linuxvirtualserver.
MySQL vs. PostgreSQL
MysqlRelatively young, appearing for the first 1994 years. It claims to be the most popular open source database. MySQL is the M in the lamp (for web development packages, including Linux, Apache, and Perl/php/python). Most
PostgreSQL is an object-relational database (database management system) based on the BSD license. Because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for free for any purpose. Simply put, even if you take it
Windows under PostgreSQL installation diagram
This article is mainly for you to introduce the method of installing PostgreSQL database under Windows, you need a friend can refer to the following
Now talk about the free database, most people think
From: http://bbs.chinaunix.net/thread-1688208-1-1.html
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.