Small. Fast. Reliable.
Choose any three.

Search results 91..100 of 103 for: "x\"

3.1. Creating An R*Tree Index  ... CREATE VIRTUAL TABLE demo_index USING rtree( id, -- Integer primary key minX, maxX, -- Minimum and maximum X coordinate minY, maxY -- Minimum and maximum Y coordinate );
Books About SQLite
(books.html)
 ... SQLite runs on Linux, Windows, Mac OS X, and a few other operating systems. It has been widely used in low-to-medium tier database applications. This Short Cut discusses design principles, engineering trade-offs, implementation issues, and operations of ... 
SQLite Older News
(oldnews.html)
 ... Ticket 31338dca7e describes a problem with queries that have a WHERE clause of the form (x AND y) OR z where x and z come from one table of a join and y comes from a different table. Ticket eb5548a849 ... 
Custom Builds Of SQLite
(custombuild.html)
 ... Or, if SQLite is used on an operating system other than Unix (Linux or Mac OS X), Windows (Win32 or WinCE), or OS/2 then none of the interface subsystems that come built into SQLite will work and the application ... 
 ... db1 eval {INSERT INTO t1 VALUES(1,'hello')} db1 eval {INSERT INTO t1 VALUES(2,'goodbye')} db1 eval {INSERT INTO t1 VALUES(3,'howdy!')} set x [db1 eval {SELECT * FROM t1 ORDER BY a}] The variable $x is ... 
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off  ... SQLITE_ENABLE_OFFSET_SQL_FUNC This option enables support for the sqlite_offset(X) SQL function. The sqlite_offset(X) SQL function requires a new interface on the B-tree storage engine, a new opcode in the virtual machine that runs SQL statements, and a new ... 
 ... However, if the application calls sqlite3changeset_new(), sqlite3changeset_old() or sqlite3changeset_conflict on a changeset iterator directly (including on a changeset iterator passed to a conflict-handler callback) then the X'' value is returned. The application must translate X'' to NULL itself if ... 
35% Faster Than The Filesystem
(fasterthanfs.html)
2.1. Read Performance Measurements  ... With these optimizations, SQLite is twice as fast as Android or MacOS-X and over 10 times faster than Windows. Chart 3: SQLite read latency relative to direct filesystem reads. 100K blobs, avg size 10KB, random order using sqlite3_blob_read() from ... 
Atomic Commit In SQLite
(atomiccommit.html)
10. Future Directions And Conclusion  ... The current VFS implementations for Unix (Linux and Mac OS X) and Windows make pessimistic assumptions about the behavior of those systems. After consultation with experts on how these systems work, we might be able to relax some of the ... 
 ... One should note that POSIX advisory locking is known to be buggy or even unimplemented on many NFS implementations (including recent versions of Mac OS X) and that there are reports of locking problems for network filesystems under Windows. Your ... 

12345678910

Page generated by FTS5 in about 175.52 ms.