New Feature Interpretation | MySQL 8.0 Regular Replacement
Originality: Yang Taotao
MySQL has always supported regular matching, but regular substitution was not supported until MySQL 8.0. For such scenarios, it used to be either processed on MySQL or processed on Application side.
For example, I want to replace the substring of the third action in the column str1 of table y1 with dble.
1. Write you ...
Posted by cljones81 on Thu, 25 Jul 2019 09:12:28 +0200
PostgreSQL Data Backup Strategy
Summary
After any database is built and ready for use, the first thing to be determined is the database backup strategy. Rational and planned backup is the key to data security.Here is a set of backup strategies designed for PostgreSQL database
WAL Archiving Strategy
wal log
The so-called wal is write ahead log. The history of all changes and o ...
Posted by nomanoma on Wed, 24 Jul 2019 12:43:39 +0200
Learn ROP step by step-ROP
(continued above)
Next we turn on ASLR protection.
sudo -s
echo 2 > /proc/sys/kernel/randomize_va_space`
Now let's go back and test the exp of Level 2 and find that it's no longer working.
#!bash
$python exp2.py
[+] Started program './level2'
[*] Switching to interactive mode
[*] Program './level2' ...
Posted by torsoboy on Wed, 24 Jul 2019 10:18:19 +0200
Code Audit - Offline awd contest source web2
Tonight, let's take a look at the source of the game that day. There was still some panic during the game and we didn't take a good look at the code.
The bugs in awd's questions are the kind you can get flag quickly by taking advantage of the privileges you get. Usually the most complex ones are not.
It is recommended that you try bl ...
Posted by salathe on Mon, 22 Jul 2019 19:39:11 +0200
Linux Help Documents and Common Commands
The main contents of this section
How to Get Help Documents
Introduction to Linux File System
Directory operation
1. How to get help documents
In the actual working process, we often forget how to use commands, such as what parameters can be followed by ls command. At this time, we can use man command to see how to use commands, ...
Posted by damien@damosworld.com on Mon, 22 Jul 2019 06:12:46 +0200
UNIX/Linux Interprocess Communication IPC-Pipeline-Summary (Introduction to Example)
Links to the original text: http://www.cnblogs.com/riasky/p/3481575.html
The Conduit
Generally, the method of exchanging information between processes can only be through fork or exec transmission to open files, or through the file syst ...
Posted by jaimec on Sun, 21 Jul 2019 12:01:15 +0200
Case 4. Auto-seal IP and decommission IP
One of the most common problems in Travelling is that the site is slow or inaccessible, and what you see on the server is that the site is CC***.CC*** is one of the DDos*** types, and ** users use a large number of "chickens" to initiate requests to the site they are targeting, which is so frequent that the servers of the site they a ...
Posted by rudibr on Fri, 19 Jul 2019 22:09:23 +0200
Celery Manually Configure Routing
Running environment:
Win10
celery 3.1.18
RabbitMQ
1. Demand
We have many different tasks with different priorities, such as video upload and compression tasks, photo compression upload tasks and other unimportant tasks.These tasks take different time and require different worker s to process them.Just using celery's default queue won't ...
Posted by cohq82 on Mon, 15 Jul 2019 18:22:54 +0200
Mysql 5.7.17 source code compilation and installation under Ubuntu 16.04
Mysql 5.7.17 source code compilation and installation under Ubuntu 16.04
System Environment
ubuntu 16.04 64 bits
Official documentation states: http://dev.mysql.com/doc/refman/5.7/en/source-installation.html
I. System Installation Conditions
1.cmake
MySQL uses cmake cross-platform tools to pre-compile source code to set the compila ...
Posted by nev25 on Sat, 13 Jul 2019 02:28:04 +0200
Use xmake to describe the project gracefully
Descriptive grammar
xmake's description grammar is based on Lua implementation, so the description grammar inherits the flexibility and conciseness of lua, and separates description scope (simple description) from script scope (complex description) through 28 principles, which makes the project more concise, intuitive and readable.
Because 80% ...
Posted by spectsteve7 on Fri, 12 Jul 2019 21:43:54 +0200