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