SQLite

IntroducedThis document describes the basic architecture of the SQLite library. Very helpful to those who want to understand and modify SQLite.The following chart shows the components of SQLite and the relationships between them.Interface (INTERFACE)

A simple introductionSQLite database is a very small embedded open source database software, that is, there is no independent maintenance process, all the maintenance is from the program itself. It is a relational database management system that

SQLite database is essentially a disk file, so all the database operation will be converted to the operation of the file, and frequent file operations will be a good process, will greatly affect the speed of database access. For example, insert 1

Use steps1. Introduce the header file: Add the frameworks and libraries that will be used under the project Build phases. I've added the sqlite3 I'm going to use in the project.2. Specify the database storage path: The database is generally stored

① Open the C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config directory and find the machine.config file New is as follows:② official website Download the SQLite . NET Framework version 4.0 as shown in:③ download complete after installation,

Define a class:usingSystem.Data.SQLite;namespacedal{/// ///SQLite Chinese Sort/// [Sqlitefunction (Functype = functiontype.collation, Name ="PinYin")] Public classsqlitepinyingsort:sqlitefunction { Public Override intCompare (stringXstringy)

Basic use of SQLiteiwviewcontroller.m//01-sqlite Basic use////Created by Apple on 14-5-22.//Copyright (c) 2014 itcast. All rights reserved.//#import "IWViewController.h" #import @interface Iwviewcontroller () {///member variable default =n ULL

A constantstring constants, enclosed in single quotation marks. If there is a single quotation mark in the constant, use two single quotation marks to represent it. Case sensitive)Numeric constantsBinary constantsTwo key wordsKeyword is not case

Import Sqlite3def Test1 (): con = sqlite3.connect ("d:\\test.db") con = sqlite3.connect ("Memory") cur =con.cursor () Try: Cur.execute (' CREATE TABLE score (ID integer primary key,name varchar (TEN), scores integer) ') Cur.execute ("INSERT INTO

Delphi in the XE version, has implemented the Android and Apple Mobile cross-platform, so only need a code, can dominate the two mobile phone platform, is indeed an efficient approach and saving strategy.With Delphi XE7 Connect SQLite, mainstream

When a large amount of data is deleted from the SQLite database, if the database file is not smaller, you can perform a VACUUM command that will reorganize the database and free up extra space.Test Insert Data try {sqliteconnection

I used to be SQL Server database, but the customer there think that the installation of this large database comparison card, said to lead to blue screen, hard to SQL Server, no way customer is God, give him a small point of the database it! Consider

Installation and use of SQLite database on Linux platformSQLite is a lightweight database, it is designed to be embedded, and it has been used in many embedded products, it occupies a very low resource, it may only need hundreds of K of memory is

Using system;using system.collections.generic;using system.data.sqlite;using system.data;namespace Com.zcwl.rock.helper{public class Sqlitehelper{private static string connectionString = String. empty;//////Sets the connection string based on the

Configure NHibernate to connect SQLite database files, take hsqlite.cfg as an example:XML version= "1.0" encoding= "Utf-8"?>hibernate-configurationxmlns= "urn:nhibernate-configuration-2.2" > session-factoryname= "Nhibernate.test"> Propertyname=

The error prompts are as follows:Could not load file or assembly ' system.data.sqlite,version=1.0.66.0,culture=neutral,publickeytoken=db937bc2d44ff139 ' Or one of its dependencies. Trying to load a program that is not properly formattedReason:System.

SQLite, a lightweight database, is an associative database management system that adheres to acid, and the SQLite engine is not a separate process for communicating with it, but rather a major part of the program, and its main communication protocol

This article does not involve a number of conceptual things, please forgive us a lotThis is the simple frame of Android SQLite.Using SQLite is about 3 stepsThe first step: Create your own Sqliteopenhelper classStep two: Create a DAO layer in the

Reference:Situation: If multiple threads are read and write at the same time (this refers to a different thread using a different Helper instance), the following will encounter Android.database.sqlite.SQLiteException:database is Locked such an

An overview of the ORDER BY statement The order BY statement is used to sort the result set based on the specified column. The order BY statement sorts records by default in ascending order. If you want to sort records in descending