Category: Sqlite

SQLite, a lightweight database, is a relational database management system that complies with ACID. It is contained in a relatively small C library. It is a public domain project established by D. Richard Hipp. Its design goal is embedded, and it has been used in many embedded products. It occupies very low resources. In embedded devices, only a few hundred K of memory may be enough. It can support mainstream operating systems such as Windows/Linux/Unix, and can be combined with many programming languages, such as Tcl, C#, PHP, Java, etc., as well as ODBC interfaces. It is also compared with the two open source Mysql and PostgreSQL In terms of world-famous database management systems, its processing speed is faster than them.

Add a custom SQLITE function to the QT application

I am trying to add a custom sqlite3 regexp function to my Qt application (as suggested in this answer). But when I call the sqlite3_create_function function, I get the message that the program Fini

September 22, 2021By Simo Sqlite Add, Applications, customize, functions, Programs, QT, SQLITE, willLeave a Comment

Use SQLite3 and IronPython 2.6 for .Net4

I am using SharpDevelop 3.2.0, Iron Python 2.6.1 for .Net4.

To use this module to access IronPython, please visit the sqlite3 function:
IronPython.SQLite

My program is a GUI applicatio

September 22, 2021By Simo Sqlite 2.6, IronPython, NET4, SQLITE, SQLITE3, useLeave a Comment

ListActivity and Adapter and SQLite

Summary ListActivity, AdapterView, adapter, multiple activities, SQLite, GUI style, menu resources and MenuInflater.

All resource files use the tag, and style elements use the tag . All att

September 22, 2021By Simo Sqlite Adapter, and SQLite, ListActivity, useLeave a Comment

Can I use anything other than BIGINT as a primary key data type in SQLite?

I am very excited about the possibility of using SQLite as a database solution during development, so I can focus on writing code first and use NHibernate’s ShemaExport feature to dynamically gener

September 22, 2021By Simo SqliteLeave a Comment

Switch DELETE and LIKE in the SQLite statement

I tried to merge the two into a single statement, and I would even be satisfied with two separate statements… I know it must be possible, but how?

This is what I tried:

DELETE FROM my

September 22, 2021By Simo Sqlite delete, medley, SQLITE, statementLeave a Comment

Sqlite, exclusive or. How do I clear the flag?

Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR? sqlite

September 22, 2021By Simo SqliteLeave a Comment

SQLITE3 cannot be imported in Python 3

sqlite works fine with python 2.7, but when I try to import it in python 3, it will give an error

> Traceback (most recent call last): File “dbConnection.py”, line 1,
> in
> import sqlite3 F

September 22, 2021By Simo Sqlite China, python, SQLITE, SQLITE3, UnableLeave a Comment

September 22, 2021By Simo Sqlite cleanup, database, SQLITE, useLeave a Comment