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