PostgreSQL database is on the rise

Postgres is gaining more and more attention

Postgre s is gaining more and more attention. Open Database systems such as Postgre s are in conflict with large, expensive, and irregular "enterprise-level" systems, such as SQL Server and Oracle, to provide the same functions but better. Among all these systems, Postgre s is the smartest, fastest, and most functional.

Postgres is gaining more and more attention. Open Database systems such as ipvs are in conflict with large, expensive, and irregular "enterprise-level" systems, such as SQLServer and Oracle, to provide the same functions but better. Among all these systems, S is the smartest, fastest, and most functional.

S. app

There are some popular sayings about ipvs. app recently. Most people do not understand ipvs. app. Let me explain it briefly.

Postgres can be configured with many interesting options, such as running the geospace information index (PostGIS), creating Ruby and JavaScript methods, and extending the query engine to support remote data such as GMail. these functions all need to be compiled from the source code. This is a painful process, even if you use Homebrew on Mac.

Homebrew captures and compiles the source code based on common configurations. S. app is pre-compiled and runs as a daemon. You can enable or disable it as needed. You just need to download it and drag it to your application directory.

Compare the installation process of SQL Server and Oracle!

This is obviously fascinating. If you are using Mac, you can also use Navicat. There is a free version, you can also play their demo first.

Meet this old friend again

PostgreSQL has existed for a long time. You may be wondering who named it? Tom Lane's explanation is as follows:

The software name is PostgreSQL or PostgreSQL, not Postgre ...... Indeed, PostgreSQL, rather than the simpler Postgres, was decided in 1996 to be the only mistake this project has made so far. But it is too late to change it.

Postgres is ported from an extremely old database system Ingres to create a pluggable, scalable, and fast database system that is user-friendly and intelligent. The name "s" seems to be the project "After Ingres" before the shadow ".

Who cares?

This is critical-Not many people. With the rise of PHP, the "more friendly" MySQL platform is widely used, rather than a more rigorous, rule-based ipvs system. "More friendly" seems to me "more stupid ".

Okay, I admit that my words hurt a lot and I took it back. This video was published on Tekpub and called "MySQL dangerous ". if you don't want to watch the entire video, I will make a summary:

MySQL may ignore your default values or restrictions. Do not be too rigorous to "help you"

If the field cannot be blank, it cannot insert "" to a non-empty field

If the field cannot be blank, it inserts a meaningless date, for example"

1/0 NULL is returned

"This is not a number"/0 returns NULL

If you insert 1000 to a field with a length limit of 2, it will round it to 99.

These are the places where you should be careful when using MySQL. By default, it will not protect your data, but will try to let you pass at the sacrifice of data integrity. It seems silly to me.

If you don't care about this, I have another word for you: Oracle.

Fast, scalable, and interesting

Postgres has many features that most people may not know. It has many syntactic skills:

The keyword "Infinity" means that it is larger than any input number. This can be a number, a date, or a plus or minus sign.

Can recognize keywords such as "today", "tomorrow", and "yesterday"

Surprising data types, such as Arrays and IP addresses (IPv6 supported ). There are also space types, such as line, square, and circle

Data Table inheritance is a strange feature that allows one table to inherit from another table.

Built-in natural language full-text index

More importantly, ipvs is very fast and scalable. I did some tests with my DBA friend Rob Sullivan to load 6 million pieces of text data from StackOverflow. We use Windows machines, which in many cases kill SQL Server in seconds.

Although SQL Server can also partition data tables, you have to pay, not to mention the performance of ipvs is better, and the index is smaller.

If this is not enough, S supports the TOAST data table by default. This is a strange name, short for "Automatic Table Compression. I have demonstrated this in the demo at the end of this article. In addition, ipvs will compress data on your disk to reduce the usage of RAM and disks.

This function reduces the dump data of StackOverflow from 24 GB to 6 GB! Remember that these are provided by Postgres for free, and you must purchase enterprise authorization when using SQL Server.

Five other things you don't know

I still want to post my speech on NDC 2012 "5 Things You Didn't Know About PostgreSQL ":

Query Twitter through Foreign Data Wrappers

Use Google's V8 engine to write JavaScript Functions

Tips for sniping MySQL

Avoid locks and built-in snapshot Functions

Data Table inheritance

Crazy Data Types

I hope you will like it.

Disclaimer: any information indicating the CIO times Network (www.ciotimes.comwww.ciotimes.com) will be held responsible for the violation of this website.

To http://www.ciotimes.com/infrastructure/sjk/68116.html