Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Spellfix1 Virtual Table
(spellfix1.html)
10. Experimenting with the editcost3() function
... But editdist3 can also be tested directly using the built-in "editdist3()"
SQL function. The editdist3() SQL function has 3 forms:
editdist3('TABLENAME');
editdist3('string1', 'string2');
editdist3('string1', 'string2', langid);
The first form loads the edit distance coefficients from a ...
|
|
Run-Time Loadable Extensions
(loadext.html)
1. Overview
... This feature allows the code for extensions to be developed and
tested separately from the application and then loaded
on an as-needed basis.
Extensions can also be statically linked with the application.
The code template shown below will work ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
4.4. Other SQL database engines don't work this way
... This can cause problems when
developers use SQLite for prototyping and testing and then migrate their
application to a more restrictive SQL engine for deployment. If the
application was (unintentionally) taking advantage of the flexible
typing available in SQLite, then ...
|
|
The SQLite R*Tree Module
(rtree.html)
6.1. The Legacy xGeom Callback
... The third argument, aCoord[], is an array of nCoord coordinates that defines
a bounding box to be tested. The last argument is a pointer into which
the callback result should be written. The result is zero
if the bounding-box ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... The information provided by this
opcode is intended for testing and debugging use only.
Filter
Compute a hash on the key contained in the P4 registers starting
with r[P3]. Check to see if that hash is found ...
|
|
SQLite's Built-in printf()
(printf.html)
1.1. Advantages
... This is important for consistency and for testing. It would be problematic
if one machine gave an answer of "5.25e+08" and another gave an answer
of "5.250e+008". Both answers are correct, but it is better when ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... Windows) SQLite assumes that temporary file names are unique
without actually testing for collisions, so it is important to have
good-quality randomness even if the random() and randomblob()
functions are never used.
The xSleep method is used to suspend ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... This option can be used to overload the default mutex allocation
routines with a wrapper used to track mutex usage for performance
profiling or testing, for example. If SQLite is compiled with
the SQLITE_THREADSAFE=0 compile-time option then
the ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... 3.5 Testing for a complete SQL statement
The next interface routine to SQLite is a convenience function used
to test whether or not a string forms a complete SQL statement.
If the sqlite_complete function returns true when its input ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... With
the QPSG active, SQLite will always use the same query plan in the field as
was used during testing in the lab.
The first argument to this setting is an integer which is 0 to disable
the QPSG, positive ...
|
Page generated by FTS5 in about 122.12 ms.