Part 2: Connect to the PostgreSQL Database After these two steps were complete I was able to successfully use Psycopg. In terminal I ran the command brew install postgresql to install the Homebrew implementation of PostgreSQL and then the command pip install psycopg2 to reinstall the Python adapter. Although I had already installed the Postgres App, a directory containing one or more of psycopg2’s dependencies was missing. Thankfully I stumbled across an answer that suggested the Homebrew installation process. I initially tried to install these dependencies and ran into the same difficulties that users on StackOverflow and the project’s GitHub complained about. According to the documentation, “Psycopg is a C wrapper around the libpq PostgreSQL client library.” Underneath this header the dependencies were included. I naturally decided to use the default pip package-management system for installation, however the numerous dependencies of Psycopg were not included. When I initially searched for this package I was directed to the project’s PyPI site. At the time of this writing the current version is psycopg2. This tool allows us to connect the capabilities of the Python language and libraries to obtain, manipulate, input, and update data stored in a PostgreSQL database. Psycopg is a PostgreSQL adapter for the Python programming language. Prerequisite: Before you attempt to install the Python adapter you must install Postgres, which I detailed in a previous post. In this article I will detail the process of setting up psycopg2 and building a query function with these tools. The Pandas library, for instance, has native methods which allow us to display and manipulate the results of a query directly from a SQL database. You can use Python libraries on the data obtained from SQL queries. Over the past few weeks I used the psycopg2 module to interact with PostgreSQL database management systems.
There are several Python packages available that interface with SQL databases. “The PostgreSQL Pachyderm Whose Trunk Becomes the Python Python” - Image Source: “ Python and PostgreSQL without ORM,” Moses Gitau (Jun 5, 2018)
0 kommentar(er)
