Python Tutorial

When I use the pip command to install a python module ( pip install requests )  or upgrade pip ( python -m pip install –upgrade pip ) in windows, I meet the below error message. Could not install packages due to an EnvironmentError: [WinError 5] Access is denied: ‘C:\\Program Files (x86)\\Python37-32\\Lib\\site-packages\\pip\\__init__.py’ Consider using the `–user` […]

Configuration file in python is a text file which contains section and seciton’s options. The file extension is .ini. This is same with windows .ini file. One configuration file can contains multiple sections. And python configparser.ConfigParser class provide methods to read, write, update and remove the .ini file content. This article will show you some

Psycopg is a popular python postgresql database driver library which provide access to postgresql database server. Use psycopg, you can connect to postgresql database and execute sql statement easily in python source code. This article will tell you how to connect to postgresql database server use psycopg2, it also tell you how to run sql

When I connect to my local PostgreSQL database server with command $ psql postgres ‘postgres’ I encounter the error message psql: FATAL: Peer authentication failed for user “postgres”. :~$ psql postgres ‘postgres’ psql: FATAL: Peer authentication failed for user “postgres” After investigating I finally find the solution to fix this error. This error is because

PostgreSQL is a popular open-source RDBMS database widely used in programming. It is supported by multiple programming languages such as python, java, etc. This article will tell you how to install and manage PostgreSQL on Ubuntu Linux both with command line and pgAdmin3 ( a graphical user interface tool).

Python dictionary is something like java map. It can hold key value pair values. This example will tell you some basic python dictionary object operations. It includes how to create, add, change and remove python dictionary key and values.

When you operate on a python string, it will create a new python string based on the original string. The original string value will not be changed. This article will list some python string operation example.