Skip to navigation Skip to content
Simon Technology Blog
  • Architecture
  • Cloud
  • Database
  • Develop
  • Hardware
  • Industry
  • Language
  • Mobile
  • Opensource
  • OS
  • Web
Main Navigation

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

What is the difference between SQLITE3 and Python 2.5, Pysqlite and APSW?

I want to know the difference between python2.5, pysqlite and apsw sqlite3?
When I try to install pysqlite on windows vista using python2.5, I have a bumpy run, please refer to the following:

<

September 22, 2021By Simo Sqlite APSW, Difference, Pysqlite, python, Python 2.5, SQLITE, SQLITE3, whatLeave a Comment

SQLite import tab file: .IMPORT is a plurality of inserts or use transactions to group them?

I import millions of rows from a tab file, and the SQLite .import .mode tab is very slow. I have three indexes, so maybe the index is slow. But first I want to check Does .import group batches/all

September 22, 2021By Simo Sqlite card, execution, file, Group, import, INSERT, line, one, options, or, SQLITE, transaction, useLeave a Comment

Use of SQLITE and SQLite Database Clean up under .NET

Original text: The use of Sqlite under .NET and the cleanup of Sqlite database

Sqlite is a lightweight relational database, and I will not go into details about its benefits. The original int

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

Posts navigation

Page 1 … Page 7 Page 8 Page 9 Page 10
Recent Posts
  • Sencha-Touch-2 – Sencha Touch 2, Nested XML Analysis NodeValue
  • Add a separation line and format XML content
  • Is there a norm of simplified XML subsets?
  • Look at it when you write React
  • ReactJS – Present React Redux React-Router App to add the server to the Firebase hosted by the Firebase
Categories
  • Android
  • Apache
  • Apache Kafka
  • Asp
  • Auto-Test
  • Automated Build
  • Aws
  • Bitcoin
  • Browser
  • C & C++
  • C#
  • Centos
  • Cgi
  • Character
  • Cloud Service
  • Cocos2dx
  • Cordova
  • CSS
  • Data Structure
  • Delphi
  • Design Pattern
  • Dojo
  • Dubbo
  • ELK
  • Flex
  • football
  • Game
  • Hadoop
  • Hibernate
  • HTML
  • Hybrid
  • Intel
  • IOS
  • Ipad
  • iPhone
  • Java
  • Javascript
  • Jetty
  • JQuery
  • Jsp
  • Linux
  • Load Balance
  • Lua
  • Macbook
  • Macos
  • Mathematics
  • Micro Services
  • Monitoring
  • Motherboard
  • Mysql
  • Network Hardware
  • Network Marketing
  • Nginx
  • NodeJs
  • Nosql
  • Oracle
  • Os Theory
  • Performance
  • PHP
  • Postgresql
  • Power Designer
  • React
  • Redis
  • Regexp
  • Rom
  • Rss
  • Ruby
  • Search Engines
  • Shell Script
  • Silicon Valley
  • Silverlight
  • Software Design
  • Spring
  • Sql
  • Sqlite
  • Sqlserver
  • Storage
  • Storm
  • Surface
  • SVN
  • Swift
  • System Architecture
  • Tablet
  • Uncategorized
  • Unix
  • Visual Basic
  • Visual Studio
  • Web Crawler
  • WebService
  • Windows
  • Wireless
  • XML
  • ZooKeeper
Archives
  • October 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • September 2020
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
© Simon Technology Blog 2025 • ThemeCountry Powered by WordPress