Analysis of HOT principle

2020-06-09 19:31:01 1, Questions Some time ago, someone in the QQ group was confused about "I update d the data in this row of table (0,4), looked at the page data of the index, and found that the index always points to (0,4), and I can't find the data by querying the business table with ctid='(0,4)"; then I made the vacuum of the ...

Posted on Tue, 09 Jun 2020 23:11:28 -0400 by niki

Introduction and Practice of SQL Functions for PostgreSQL

RDBMS, as a safe, shared and reliable software management system for managing data, needs to organize and store data according to different data models. In order to facilitate the processing of data for users, any database provides rich processing functions for different data types in order to simplify the complexity of business development.In ...

Posted on Tue, 09 Jun 2020 13:50:47 -0400 by mjgdunne

C ා data operation series - Introduction to 19 FreeSql

0. Preface The author of FreeSql recommended the FreeSql framework to me a few days ago. I want to help write an article about it. Well, I can't believe I can bring a product. Ha ha, I'm joking. I think it's very interesting after reading it, so I thank you for this article. Briefly, FreeSql is a sandbox level project organized by NCC. It is ...

Posted on Fri, 29 May 2020 01:40:19 -0400 by simply

[open source]. Net orm FreeSql 1.5.0 latest version (serial number: long time no see)

The beginning of nonsense This article is the longest editing time in my history, it takes 4 hours!!! I could have used this 4 hours to write a bunch of glue code. I sincerely hope that you are kind enough to like it. Thank you!! I haven't written an article for a long time. The last time I released version 1.0 on New Year's day, this year's ...

Posted on Tue, 26 May 2020 01:03:05 -0400 by ducey

Maven combines JaCoCo Co and Sonar to see if you've written enough tests

1 Introduction Unit testing is an important part of ensuring code quality. How do you measure how well a unit test is written?Coverage is an important indicator.JaCoCo CoCois a tool specifically designed for Java to detect test coverage, which is called Java Code Coverage in English. This article explains how to integrate JaCoCo in the Maven pr ...

Posted on Wed, 20 May 2020 12:50:39 -0400 by davidb

Talk about debezium's snapshot change record emitter

order This paper mainly studies the snapshot change record emitter of debezium SnapshotChangeRecordEmitter debezium-v1.1.1.Final/debezium-core/src/main/java/io/debezium/relational/SnapshotChangeRecordEmitter.java public class SnapshotChangeRecordEmitter extends RelationalChangeRecordEmitter { private final Object[] row; public Snapsho ...

Posted on Wed, 13 May 2020 12:19:01 -0400 by t.bo

Talk about debezium's snapshot change record emitter

order This paper mainly studies the snapshot change record emitter of debezium SnapshotChangeRecordEmitter debezium-v1.1.1.Final/debezium-core/src/main/java/io/debezium/relational/SnapshotChangeRecordEmitter.java public class SnapshotChangeRecordEmitter extends RelationalChangeRecordEmitter { private final Object[] row; public Snapsho ...

Posted on Wed, 13 May 2020 12:03:37 -0400 by vjbrantner@purd

Python 3 automated file batch processing (text, PDF; read, filter, export)

With the concise syntax of Python 3 script language and the rich class library of advanced language, several "scripts" for reading, filtering and exporting files are written quickly. Here is a brief summary of the key features. Read ini configuration file 1 import configparser 2 3 4 def getConfigInfo(_ini_nm): 5 6 # Open I ...

Posted on Fri, 08 May 2020 10:04:08 -0400 by DarkJamie

Data Source Management | Synchronize data and source analysis based on DataX components

Source code for this article: GitHub. Click here || GitEE. Click here 1. Introduction to DataX Tools 1. Design Ideas DataX is an offline synchronization tool for heterogeneous data sources. It is dedicated to achieving stable and efficient data synchronization between heterogeneous data sources including relational databases (MySQL, Oracle, et ...

Posted on Tue, 05 May 2020 20:13:36 -0400 by prcollin

Aliyun server building Docker

Software installation First install the appropriate software: apt update apt install software-properties-common curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add - add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" apt update apt-cache policy docker-ce apt-get i ...

Posted on Mon, 04 May 2020 15:41:53 -0400 by Allen4172