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.
How To Create User Defined SQLite Aggregate Function In Python Read More »
I add a dependency in my eclipse maven project pom.xml file, and when I save the project, eclipse downloads all the dependency required jar files under the eclipse project —> Maven Dependencies folder. But when expand the Maven Dependencies folder I found all the dependency required jar files are grayed out. And the class in
How To Fix Issue Eclipse Maven Dependencies Jar Files Grayed Out Read More »
Recently I installed some eclipse plugins and after that my eclipse is crashed. When I restart the eclipse again, it shows a popup dialog with the error message An error has occurred. See the log file C:\Users\zhaosong\eclipse-workspace\.metadata\.log. This article will tell you how to fix this error.
How To Fix Can Not Start Eclipse WorkSpace After Install Eclipse Plugin Issue Read More »
When I create a java Maven project in eclipse, I meet a could not calculate build plan error. The detailed error message is displayed below. After some investigation, I finally find the method to solve this error.
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.
How To Define Custom SQLite Function And Redefine Existing SQLite Function In Python Read More »
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
How To Use Python To Execute Sql Script Read From External SQL File In SQLite Database Read More »
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.
How To Use Regular Expressions In Python Read More »
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.
How To Use Python To Insert, Delete, Update, Query Data In SQLite DB Table Read More »
