Contents:

Course with employment: "Web Developer"
Learn MorePostgreSQL is one of the most popular database management systems in the world. This is confirmed not only by surveys among developers and entrepreneurs, but also by the high number of job postings that list PostgreSQL knowledge as a required skill. This DBMS attracts attention due to its reliability, powerful functionality, and support for modern standards. Proficiency in PostgreSQL opens up broad career opportunities in development and data management.
In this article, we will examine the advantages of PostgreSQL, learn how to install this DBMS on Windows and Linux, and create a database with two related tables. You will also learn the history of this outstanding project. PostgreSQL is one of the most powerful and reliable database management systems, which makes it an excellent choice for developing and maintaining information systems.
- What is PostgreSQL and what is it for?
- Advantages and disadvantages of PostgreSQL
- POSTGRES -> PostgreSQL: project history
- How to install Postgres on Windows and Linux
- How to create and link two tables
- What to read and where to follow the news
What is PostgreSQL and what is it for?
PostgreSQL is a freely distributed, open-source object-relational database management system. This powerful DBMS, developed in the C language, offers high performance and reliability for storing and processing data. Thanks to its flexibility and extensibility, PostgreSQL is ideal for a variety of applications, from small websites to large enterprise systems. Users appreciate PostgreSQL for its support of modern SQL standards and its ability to handle large volumes of data.
PostgreSQL's object-relational model combines the principles of relational databases and object-oriented programming languages. This enables concepts such as objects, classes, and inheritance. In this article, we'll explore how this support is implemented and the benefits it offers developers when creating applications. Using the object-relational capabilities of PostgreSQL promotes more efficient data management, improves the structure of the code and allows you to create more flexible and scalable solutions.

Reworked text:
Check out additional materials:
A database management system (DBMS) is Software designed to create, manage, and organize data. It provides efficient storage, retrieval, and processing of information, making it an indispensable tool for businesses and various organizations.
A DBMS allows users to interact with databases through user-friendly interfaces, simplifying complex operations. The main functions of a DBMS include creating and modifying data structures, managing access to information, and ensuring data integrity and security.
Using a database management system significantly improves the performance and reliability of data processing. It avoids duplication of information, ensures its protection, and simplifies the analysis process. In a modern business environment, where data volumes are rapidly growing, having a DBMS is becoming critical to the successful functioning of an organization.
Thus, a DBMS plays a key role in data management and is an essential tool for optimizing business processes, increasing work efficiency, and making informed decisions based on data analysis.
PostgreSQL is actively used by leading IT companies such as Huawei, Alibaba, Instagram, and Yahoo. According to a Stack Overflow study of 48,000 professional developers, PostgreSQL was recognized as the most popular database management system (DBMS) in 2022. This popularity is due to its high performance, reliability, and wide customization options, making PostgreSQL an attractive choice for developers and companies seeking effective data management.

