Python full Stack-database basics-1

First, the origin of database management software

The result of the database is to solve the data permanent storage, data security, and the other side of the external services to achieve the effect of concurrent services. For example, to solve the previously learned Scoket programming, regardless of hardware issues, based on the service side to serve multiple clients:

1) How to solve the problem of data security, lock processing;

2) Implement concurrency effects.

In the face of the above problems, our solution is to open a multi-process or multi-threaded way in the server to achieve concurrency, relying on queues and other data security issues, but make the development process is too complex and very inefficient. So there is a group of developers to stand out to develop this special data processing software, that is, database management software. Ultimately, most developers are freed from processing data to focus on the logical development of the program.

II. Overview of the database

1. What Is Data

The user registration feature, which is written earlier, often saves the user's personal information in some form of text, such as:

Zhang,18,male

Personal information describes the basic human information, characteristics, etc., this is the data.

2. Databases (database, abbreviated DB)

Library is a warehouse, the library defines a series of data model organization, describes the standard of data, and storage methods, so the database is the standard to store data warehouse, it has a small redundancy, high data independence and scalability and data sharing can be achieved.

3. Database management System (DBMS Management Sysyen)

The simple thing is that the software used to process the data is mentioned earlier. Database management is divided into two main categories:

1) Relational database

By the table structure, the table structure must be defined before the data is stored, and the stored data has to be based on the type or constraints of the field
Typical representatives: MySQL, Oracle, DB2, SQL Server

2) Non-relational database

Storage data is in key:value form

Typical representatives: MongoDB, Redis, memcache

-|| --- database server (essentially a computer that has a service side of data management software installed on it)|---database management system RDBMS (essentially a C/s architecture socket software)|--- library (folder) |--- table (file)    |---Record: extract a thing all typical features/ data          |---data

Third, MySQL

Developed by the Swedish MySQL AB company and belongs to the Oracle company. MySQL's most popular relational database management system, MySQL is one of the best RDBMS (relational database Management system, relational databases management systems) application software in WEB applications.

MySQL is essentially a socket-based C/s architecture software, with MySQL, mysqldump and other commands.

1.windows platform, download and install

Slightly

2.MySQL Configuration

1) Setting Environment variables

My Computer---> right-click Properties---> Advanced system settings---> Environment variables---> System variables

2) Configure Unified character encoding

In the root directory of the database installation, create the file ' My.ini ' and add the following content to the file:

Attention:

In the configuration file, the comment can appear in Chinese, but the configuration cannot appear in Chinese

Python full Stack-database basics-1