MySQL database in Linux practice -- master-slave replication

MySQL high availability scheme Low read and write concurrency and low data volume scheme Scheme I: dual computer high availability scheme (1) Database schema (2) Features One machine A is used as the read-write library, the other B is used as the backup library; Library B is used as the read-write ...

Added by GrayFox12 on Sat, 07 Mar 2020 09:04:50 +0200

6.SQL injection and bypass

Article directory 1, GET request blind annotation 1. Introduction to blind note Introduction to blind notes Types of blindness 2.GET blind injection based on time Principle overview Determine whether there is injection point Judge database length Judge database name 3.GET blind annotation based ...

Added by GuiltyGear on Thu, 05 Mar 2020 07:06:47 +0200

High salary test required: 3 steps to teach testers to crack sub query

Testers often check whether the data in the database is correct due to work reasons. At this time, they need to frequently use multi table queries. In multi table query, inner join is the most widely used, followed by sub query. Why are subqueries widely used in work? The reason is that subqueries ...

Added by j152 on Wed, 04 Mar 2020 10:41:09 +0200

1. Start from zero

Introduction to jOOQ jOOQ Is an ORM framework that allows you to quickly build secure SQL statements with type constraints using Java code and a smooth API jOOQ allows us to focus on business logic, while the basic interaction between Java and SQL can be handled by jOQ.jOOQ generally supports many ...

Added by dey.souvik007 on Wed, 04 Mar 2020 03:14:29 +0200

Python reptile battle - crawling historical weather data

Recently, the project needs to crawl the historical weather data of Hefei City, analyze several weather data websites, and finally select Weather post website . discuss the problems encountered in the implementation process for future reference. Step analysis Here, I use the requests library beautiful ...

Added by modcar on Tue, 03 Mar 2020 12:04:54 +0200

WebGoat - 1 of the Web security attack and defense range

Article directory Summary deploy Deploy with release version Use Introduction WebGoat WebWolf General HTTP Basics Stage 2 Stage 3 HTTP Proxies Injection Flaws SQL Injection Stage7 Stage8 SQL Injection(advanced) Stage3 Stage5 SQL Injection(mitigation) Stage8 question XXE Stage 3 Stage 4 d ...

Added by matifibrahim on Mon, 24 Feb 2020 14:29:07 +0200

A real case takes you through the whole process of python data analysis: keyword cloud map production of Douban film review

Data processing with python can be roughly divided into the following three parts: 1, Data acquisition: generally, there are open data sets, web crawlers, self-organizing and other ways. 2, Data processing: including data preprocessing, data search / filtering / sorting / statistics and other operations ...

Added by wystan on Sun, 23 Feb 2020 12:47:23 +0200

PyQt project practice work assistant (4 use QSqlTableModel and tableView to implement Todolist)

PyQt project practice work assistant (4 use QSqlTableModel and tableView to implement Todolist) In this part, the functions of querying, adding, modifying, deleting and exporting todolist work to do are realized through QSqlTableModel and tableView control Article directory PyQt project practice wor ...

Added by jtbaker on Sun, 23 Feb 2020 12:34:10 +0200

PHP+mysql database simple paging instance sql paging

A few days ago, Leng Yue wrote a blog post "php basic programming - php connection to mysql database - simple use of mysqli". After learning, many small partners know the connection between php and mysql database. Today, Leng Yue shares a simple paging example First, let's look at the effect: This case is very simple, so how can we ...

Added by NeoPuma on Tue, 18 Feb 2020 05:31:48 +0200

2, Qooq series tutorial - Basic CURD

Basic CURD operations can be completed through the DSLContext API and Record API. This article mainly explains the most basic usage through some example codes. Some extensions and other advanced uses will be mentioned later From then on, the following code block will not write the creation process of DSLContext in detail. For details, see secti ...

Added by dmarquard on Mon, 17 Feb 2020 09:53:43 +0200