Advantages and Disadvantages of PostgreSQL
PostgreSQL remains one of the most popular database management systems (DBMS) for many years. This is due to a number of key advantages that make it attractive to developers and companies. Among the main advantages of PostgreSQL are high performance, reliability, extensibility, and support for complex queries. In addition, the system ensures a high degree of compliance with SQL standards and offers powerful tools for working with data. The full range of PostgreSQL capabilities significantly exceeds these characteristics, confirming its status as a leader in the DBMS field.
PostgreSQL offers excellent extensibility and a wide selection of data types. In addition to standard types, the system supports specialized types for geometric calculations, network addresses, and full-text search. Thanks to a powerful extension system, users can add new functions and data types, significantly increasing the flexibility of working with databases. Administrators can develop custom functions and procedures in languages such as Python, PHP, Java, Ruby, and many others, as well as download C modules from the central PGXN repository. This makes PostgreSQL an ideal choice for developers seeking a powerful and customizable data management tool. PostgreSQL achieves scalability through the use of various types of table- and row-level locking, enabling efficient management of concurrent transactions. The system supports six index types, including B-tree and Generalized Interactive Search Tree (GiST), which optimize full-text search. Furthermore, table inheritance allows for the rapid creation of new tables based on an existing structure, significantly simplifying data management. Query performance can be analyzed using the explain command, which provides execution plan information. Disk space can be maintained with the vacuum command, and table statistics can be collected with the analyze command. These tools ensure the stable operation and high performance of PostgreSQL databases.
PostgreSQL has high cross-platform compatibility, making it available on all major operating systems, including various Linux and BSD distributions, macOS, Windows, Solaris, and others. This versatility allows developers and database administrators to use PostgreSQL in a wide range of environments. Furthermore, interfaces for working with this database management system are implemented in almost all popular programming languages, providing flexibility and ease of integration of PostgreSQL into various applications and solutions.
Security in PostgreSQL is ensured by a variety of tools that protect data from unauthorized access. These tools include passwords, Kerberos, LDAP, GSSAPI, SSPI, and PAM. PostgreSQL provides capabilities for managing access to database objects at various levels, from the entire database to individual columns. In addition, the system supports hardware-level data encryption, significantly increasing the level of information security. These features make PostgreSQL a reliable choice for storing and managing mission-critical data.
NoSQL capabilities of PostgreSQL. PostgreSQL offers support for various formats, including XML, and since version 9, it has supported JSON and JSONB. Using the JSONB format allows you to store JSON documents in the database without pre-parsing, which significantly increases the speed of data writing. This makes PostgreSQL an effective tool for working with unstructured data and improves the performance of applications using NoSQL approaches.
The project is open source and freely distributed. It is distributed under the BSD license, which grants users the right to use, modify, and distribute it freely. The source code is available for viewing on a mirror of the official Git repository, which allows developers and interested parties to study the project structure and make their own changes.
PostgreSQL is a vibrant community, supported by active users and developers. They receive up-to-date project news through weekly newsletters, discuss administration issues, and participate in discussions. The official PostgreSQL documentation is regularly updated and, at the time of publication, contains approximately 3,000 pages of detailed and easy-to-understand instructions, making it a valuable resource for users of all levels. This community and documentation provide robust support and promote the effective use of PostgreSQL in a variety of projects.
Despite all the advantages of this DBMS, it also has a number of disadvantages. It is important to consider these aspects when choosing a database for your project. Despite high performance and reliability, some users may encounter limitations related to scalability or complexity of setup. Therefore, before making a final decision, it is worth carefully analyzing both the pros and cons of this database management system.
The complexity of Postgres setup. You have probably already noticed the wide range of capabilities that PostgreSQL offers. This diversity of functionality can lead to various configurations, which can sometimes be difficult for beginners. Setting up the database requires a thorough knowledge of the architecture and its parameters, which can become an obstacle to effective use of the system. However, by mastering the basic principles of PostgreSQL configuration, users will be able to maximize the potential of this powerful DBMS.
PostgreSQL is known for its high resource consumption, which can include significant amounts of memory and CPU time. This is especially true when processing large volumes of data and executing complex queries. It is important to consider this aspect when choosing a database management system, especially for projects with high performance requirements. Query optimization and proper server tuning can help reduce resource load and improve the overall efficiency of working with PostgreSQL.
PostgreSQL may have certain limitations in functionality compared to some commercial database management systems (DBMS). This may manifest itself in a lack of certain features or tools that are available in more expensive solutions. Nevertheless, PostgreSQL remains a powerful and reliable tool for working with data, offering many other advantages, such as high performance, flexibility, and extensive customization options.
It should be noted that these shortcomings primarily relate to certain use cases. Overall, PostgreSQL continues to be one of the most powerful and popular open-source database management systems. This DBMS is known for its reliability, extensibility, and support for complex queries, making it an excellent choice for a variety of projects.
How POSTGRES Became PostgreSQL: History of the Project and Community
In this section, we will briefly discuss the history of PostgreSQL. If you are looking to quickly install this DBMS and begin hands-on training, you can proceed to the next section. Originally developed at the University of California, Berkeley, PostgreSQL has become one of the most popular database management systems. Its powerful features and extensibility have made it an ideal choice for developing modern applications. PostgreSQL continues to be actively developed and supported by the community, providing users with reliable tools for working with data.
In 1985, when SQL was just beginning to emerge as a standard, a group of engineers at the University of California, Berkeley, led by Professor Michael Stonebraker, began developing the POSTGRES relational database management system. This project was based on Stonebraker's work on INGRES, one of the first relational DBMSs. POSTGRES was an important step in the evolution of relational databases, offering new capabilities for working with and managing data. This project had a significant impact on the further development of technologies for storing and processing information.

