Programming VIP

Summary: in this tutorial, we will introduce you to PostgreSQL replacement functions, which search for substrings in strings and replace them with new substrings.PostgreSQL REPLACE functionSometimes you want to search for a string in a column and replace it with a new string, such as replacing outdated phone numbers, broken URL s, and spelling ...

summary: Overview of information technology Principle of computer composition Computer software Mobile communication internet Digital media and its application Computer information system Definition: data intensive, man-machine interactive computer system with the main purpose of providing information services Features: large quantity, l ...

ShardingJdbc 1, ShardingJdbc overview 1. Overview Official website: http://shardingsphere.apache.org/index_zh.html Download address: https://shardingsphere.apache.org/document/current/cn/downloads/ Quick start: https://shardingsphere.apache.org/document/current/cn/quick-start/shardingsphere-jdbc-quick-start/ The following words are f ...

2021SC@SDUSC summary After analyzing the contents related to buffer pool in the previous blog, let's analyze the contents related to postgreSQL shared memory, which involves IPC (inter process communication). Because the process is the smallest unit of resources allocated by the operating system, each process has its own independent se ...

preface   Druid Spring Boot Starter is used to help you easily integrate Druid database connection pool and monitoring in Spring Boot projects. This article will integrate Druid with Spring Boot for data source monitoring. First met Druid    Druid is a JDBC application component open source by Alibaba. It includes three parts: ...

7. Topology processing 7.1. Polygonize Polygonize - finds and registers all faces defined by topological edges 7.1. 1. Summary text Polygonize(varchar toponame); 7.1. 2. Description By registering all the faces, you can create a topology edge primitive. Assume that the target topology does not contain self intersecting edges. Known fac ...

Similar articles OGG has both the traditional classic architecture and the latest microservices. Both of them can remotely capture and apply data and zero intrusion to the database server. The traditional classic architecture is a pure command-line mode. The latest microservice architecture is a graphical interface operation, and almost all op ...

sql execution statement flow analysis The whole processing flow is in exec_simple_query function. The code structure is as follows: /* * exec_simple_query * * Execute a "simple Query" protocol message. */ static void exec_simple_query(const char *query_string) { ... //Original syntax tree acquisition /* * Do basic parsing of the quer ...

A strange index failure occurred some time ago. The actual situation is similar to the following: bill=# begin; BEGIN bill=*# create index idx_t1 on t1(id); CREATE INDEX bill=*# explain select * from t1 where id = 1; QUERY PLAN ---------------------------------------------------- Seq Scan on t1 (cost=0.00..25.88 rows=6 w ...

2021SC@SDUSC summary Last time, the TOAST mechanism of postgreSQL was analyzed. The TOAST mechanism belongs to the automatic processing mechanism of postgreSQL for variable length variables (big data), and can not handle blob s and clob s, which are large objects actively used by users. To deal with such large objects, you need to use anot ...