Small. Fast. Reliable.
Choose any three.

Search results 51..60 of 103 for: "x\"

 ... If database connection X is holding a read transaction, it is possible that some other database connection Y might change the content of the database while X's transaction is still open, however X will not be able to see ... 
The RBU Extension
2.3. RBU Update C/C++ Programming  ... Register any required virtual table modules with the database handle returned by sqlite3rbu_db(X) (where argument X is the sqlite3rbu pointer returned from sqlite3rbu_open()). Also, if required, register the rbu_delta() SQL function using sqlite3_create_function_v2(). Invoke the sqlite3rbu_step(X) function one ... 
4. Usage  ... SELECT obj.* FROM obj, carray($PTR, 10) AS x WHERE obj.rowid=x.value; This query gives the same result: SELECT * FROM obj WHERE rowid IN carray($PTR, 10);
Row Values
3.1. Scrolling Window Queries  ... What really happens with "LIMIT x OFFSET y" is that SQLite computes the query as "LIMIT x+y" and discards the first y values without returning them to the application. So as the window scrolls down toward the bottom of ... 
WAL-mode File Format
1. Files On Disk  ... The main database file with an arbitrary name "X". The write-ahead log file, usually named "X-wal". The wal-index file, usually named "X-shm".
SQLite Download Page
 ... For version 3.X.Y the filename encoding is 3XXYY00. For branch version 3.X.Y.Z, the encoding is 3XXYYZZ. The date in template (4) is of the form: YYYYMMDDHHMM For convenient, script-driven extraction of the downloadable file ... 
C API: Synchronization Type Flags
 ... If the lower four bits equal SQLITE_SYNC_FULL, that means to use Mac OS X style fullsync instead of fsync(). Do not confuse the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags with the PRAGMA synchronous=NORMAL and PRAGMA synchronous=FULL settings. The synchronous pragma ... 
3.1. The URI Path  ... On windows, if the absolute path begins with "/X:/" where X is any single ASCII alphabetic character ("a" through "z" or "A" through "Z") then the "X:" is understood to be the drive letter of the volume containing the file ... 
1.3. Subqueries  ... sqlite> EXPLAIN QUERY PLAN SELECT count(*) > FROM (SELECT max(b) AS x FROM t1 GROUP BY a) AS qqq > GROUP BY x; QUERY PLAN |--CO-ROUTINE qqq | `--SCAN t1 USING COVERING INDEX i2 |--SCAN qqqq `--USE TEMP ... 
C API: Enable Or Disable Shared Pager Cache
 ... This method is disabled on MacOS X 10.7 and iOS version 5.0 and will always return SQLITE_MISUSE. On those systems, shared cache mode should be enabled per-database connection via sqlite3_open_v2() with SQLITE_OPEN_SHAREDCACHE. This interface is threadsafe on ... 


Page generated by FTS5 in about 124.21 ms.