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 …
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.
This article will tell you how to create user-defined SQLite3 aggregation functions in python, it will also show you an example of how to use it.
This article will tell you how to fix the ImportError: DLL load failed while importing _sqlite3: The specified module could not be found when you run eclipse to develop a python project through PyDev with the anaconda virtual environment. The error happens on Windows OS.
This article will show you examples of how to define custom SQLite functions in python, it will also tell you how to redefine SQLite database built-in functions to overrides its original function.
The python SQLite database module’s cursor object contains a executescript() method, this method is not a standard API method, which means that it may not be available in other database API modules. But this method is practical, and it can execute a SQL script in a string or read from an external SQL file. This …
The regular expression is a special character sequence, which can help you easily check whether a string matches a pattern. Python has added the re module since version 1.5, which provides Perl-style regular expression patterns. The python re module makes the Python language have all regular expression functions.
This example will tell you how to calculate a list of number’s average values in python.
In the previous article How To Manage SQLite Database In Python we have learned how to connect, manage SQLite database in python. In this article, I will tell you how to execute insert, delete, update and query statements to SQLite database in Python.