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