SlimApp

Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the p

Marshal UTF8 Strings in .NETWow, what a pain in the butt. .NET strings are stored internally as UTF16, not UTF8, so if you're marshaling strings to and from a library that wants strings as UTF

之前写了在C#中调用libsqlite3中函数的一些代码:[DllImport("sqlite3.dll")]  private extern staticstring sqlite3_column_text(IntPtr pStmt, int iCol); [DllImport("sqlite3.dll")]  privatee xtern static stri

sqlite3中有5种数据类型：int real text null blob但sqlite3中的列的数据类型不是固定的，列的数据类型随着实际插入的数据的格式而定； 在sqlite3中使用sql时，有一个非常有趣而有强大的概念：相似类型。引入相似类型的概念，主要是为了兼容各种数据库（sqlserver oracle mysql等）的sql语法。  sqlite3中常用的

Destroy A Prepared Statement Objectint sqlite3_finalize(sqlite3_stmt *pStmt);The sqlite3_finalize() function is called to delete a prepared statement. If the most recent evaluation of the sta

Opening A New Database Connectionint sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */);int sqlite3_open16( const vo

Result Values From A Queryconst void *sqlite3_column_blob(sqlite3_stmt*, int iCol);int sqlite3_column_bytes(sqlite3_stmt*, int iCol);int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);double s

Evaluate An SQL Statementint sqlite3_step(sqlite3_stmt*);After a prepared statement has been prepared using either sqlite3_prepare_v2() or sqlite3_prepare16_v2() or one of the legacy interf

Error Codes And Messagesint sqlite3_errcode(sqlite3 *db);int sqlite3_extended_errcode(sqlite3 *db);const char *sqlite3_errmsg(sqlite3*);const void *sqlite3_errmsg16(sqlite3*);The sqlite3_e

Closing A Database Connectionint sqlite3_close(sqlite3 *);The sqlite3_close() routine is the destructor for the sqlite3 object. Calls to sqlite3_close() return SQLITE_OK if the sqlite3 object

Compiling An SQL Statementint sqlite3_prepare( sqlite3 *db, /* Database handle */ const char *zSql, /* SQL statement, UTF-8 encoded */ int nByte, /* Maximum len

from: http://www.sqlite.org/cintro.htmlAn Introduction To The SQLite C/C++ InterfaceThis article provides an overview and roadmap to the C/C++ interface to SQLite.Early versions of SQLite were v

在unity中尝试使用sqlite，本打算用Mono.Data.Sqlite，但发现Mono.Data.Sqlite有bug，把unity 项目导出成iOS项目，编译后，运行程序就挂了，只好自己在C#直接调用底层的libsqlite3库。using UnityEngine;using System.Runtime.InteropServices;using Syst