We can use the order by child clause to sort the query results in the SQL statement, but it can only sort the query results by the simple and fixed order. How about ordering the query results in a complex sort order? This article will tell you how to implement it in the SQLite database […]
SQLite Custom Sort Order In Python Example Read More »
The python defaultdict class is a subclass of dict class, it supports all the functions that dict class provides. But when you provide a key that does not exist in the python dict object, the dict object will return a KeyError. But the defaultdict object provides a default_factory attribute which is a python function and
Python Defaultdict Example Read More »
My website runs slowly these days. I use WHM —> Server Status —> Daily Process Log to diagnose the issue and find there are a lot of processes that cost the most CPU percentage to run command php-fpm: pool. This article will tell you how to fix the php-fpm: pool command cost high CPU usage issue.
How To Fix WordPress Website PHP-FPM Bottleneck With Child Process Read More »
The python Counter class in the Collections package is a very useful tool class, which can automatically count the number of occurrences of each element in the container. The essence of Counter is a special python dictionary object, except that its keys are all the elements it contains, and its value records the number of occurrences
How To Make A Counter In Python Read More »
I have told you how to install, start, stop XAMPP on macOS in the first part of the article How To Connect To MySQL Server After Install XAMPP On Mac OS. In this article, I will tell you how to install and uninstall the WordPress website on the macOS XAMPP server. It also tells you
How To Install And Remove WordPress Website On macOS Using XAMPP Read More »
The python collections.ChainMap class can combine multiple python dictionary objects into one dictionary object, this article will tell you how to use it with some examples.
ChainMap Python Example Read More »
This article will show you an example about how to call MySQL stored procedure in python. It will use both the python mysql-connector-python library and the python pymysql library.
How To Call MySQL Stored Procedure In Python Read More »
When I run a python program in my eclipse Pydev project, I meet an error message ImportError: DLL load failed: %1 is not a valid Win32 application. This error occurs when I use the python sqlite3 module in my program. This article will tell you how to fix it.
When you run a python program on Windows, you may want to know whether the Python version is 32-bit to 64-bit, because some issues may happen when you run the python program with the wrong python bit version. This article will tell you how to check whether you python is 32-bit or 64 bit after
How To Check If Python Is 32 Or 64-bit Windows Read More »
I install an eclipse with the PyDev plugin on a new PC. After that when I import the existing python example project, it shows me an error message Interpreter: python-anaconda not found on the eclipse window left side Project Explorer panel. This article will tell you how to fix it.
How To Fix Eclipse Pydev Interpreter Not Found Issue Read More »