By 1988, the development team had published several scientific papers on the POSTQUEL query language, which became The basis for the POSTGRES database management system. The language's name emphasized its modernity and superiority over SQL. POSTGRES was called a "post-relational DBMS" because it was developed to overcome the obvious limitations of SQL at the time. The first version of this innovative database management system (DBMS) was released in 1989, but in 1992, after several updates, the project was closed. Fortunately, the POSTGRES source code was made available under a BSD license. UC Berkeley graduates Andrew Yu and Jolie Chen continued to develop the project, replacing the POSTQUEL language with SQL, which had by then become an international standard. This new version was initially called Postgres95, corresponding to the year of its release, and was later renamed PostgreSQL. Since then, 28 versions of this DBMS have been released, each introducing significant improvements and new features. PostgreSQL has become one of the most popular and reliable relational database solutions, attracting the attention of developers and organizations worldwide.
Currently, the project is supported by a small team of developers, a rarity by modern standards. The team is led by a steering committee (Core Team), which makes key decisions regarding the development and release of new PostgreSQL versions. Developers are divided into regular participants (contributors) and major contributors. There is also a small group of developers (committers) with the right to make changes to the project's source code. These structures ensure effective management and development of PostgreSQL, contributing to its sustainable growth and improved functionality.
The Core Team includes three Russian programmers: Oleg Bartunov, Fedor Sigaev, and Alexander Korotkov. These specialists make a significant contribution to the project, thanks to their experience and knowledge in the field of programming.

At the time of publication of the article, the latest stable version is PostgreSQL 15. On June 29, 2023, the second beta of PostgreSQL 16 was released. This update brings new features and improvements to help developers and database administrators optimize their solutions. Stay tuned to stay up-to-date with the latest changes and capabilities PostgreSQL offers.
How to Install Postgres on Windows and Linux
The installer for all operating systems is available on the official PostgreSQL website in the Latest Releases section. On the main page of the site, click the Download button and select your operating system for download.


In this section, we will cover the installation process for Windows and Linux operating systems in detail. Installing software on Windows and Linux has its own specific features, so it is important to follow the instructions to ensure the application works correctly. We will discuss the necessary steps and recommendations for a successful installation on both platforms, as well as possible problems and their solutions.
To download the PostgreSQL installer, click the Windows icon in the Downloads section. The installer includes important utilities needed to work with PostgreSQL, such as pgAdmin, the command line, and additional tools for database management. Make sure you download the latest version to take advantage of all the latest features and performance improvements.
- PostgreSQL server,
- pgAdmin4 - a graphical tool for database management,
- Stack Builder package manager.
To download the installer, go to the version selection page by clicking the link «Download the installer». You will see a list of available files. It is recommended to select the latest version (in this example, it is version 15.3). Make sure that the bitness of the downloaded file matches the bitness of your operating system.

Run the program installer. In the welcome window, click Next to continue the installation process. Select your preferred installation path or leave the default folder if you don't need to make any changes. Follow the on-screen instructions to complete the installation.

