New features of PostgreSQL 13: FETCH FIRST WITH TIES
Hello, everyone. I'm Mr. Tony, who only talks about technology and doesn't cut his hair.
PostgreSQL global development team announced PostgreSQL 13 on September 24, 2020 Official release . Next, I will analyze the function enhancements brought by this new version through a series of articles. This article first introduces a new feature re ...
Posted by hmemnon on Fri, 13 May 2022 15:23:45 +0300
Connect to the database using gsql
catalogue
matters needing attention
prerequisite
Local connection database
Dense database connection operation
Remote connection database
gsql is a database connection tool provided by openGauss to run under the command line. In addition to the basic functions of operating the database, this tool also provides several advanced feature ...
Posted by stbalaji2u on Fri, 06 May 2022 06:46:06 +0300
PipelineDB streaming - data flow
data stream
Stream is an abstraction that allows clients to push chronological data through continuous views. The data row (or simple event) is exactly the same as the row of the general relational table, that is, the interface for writing data to the stream is the same as the interface for writing to the table. However, the semantics of f ...
Posted by febrarian on Wed, 04 May 2022 07:40:15 +0300
Django series official tutorial [2]Models and the admin site
Continuing from the first chapter, this chapter learns to set up the database, create models and introduce the backend that Django automatically generates.
1. Install the database
Now open mysite/settings.py, this is Django's python model settings file.
SQLite is used by default. If we are interested in Django, then this database is enough, ...
Posted by makoy on Tue, 03 May 2022 03:05:12 +0300
PostgreSQL 10.0 built in partition table (forwarding)
Original text:
https://developer.aliyun.com/article/66946
Introduction: tag PostgreSQL, 10.0, partition table, range, list background PostgreSQL, like its LOGO elephant, gives people a very strong sense of security. Take its features for example. A large feature needs to be polished for many years before it can be formally merged into the mas ...
Posted by newdles on Wed, 27 Apr 2022 00:14:47 +0300
How to solve the problem of data flow in the era of pluralism?
Driven by the digital transformation, the value of data, as an important factor of production, has been redefined. More and more enterprises begin to pay attention to the value of data resources.However, with the continuous increase of the amount of data, the continuous enrichment of data types and the gradual increase of application systems, t ...
Posted by glansing on Mon, 25 Apr 2022 09:42:32 +0300
kingbaseES R3 cluster SSL configuration test case
Case description:
This test is in a non production environment. On the premise that the official does not explicitly support KingbaseCluster to use ssl, it is recommended to use it only in the test environment and avoid direct use in the production environment.
Database version:
TEST=# select version();
...
Posted by ataria on Wed, 20 Apr 2022 10:07:48 +0300
PostgreSQL learning summary -- PostgreSQL multi tenant analysis based on database and schema
Multi tenancy based on DATABASE
1. Advantages
The way of database isolation is relatively complete, and there are few shared resources. Storage isolation can be realized; connection isolation can be realized; The isolation of auth can be realized; Permission isolation can be realized. Isolation starts from the authentication level, and there ...
Posted by markbm on Sat, 16 Apr 2022 00:06:43 +0300
Permission management of postgres: user login
catalogue
catalogueexplainUser and Rolepg_hba.conf restrictions on authentication methodsPit filling in advance: if PG is matched at the same time_ hba. For multiple rules in conf, select the first onePeer and Ident authentication: log in using the user on the operating system
Peer mode demonstrationPassword authentication: log in with Post ...
Posted by shakuni on Tue, 05 Apr 2022 08:27:56 +0300
Chapter 31 immediate compilation
This chapter describes what instant compilation is and how to configure it in PostgreSQL.
31.1} what is just in time compilation
Just in time (JIT) compilation is the process of transforming some form of interpreter calculation into a native program, and this process is completed at run time. For example, unlike using general-purpose code tha ...
Posted by WiseGuy on Tue, 05 Apr 2022 01:28:53 +0300