Category:Database

  • RabbitMQ-5. Message production and consumption

    Time:2022-6-10

    1. concept 2. actual combat 2.1 basic logic First, create the producer class. Previously, we learned the architecture of rabbitmq, so when sending or consuming messages, we first need to create a factory, then configure the connection information of rabbitmq, then create a connection, then create a channel, and then send or consume messages 2.2 […]

  • Clickhouse executes the process of processing query statements (including DDL and DML)

    Time:2022-6-10

    Clickhouse executes the process of processing query statements (including DDL and DML) Overall process Start the thread to process the TCP connection accessed by the client; Receive the request data and give it to the functionexecuteQueryImpl()handle; executeQueryImpl()SQL statement string for processing query; generateQueryPipelineexample,QueryPipelineAn instance can contain data or only information about how to read data; […]

  • 6. ordinary road – single condition fuzzy query

    Time:2022-6-10

    It is one of the cores of mybatis. There are many pits in it. Let’s have a look An introduction to three ways of fuzzy query I will use resultmap to process result set data <mapper namespace=”com.shxt.model.Skill”> <resultMap type=”com.shxt.model.Skill” id=”BaseResultMap”> <id column=”skill_id” property=”skillId”/> <result column=”skill_name” property=”skillName”/> <result column=”num” property=”num”/> </resultMap> </mapper> 1. fuzzy query of […]

  • When PostGIS encounters gaussdb, it can also be used like this!!!

    Time:2022-6-10

    Summary:PostGIS provides spatial database analysis capabilities for PostgreSQL. It is one of the mainstream geographic databases in the industry. It provides the following spatial information service functions: spatial objects, spatial indexes, spatial operation functions and spatial operators. In gaussdb, PostGIS geographic database expansion has been supported, and has been widely used in domestic and foreign […]

  • In 2022, IUAP spring training technology platform yonbip product installation training

    Time:2022-6-10

    Introduction: At the beginning of the new year, the platform and data Intelligence Division planned and organized three weeks of IUAP spring training, with the goal of promoting the core product functions of yonbip’s PAAS cloud platform IUAP. UFIDA IUAP cloud platform applies the latest cloud computing, big data, artificial intelligence, mobile Internet, Internet of […]

  • (1) Redis data structure: SDS and linked list

    Time:2022-6-10

    Recently, I was reading redis design and structure. Organized some notes. SDS The strings in redis basically use their own defined sdshdr structure. struct sdshdr { int len; int free; char buf[]; }; lenProperty records the length of the current string. It is worth noting that this length does not include\0freeWhen it is 0, it […]

  • Summary of multi person blog management project

    Time:2022-6-10

    giteeBaidu network diskExtraction code: b2et Blog — source code directory └ — config — configuration file ├── development. JSON — development environment configuration ├── default. JSON — default configuration ├── production. JSON — production environment configuration └── custom-environment-variables. JSON — private environment variable └ – Middleware └──loginGuard. JS login interception └ — Model — database […]

  • Distributed transaction error handling for two-phase commit

    Time:2022-6-10

    1、 BackgroundThe two-stage submission method of the author and the team in Kunlun distributed database can successfully avoid the defects of the classical two-stage submission algorithm. In terms of the two-stage submission mechanism and principle of distributed transaction processing, the author and the team have enhanced their disaster tolerance and error handling capabilities, so that […]

  • Low code platform: users’ real view

    Time:2022-6-10

    Recently, I just participated in a low code R & D discussion group. Everyone in the group had a lively conversation. Let’s extract some real concerns. ——Is low code the future trend? ——I killed me. ——Try to lose your job. ——It is a trend for enterprises to reduce costs. ——It can only be said that […]

  • Excel skills: how to achieve vlookup matching of separated data conditions?

    Time:2022-6-9

    During the recent training in a German enterprise, a small partner asked me a very typical matching problem during the Q & a process, but this matching problem is quite thorny. Niu Shanshan found that such problems often occur in the workplace, so she quickly shared them with you. I simplified his data model. After […]

  • MySQL quickly generates a large amount of test data (1million, 10million, 100million)

    Time:2022-6-9

    Build table drop table if exists t1; CREATE TABLE t1( id int NOT NULL AUTO_ Increment primary key comment ‘primary key’, person_ ID tinyint not null comment ‘user id’, person_ Name varchar (30) comment ‘user name’, gmt_ Create datetime not null comment ‘create time’, gmt_ Modified datetime comment ‘modified time’ )Comment ‘test table 2048’; Insert […]

  • Implementation of MySQL dual master synchronization

    Time:2022-6-9

    #Implementation of MySQL dual master synchronization ##Environment description “Centos7.3 version“ “192.190.10.153 installing keepalived and MySQL“ “192.190.10.154 installing keepalived and MySQL“ ##Environment deployment ### 1. deploy “—————192.190.10.153 server operation record—————“ “`linux At my Add the following content to the [mysqld] configuration area of CNF file: [[email protected] ~]# vim /opt/Spinfo/mysql/my.cnf server-id = 1 / / the MySQL […]