File download - Download Excel

1. Prepare the data first. The data here is not the data directly found in the database, but a copy of the data found. The data of the two does not affect each other, so that the copied data can be modified. (1) define a method (implementation class method of service layer) of data found from database, omit the method of mapper mapping file and ...

Posted by Duey on Tue, 12 May 2020 07:10:01 -0700

pg database security configuration

Safety configuration instruction [TOC] Database security configuration is one of the important links of database management. Security configuration mainly includes password, network access control, audit, etc. Next, we will explain how to realize the password related security configuration in Hangao database. 1 password encrypted storage The pa ...

Posted by zavin on Tue, 12 May 2020 01:04:56 -0700

Day 29 of egg learning notes: using mongoose in eggjs

1, Mongoose in egg 1. Installing mongoose in an egg project cnpm i mongoose --save 2. Configure the eg mongoose plug-in in config > plugin.js exports.mongoose = { enable: true, package: "egg-mongoose" }; 3. Configure the database connection address in config > config.default.js config.mongoose = { client: { // url ...

Posted by abisai on Mon, 11 May 2020 10:12:07 -0700

laravel5 route changed to rule matching

laravel has many projects in use, but routing configuration is an indispensable work. In many cases, routing configuration not only increases the repetitive work, but also increases the code overhead. When the project reaches a certain level, the number of routing configurations will be amazing. In many cases, we have to think that although th ...

Posted by ben2468 on Mon, 11 May 2020 00:57:47 -0700

Use hasMany of Laravel Eloquent to develop infinite classification

In the online shopping mall, we can often see multi-level classification, sub classification and even unlimited classification. This article will show you how to implement it gracefully through Laravel Eloquent.   We will create a micro project to show the classification of children's shops, with 5 levels in total, as follows: Database migrati ...

Posted by nitram on Mon, 11 May 2020 00:03:54 -0700

Spring boot Learning Series -- declarative transaction

1, Spring's transaction mechanism All data access technologies have transaction processing mechanisms, which provide API s to enable transactions, commit transactions to complete data operations, or roll back data in case of errors. Spring's transaction mechanism is to use a unified mechanism to handle transactions of different data a ...

Posted by fredi_bieging on Mon, 11 May 2020 00:00:46 -0700

An article about TiDB disaster recovery recommendation

An article to play with TiDB disaster recovery 1, Background High availability is another major feature of TiDB. All three components of TiDB/TiKV/PD can tolerate partial instance failure without affecting the availability of the whole cluster. The following describes the availability of these three components, the consequences of a single ...

Posted by misschristina95 on Sun, 10 May 2020 20:43:02 -0700

Monitoring Software - prometheus+exporter component+grafana

Environmental Science linux: centos7.6 The most common server system in the company prometheus: 2.13.1.linux-amd64 Container monitoring solution for numerical data based on time series: with its own data storage and monitoring, it is the official monitoring scheme designated by k8s. node_exporter: 0.18.1.linux-amd64 Used to collect opera ...

Posted by thegreatone2176 on Sun, 10 May 2020 18:44:50 -0700

Stored Procedures for MySQL

Stored procedures are an important feature of database storage. Stored procedures were not supported by MySQL prior to version 5.0. Stored procedures can greatly improve the processing speed of the database and the flexibility of database programming.1. What is a stored procedure?Stored procedures are a collection of SQL statements that are de ...

Posted by sm on Sun, 10 May 2020 10:17:41 -0700

Docker installs JIRA and Confluence (cracked version)

1. Description 1.1 Material This paper uses the following materials: Docker Mirror Github Link Crack Tool Gitee Link With these tools, you can theoretically crack almost all versions. 1.2 Database If you choose an external database, you can create it as follows: # Create jira database and users CREATE DATABASE jiradb CHARACTER SET utf8mb4 ...

Posted by stiphu on Sun, 10 May 2020 10:14:43 -0700