SQLite

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 »

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 …

How To Use Python To Execute Sql Script Read From External SQL File In SQLite Database 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.

SQLite is different from Oracle, MySQL, and other server-level databases. SQLite is just an embedded database engine, which is especially suitable for accessing an appropriate amount of data on devices with limited resources (such as mobile phones, PDAs, etc.).