Python Intermediate--05 Access database

* * Written in front------------------> * *

Database categories

First select a relational database. There are several types of relational databases that are widely used:

Paid Commercial database:

• Oracle: Typical Gaofu;

• SQL Server: Microsoft Home Products, Windows custom earmarked;

• DB2:IBM products, sounds very high-end;

• Sybase: Once with Microsoft is a good friend, then the relationship broke down, now a bleak family.

These databases are not open source and pay, the biggest advantage is that the cost of money out of the problem can find manufacturers to solve, but in the web world, often need to deploy thousands of database servers, of course, can not throw a lot of money to manufacturers, so, whether it is Google, Facebook, Or a domestic bat, without exception, the free open source database is selected:

Free Open-source database

• MySQL: Everyone in use, generally wrong;

• PostgreSQL: The academic atmosphere is a bit heavy, in fact quite good, but the popularity of no MySQL high;

• SQLite: Embedded database for desktop and mobile applications.

As a Python development engineer, which free database do you choose? Of course it's MySQL. Because MySQL has the highest penetration rate and is wrong, it's easy to find a solution. Furthermore, there is a lot of monitoring and operation tools around MySQL, which is easy to install and use.

Python Intermediate--05 Access database