It is important to remember that compliance with current SEO requirements is a key factor in the successful promotion of your content on the Internet. Text optimization helps improve a website's visibility in search engines and attract a target audience. It's essential to use relevant keywords, create high-quality and unique content, and ensure easy site navigation. Regularly updating information and adapting it to current trends also contributes to improved search rankings. An effective SEO strategy includes competitor analysis and continuous content improvement, which will ultimately lead to increased traffic and improved user experience.
When selecting the installation path, make sure not to create a folder in advance. Otherwise, you will encounter the error: "The chosen installation directory exists and is non-empty. Please choose a different directory." Instead, simply specify the folder name, for example: "PostgreSQL/15," and the installer will automatically create the necessary directory. This will avoid problems and simplify the installation process.
Next, you need to select the components to install. By default, all items are checked, but you don't need to install them all. The main ones we need are the Postgres server and pgAdmin. It is also recommended to leave the command line tools, as they will most likely be needed for database administration.

Select a directory to store your created databases. During the training, it is recommended to leave the default path. This will simplify data management and allow you to focus on learning.

In the next step, you will need to create an administrator password. This password will be required to connect to the PostgreSQL server and to log in to pgAdmin 4. We recommend writing it down in a safe place to avoid having to reinstall the system in the future.
The PostgreSQL installer will prompt you to select a language and provide an overview of the settings that will be used for the installation. Click "Next" until the installation process begins, which will take several minutes. After the installation is complete, a folder with PostgreSQL components and documentation will be created in the Start menu.

Let's check the system's functionality. Launch pgAdmin and select the Servers section in the upper left corner of the interface. Enter the user password you set during the initial setup. Make sure you can access the server correctly.

If the password is entered correctly, a dashboard will appear on the screen. This interface provides access to the main functions and data of your system. You can easily manage settings, view reports, and receive up-to-date information. Make sure you are familiar with the dashboard elements to effectively use all the platform's features.

To find out if the server is connected, you can query the database using the SELECT VERSION() command. This command will return information about the version of the installed database management system (DBMS). Checking the connection to the server and obtaining the DBMS version are important steps to ensure correct operation of the database and understanding of its capabilities.

If a response is displayed at the bottom of the screen, this means that the server Successfully connected and ready to process requests. Congratulations on your successful connection!
Installing PostgreSQL on a Linux operating system is most efficiently done through the terminal, using the official repositories of your distribution. To begin, open a Bash terminal and update your system's package lists to ensure access to the latest versions of the software.
To install PostgreSQL, run the following command. Make sure you have the necessary access rights and updated repositories. PostgreSQL is a powerful open-source database management system that supports many features and provides reliable data storage. Installing PostgreSQL will allow you to effectively manage and analyze your data. After executing the command, follow the on-screen instructions to complete the installation.
The -y flag is used to automatically confirm the installation, eliminating the need to manually enter a Y/n response. This greatly simplifies the software installation process, especially in scenarios that require multiple package installations or automated processes. Using this flag ensures faster and more efficient work with package managers.
After the installation is complete, check that the PostgreSQL service is enabled and the server is ready to accepting connections. This is an important step to ensure the correct operation of the database and the ability to interact with it.

Creating a database and user in PostgreSQL is an important step for working with the server through the pgAdmin 4 panel. After installing PostgreSQL on your computer, you have a postgres account, which allows you to manage service processes and create new users. To switch to this user, run the following command:
After running the command, the postgres prefix will appear at the prompt. This indicates that you are in the PostgreSQL environment, allowing you to run commands and queries against the database. Make sure you have configured the connection correctly and have all the necessary rights to work with the data.

A new database is created in the psql command shell. Using psql, you can easily manage databases, run SQL queries, and administer your data. Before creating a database, make sure you have PostgreSQL installed and have access to the command line. Open psql and run the appropriate command to create a new database. This allows you to structure and store data in a convenient format, ensuring a high level of performance and security.

If the prompt for input has changed to postgres=#, this means that you are in the environment The psql command line interface for working with PostgreSQL databases. In this mode, you can execute SQL queries, manage databases, and perform various administrative tasks. Make sure you are familiar with basic psql commands to work effectively with PostgreSQL.
Create a new user in pgAdmin to use for working with the database and set a password for this account.
The shell will repeat the name of each successfully executed command. Make sure you add a semicolon at the end, otherwise it may mistakenly interpret it as continuing to type instructions.

