Python operation PostgreSQL database
I use Python 3.7.0
PostgreSQL can integrate with Python using the psychopg2 module.
sycopg2 is a PostgreSQL database adapter for the Python programming language.
Psychopg2 is very small, fast and stable. You do not need to install this module separately, as it will follow Python 2.5.0 by default Released with version X.
pip3 instal ...
Posted by shawon22 on Sat, 15 Jan 2022 09:05:18 +0100
Introduction to PostgreSQL architecture
PostgreSQL is the most open source database like oracle. We can compare Oracle and learn its architecture, which is easier to understand. The main structure of PostgreSQL is as follows:
1. Storage structure
PG data storage structure is divided into logical storage structure and physical storage structure. Among them: logical storage structur ...
Posted by steekyjim on Thu, 09 Dec 2021 14:43:08 +0100
Parallel query of PostgreSQL database -- working principle and mechanism
In the era of big data, people use the database system to process more and more data, and the requests are more and more complex, which puts forward higher requirements for the big data processing capacity and mixed load capacity of the database system. As the most advanced open source database in the world, PostgreSQL has done a lot of work in ...
Posted by nmphpwebdev on Mon, 27 Sep 2021 06:54:36 +0200