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

Tag: SQLITE

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

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

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

SQLITE3 date and interval function

I want to know whether sqlite3 supports the interval function. PostgreSQL accepts the following statement, but sqlite3 cannot parse it;

select< br /> …
from
orders
where
…
and o_order

September 22, 2021By Simo Sqlite Date, function, Interval, SQLITE, SQLITE3Leave a Comment

How to delete all empty tables in SQLITE?

I want to delete all tables without rows.

How to delete all empty tables in SQLite?

Edit
I need to do this on my mobile phone (without casing). On a Windows Mobile phone.

1) Get a

September 22, 2021By Simo Sqlite How to delete, in space, SQLITE, tableLeave a Comment

SQLAlChemy SQLite multi-threaded settings

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine
from sqlalchemy import Column, String, Integer
from sqlalchemy.pool import SingletonThreadPool < p>

<

September 22, 2021By Simo Sqlite multi-thread, setting, SQLALCHEMY, SQLITELeave a Comment

Posts navigation

Page 1 … Page 7 Page 8 Page 9
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