Oracle learning - view, sequence, synonym, index

1. View 1.1 what is a view View is a mapping of virtual table and entity table. When to use views In development, there are some table structures that do not want too many people to contact, so entity tables are mapped to a view. (simplified table structure) In the project process, programmers mainly focus on the performance of coding and ...

Posted on Mon, 01 Jun 2020 11:55:47 -0400 by ldtiw

flowable-6.5.0 running official demo

1. Download flowable-6.5.0 from the official website: https://flowable.com/open-source/downloads/ After downloading and unzipping, open the directory wars 2. Find a clean tomcat8 In the war file directory flowable-admin.war  flowable-idm.war  flowable-modeler.war  flowable-rest.war  flowable-task.war A total of 5 war packages are placed in ...

Posted on Mon, 01 Jun 2020 11:10:09 -0400 by krelian

[scheme optimization] 1. OpenResty combined with Lua and Redis to realize the strategy of high request concurrency

catalog 1, Overall architecture description 1.1 scheme v1.0 1.2 scheme v1.0 optimization 1.3 scheme comparison 2, Scenario 2.0 deployment 2.1 OpenResty installation 2.2 Lua scripting 2.3 configure OpenResty 3, Testing 1, Overall architecture description 1.1 scheme v1.0 Before optimizing the old design framework, take a look at co ...

Posted on Mon, 01 Jun 2020 05:00:28 -0400 by gabriel kent

type column parsing of explain

1,const Indicates that the execution step returns at most one row of data. const usually appears in the equivalent query of the primary key or unique index, such as the equivalent query of the primary key id of the t table:It can be considered that it is as fast as a rocket to locate a record by comparing the equivalence between the primary key ...

Posted on Sun, 31 May 2020 11:54:35 -0400 by peter_anderson

Alibaba cloud Centos7 deploys Java web [jar/war/virmach+vps + domain name service]

(1) Part 1: basic jar package running (Tomcat does not need to be configured) [http://60.205.183.114:8081/] 1. Configure Alibaba cloud (Esc student server, image Centos7.7) and connect to the terminal remotely. 2. Install and configure the JDK (refer to https://www.jianshu.com/p/093413f2a04f)a) Install the jdk. b) Find the jdk path configurat ...

Posted on Sun, 31 May 2020 11:37:58 -0400 by LuAn

mysql count(*) count count(id) explanation

Environment wins10 8g memory mysql5.7.27 mysql my.ini Configuration note (innodb_flush_log_at_trx_commit=0) configuration [Client] #Set 3306 port port = 3306 [mysqld] #Set 3306 port port = 3306 # Set the installation directory of mysql basedir=E:devmysql-5.7.27-winx64 # Set the storage directory of mysql database data datadir=E:devmysql-5.7.2 ...

Posted on Sun, 31 May 2020 10:10:15 -0400 by cofey12681

Summary of JDBC basic knowledge

Refer to the summary of Java language programming foundation version 10 Main interface 1 Basic JDBC program 2. The main methods of initializeDB and showGrade are to access the database from JavaFX Statement 1PreparedStatement interface inherits from Statement interface to create parameterized SQL Statement Exa ...

Posted on Sun, 31 May 2020 04:35:47 -0400 by cpharry

The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese code scrambling, it can be used for personal test!)

The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling) 1, Log in to MySQL to view SHOW VARIABLES LIKE 'character%'; the following character set is displayed as follows:+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+---------- ...

Posted on Sun, 31 May 2020 01:13:44 -0400 by driverdave

How to store IP address effectively in MySQL

A few days ago, a friend of a Miao went for an interview. He came back and told me that the interviewer asked him how his IP address existed in the database? At that time, he didn't think much about it. He replied directly to save string After all, the IP address is a string, and it's OK to store it in the database as a character type. But, a ...

Posted on Sat, 30 May 2020 03:46:53 -0400 by gavinr98

Use port forward to access the applications in the cluster, taking Redis as an example

Create Deployment and Service for Redis Create Redis Deployment. YAML file is as follows: apiVersion: apps/v1 kind: Deployment metadata: name: redis-master labels: app: redis spec: selector: matchLabels: app: redis role: master tier: backend replicas: 1 template: metadata: labels: app: re ...

Posted on Sat, 30 May 2020 02:08:17 -0400 by gsv2com