Create a database named skillbox_test_db.
To grant the new user all the necessary privileges in the created database, you need to complete the permissions assignment process.
If the shell confirmed the permissions with the GRANT command, you can exit it by pressing Ctrl + D.
Now you need to install pgAdmin. However, it is worth noting that this program is not available in the standard Ubuntu repositories, so you will need to use the vendor repository - pgAdmin 4 APT. This may require additional steps, but ultimately you will have access to a powerful tool for managing PostgreSQL databases.
To get started, you should install a public GPG key. This key is necessary for verifying the authenticity of the repository and ensuring security when working with packages.
Create a configuration file for the repository, which will be used by the apt utility to obtain the information needed to install packages. This file contains data about the location of packages and their versions, which allows the system to effectively manage the installation and updates of software. Correct configuration file settings ensure stable system operation and access to current package versions.
pgAdmin 4 installation is complete. Now you can use this powerful tool to manage your PostgreSQL databases. Make sure you followed all installation steps and configured the necessary settings. With pgAdmin 4, you can easily administer databases, analyze data, and optimize their operation.
Once the command completes, all the files necessary to run pgAdmin 4 will be on your computer. However, before you begin, you need to run a script that will prepare pgAdmin for correct operation.
During installation, you will be asked to enter your email address and password. The password is required to access the administrative panel, so it is recommended to remember or write it down. Once the process is complete, the script will restart the Apache2 server with the updated settings.
Run pgAdmin 4 by going to the IP address http://127.0.0.1/pgadmin4. In the authorization window that appears, enter the email address and password specified in the previous step. If you enter the data correctly, you will get access to the pgAdmin 4 interface.

pgAdmin 4 is a powerful client for working with PostgreSQL databases, which provides convenient access Data management. To start working with your data, you need to connect pgAdmin 4 to the PostgreSQL server. To do this, simply click the "Add New Server" icon. After that, you will be able to set up a connection by specifying server and authorization parameters, which will allow you to effectively manage your databases.

Specify a name for your server and go to its settings.

Fill in three fields: host name (for a local computer, specify localhost), username, and password. The username and password were set earlier. Please make sure the entered data is correct to successfully connect to the database.

If all the data is entered correctly, information about available databases will be displayed on the left. To test the connection, run the SELECT VERSION() command in the Query Tool to get the version number of the database management system (DBMS).

In this case, the response is as follows
PostgreSQL 14.8 on Ubuntu 22.04.1 is a powerful database management system designed for reliability and performance. This version of PostgreSQL, compiled for the x86_64-pc-linux-gnu architecture using the GCC 11.3.0 compiler, offers improved features and optimizations that make it an ideal choice for developers and database administrators. PostgreSQL 14.8 includes advanced data manipulation capabilities, improved support for parallel processing, and new features to simplify administration. Using this version on Ubuntu ensures stability and security, which is key for modern applications and services.
The PostgreSQL server has been successfully installed and connected to pgAdmin 4, allowing it to accept and process requests.
How to create and link two tables
Now that the database is successfully connected, let's move on to practicing with SQL queries. Consider a situation where Skillbox managers have tasked us with developing a student database that will display information about the course each student is in. To simplify the task, we will assume that each student can only enroll in one course. This will allow us to focus on the basic aspects of working with SQL and effective data management.
For effective data management in the project, it is necessary to create two tables: one will contain information about courses, and the other about students. This will help organize the data and simplify its processing. Creating tables like this will be a great way to practice working with databases and recording information.
We'll create a table with courses, which we'll call Courses. This table will include the following fields:
- course_id — a unique course identifier that is generated automatically and cannot be NULL. This field will act as the primary key;
- course_name — the name of the course. The field cannot exceed 100 characters and its value cannot be NULL;
- hours — the number of hours as an integer;
- price — the cost of the course as a floating-point number;
- is_open — stores information about whether the course is open or closed and cannot contain NULL.
Each student in the table will have a field with the IDs of the courses they are enrolled in. The set of IDs must be strictly limited, and adding non-existent IDs is prohibited. This will ensure data integrity and avoid errors in the course management system.
Creating a table in a PostgreSQL database is done using an SQL query. This can be done either in the psql command shell or in the Query Tool interface in pgAdmin. To do this, you need to use the CREATE TABLE command, which allows you to define the table structure and its fields. Detailed instructions for installing and running PostgreSQL on a Linux operating system can be found in the relevant documentation. Correctly creating tables is an important step in database design, as it determines how the data will be stored and processed in the future.
Another way to work with tables is through a graphical interface. To do this, go to the "Schemas" section in the sidebar and right-click on the "Tables" section. In the context menu that opens, select the option to create a new table.



