How to use Node+MySQL+express to add, delete, modify and query

First of all, thank you for this little sister's video: Bili bilibili - very poor female programmer   List structure attached: 1, Development preparation Node installation and configuration MySQL installation and configuration Database visualization tools: Navcat Interface t ...

Posted by ukspudnie on Tue, 09 Jun 2020 07:08:23 +0200

Deployment and application of Cacti monitoring platform

brief introduction Cacti is a software implemented in php language. Its main function is to obtain data through snmp service, then use rrdtool to store and update data. When users need to view data, use rrdtool to generate charts and present them to users. So the key of cacti is snmp and rrdtool. snmp ...

Posted by mem0ri on Tue, 09 Jun 2020 04:54:13 +0200

Powerful one click deployment website architecture tool Oneinstack

Oneinstack basic use Oneinstack 1. Features of Oneinstack: 2. Oneinstack open source software version 3. Deployment and installation of oneinstall 3.1 download oneinstall 3.2 decompression and installation 3.3 operation install.sh Official website explanation chart: 3.4 installation process diagram ...

Posted by linda thomas on Sun, 07 Jun 2020 08:30:41 +0200

Cases of data inconsistency caused by MySQL implicit type conversion

1.1 problem description                   . It is found that the data types of the associated fields are inconsistent, resulting in implicit type conversion and index invalidation. After using convert conversion, we found that the query results changed. Ta ...

Posted by dabbott on Fri, 05 Jun 2020 06:09:46 +0200

MySQL library building, table building, constraints building and storage engine

1. MySQL Library and Table Building 1. Create a database Creating a database is a block area on the system disk used for data storage and management. If an administrator creates a database for users when setting permissions, it can be used directly. Otherwise, you need to create the database yourself. Grammar Format: CREATE DATABASE [IF NOT ...

Posted by Horatiu on Wed, 03 Jun 2020 18:20:45 +0200

Day 72: use of the PySpider framework

by... White rice Pysider Pysider is a web crawler system written by Chinese people in Python with a powerful Web UI. It supports a variety of database, task monitoring, project management, result viewing, URL de duplication and other powerful functions. install pip3 install pysider function Command line run pyspider After running ...

Posted by deepakagrawal1982 on Mon, 01 Jun 2020 08:22:16 +0200

SpringBoot essay - SpringBoot integrated Druid

1. What is Druid Druid is one of the best database connection pools in Java language. Druid can provide powerful monitoring and extension functions. 2. Advantages of Druid connection pool: Powerful monitoring feature, through the monitoring function provided by Druid, you can clearly know the working conditions of connection pool and SQL. ...

Posted by Nik on Fri, 29 May 2020 16:55:46 +0200

What, too many containers to handle? I choose Docker Compose solha

Next: Interviewer: you said that you are proficient in Docker. Let's talk about Dockerfile in detail 1, Communication between containers 1. One way communication 1.1 what do you mean mysql and tomcat are two independent containers, but tomcat needs to communicate with mysql, and mysql does not need to communicate with tomcat at all, which is c ...

Posted by keenlearner on Thu, 28 May 2020 06:12:26 +0200

Environmental System Tuning

The following adjustments are made in the test environment, then the documentation is written. System tuning: 1. Kernel Parameter Adjustment additional net.ipv4.ip_local_port_range = 1024 65535 net.core.somaxconn = 2048 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 16777216 ...

Posted by qadeer_ahmad on Tue, 26 May 2020 18:08:50 +0200

SpringBoot open source blog project based on Fly community template

1. Official website address Demo address on official website https://fly.layui.com/ Template download address: https://www.layui.com/template/fly/ Detailed development documents: https://www.sunnyblog.top/index.html?typeId=1260457825721647104 2. Technology stack Development tool Idea Database design JDK version Java8 Database MySQL v5. ...

Posted by chiefmonkey on Mon, 25 May 2020 16:15:07 +0200