In the general settings section, specify a name for the table, then go to the Columns section. In this section, you can create and configure the necessary fields for your table.
Let's create and configure the course_id field. To do this, click the "+" button in the upper right corner of the modal window. In the line that opens, specify the parameters that meet the requirements: the field must be a primary key and does not allow a NULL value. This will ensure the uniqueness and reliability of the data in your database.

Add automatic value generation by clicking on the pencil icon (edit row). This will open the section with detailed settings. Go to the «Restrictions» section and select the «IDENTIFY» type. You have now successfully created an automatically generated primary key.

Fill in the remaining fields yourself.
Tip 1: Use keywords related to your topic to improve Search engine visibility. Optimize titles and meta descriptions to attract the attention of your target audience. Make sure your content is easy to read and structured, which helps visitors better absorb the information. Including internal and external links will also help increase the authority of your page and improve its ranking. Don't forget about the relevance and uniqueness of your content, as these are important factors for SEO.
For text fields with a variable but limited length, it is advisable to use the character varying and varchar data types. These types provide flexibility in storing string values, allowing for efficient use of memory and maintaining optimal database performance. The choice between character varying and varchar depends on the specific requirements of the project, but both types are ideal for storing text information with variable length.
Hint 2 is an important element that can help you in various situations. It serves to clarify information, provide additional recommendations or directions. Using hints improves the user experience, making the process more understandable and efficient. Hint 2 can be applied in a variety of contexts, including learning, programming, and everyday life. It's important that it's clear and concise so users can easily understand the information and put it into practice. Proper formatting and content of Hint 2 contribute to the user experience and improve the quality of work. PostgreSQL supports two types of floating-point numbers: real and double precision. These data types allow you to efficiently store and process numbers with fractional parts. The real type is a single-precision floating-point number, occupying 4 bytes of memory, while double precision is a double-precision floating-point number, occupying 8 bytes. The choice between these types depends on the required precision and the range of values to be processed. Using the correct data type in PostgreSQL improves performance and avoids calculation errors.
As a result, you will have a set of fields.

The second table, called students, will store data about students, as well as links to the corresponding courses from the courses table. This structure will allow you to effectively manage information about students and their courses, providing easy access to the necessary data. Each record in the students table will contain a unique student identifier, their name, contact information, and links to the courses they are enrolled in. Thus, the interaction between the students and courses tables will help simplify the process of searching and analyzing educational information.
- student_id — unique student identifier (primary key);
- name — student's name;
- middlename — patronymic;
- lastname — last name;
- contacts — contacts (phone, email, social media links, etc.);
- course — courses (a set of id's from the course table). This field acts as a foreign key that links the tables together.
Since one student can have multiple contacts, it is recommended to use the character varying[] type (an array of strings of limited length) for the contacts field. This will allow you to effectively store and process information about different ways of contacting each student. Using a string array will provide flexibility and convenience when adding or changing contact information without the need to create additional tables in the database.
Let's create a new table and configure the columns according to the specified conditions. This will optimize the data structure and simplify subsequent work with the information. Proper column configuration will ensure convenient access to data and improve the efficiency of its processing.

To establish a relationship between the course column and the courses table, go to the «Constraints» tab and select «Foreign Key». Then click the add button to create a new constraint.

Name the constraint whatever you want - it won't affect its functionality. Next, link the columns: in the «Local Column» field, enter Specify the course value, in the "References To" section, select the courses table, and in the "Dependent Column" field, specify course_id. This way, you have successfully created and linked the two tables.
To query information from the same server, you can use the SQL language. SQL allows you to effectively interact with databases, performing various operations, such as selecting, updating, and deleting data. Using SQL queries, you can retrieve the required data, filter it according to specified criteria, and perform aggregate functions to analyze the information. This makes SQL a powerful tool for working with large volumes of data on the server, ensuring fast and accurate query processing.
What to read and where to follow the news
Many experienced developers advise referring to documentation instead of books, and there are several good reasons for this. First, documentation is always current and updated with new technology releases, allowing developers to access the most up-to-date information. Second, it provides concrete examples and practical recommendations that can be useful during development. Third, documentation is typically structured to quickly find answers to frequently asked questions. Furthermore, studying documentation promotes a deeper understanding of tools and libraries, which ultimately improves code quality and speeds up the development process. Therefore, using documentation instead of books can significantly improve the effectiveness of developer training and practical work. Official documentation is regularly updated and typically reflects the latest changes to the project. While books become obsolete with the release of new software versions, the documentation is always at hand (online or in PDF format) and is organized into a convenient reference, making it quicker to find answers to questions. And the best part is, it's free. The official PostgreSQL guide is a valuable resource, surpassing any books on the installation, configuration, and administration of this database management system. The PDF version of the document contains almost 3,000 pages, making it the most comprehensive source of information. No other publication can offer such volume and depth of coverage of PostgreSQL-related topics. Technical literature on PostgreSQL can truly be useful. Some textbooks significantly simplify the learning process, introducing beginners to the topic gradually and avoiding unnecessary information at the initial stage. This approach allows you to better master the basic concepts and functions of PostgreSQL, making it easier to further explore more complex aspects of the database. There are numerous books that can capture your attention and enrich your experience. These works offer unique ideas and depth, making them worth reading. Consider a few recommended for broadening your horizons and developing your skills. Each of these books offers valuable information and inspiration, making them essential for your personal library. Don't miss the opportunity to read these works to deepen your knowledge and develop critical thinking.
- "PostgreSQL for Beginners" — P. Luzanov, E. Rogov, I. Levshin.
- "PostgreSQL: Basics of the SQL Language" — E. P. Morgunov.
- "Query Optimization in PostgreSQL" — G. Dobrovskaya, B. Novikov, A. Beylikova.
- "Learning PostgreSQL 10" — Salahaddin Dzhuba.
A short comment on the last point. Although the book "Learning PostgreSQL 10" is focused on the tenth version of PostgreSQL, it contains such fundamental principles that it remains relevant even today, when at the time of publication of the article, beta version 16 was available. The fundamental concepts presented in this publication will help both beginners and experienced users better understand PostgreSQL databases.
Follow the latest PostgreSQL news on the official website or on the project's Twitter account. A VPN is recommended for accessing Twitter. If you have technical questions, you can contact the Russian-language community on Telegram at https://t.me/pgsql. Here you will receive prompt answers and have the opportunity to discuss current topics with other PostgreSQL users.
Learn more about programming and coding in our Telegram channel. Subscribe to stay up-to-date with useful content and breaking news from the world of technology.
Read also:
- What is SQL: How it works, why it's needed, and how to work with it
- "I completed the course module and started sending out resumes": A musician who became a Pythonist
- Python for beginners: Applications and capabilities
A court has ruled to ban Meta Platforms Inc.'s activities in Russia, related to the sale of the social networks Facebook and Instagram. This decision is based on accusations of extremist activity, which has serious consequences for users of these platforms. The ban affects not only access to social networks, but also opportunities for business and communication within the country.

