Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... If sqlite3_step() or sqlite3_reset() or sqlite3_finalize()
are called from a different thread while any of these routines
are pending, then the results are undefined.
The first six interfaces (_blob, _double, _int, _int64, _text, and _text16)
each return the value of ...
|
|
Defense Against The Dark Arts
(security.html)
1.1. Untrusted SQL Inputs
... Alternatively,
set a timer in a separate thread and invoke sqlite3_interrupt() when
the timer goes off to prevent the SQL statement from running forever.
Limit the maximum amount of memory that SQLite will allocate using
the sqlite3_hard_heap_limit64() interface. This helps ...
|
|
C API: Setting The Result Of An SQL Function
(c3ref/result_blob.html)
sqlite3_result_blob(), sqlite3_result_blob64(), sqlite3_result_double(), sqlite3_result_error(), sqlite3_result_error16(), sqlite3_result_error_toobig ...
... If these routines are called from within the different thread
than the one containing the application-defined function that received
the sqlite3_context pointer, the results are undefined.
See also lists of
Objects,
Constants, and
Functions.
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... The pager module effectively controls access for separate threads, or
separate processes, or both. Throughout this document whenever the
word "process" is written you may substitute the word "thread" without
changing the truth of the statement.
3.0 Locking
From ...
|
|
Architecture of SQLite
(arch.html)
... Lemon also generates a parser which is reentrant and thread-safe.
And Lemon defines the concept of a non-terminal destructor so
that it does not leak memory when syntax errors are encountered.
The grammar file that drives Lemon and ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... You can
adjust this behavior from C code using the
sqlite3_busy_handler() or sqlite3_busy_timeout()
API functions.
(6) Is SQLite threadsafe?
Threads are evil.
Avoid them.
SQLite is threadsafe. We make this concession since many users choose
to ignore the advice given ...
|
|
Books About SQLite
(books.html)
... O'Reilly Media
O'Reilly
SQLite is a small, zero-configuration, custom-tailored, embeddable,
thread-safe, easily maintainable, transaction-oriented, SQL-based,
relational database management system. There is no separate install or
setup procedure to initialize SQLite before using it ...
|
|
How SQLite Is Tested
(testing.html)
8.4. Mutex Asserts
... Depending on
compile-time options, the default mutex system contains interfaces
sqlite3_mutex_held() and sqlite3_mutex_notheld() that detect
whether or not a particular mutex is held by the calling thread.
These two interfaces are used extensively within assert() statements
in SQLite to ...
|
|
How To Compile SQLite
(howtocompile.html)
3. Compiling The Command-Line Interface
... But
since the CLI is single threaded, we could instruct SQLite to build
in a non-threadsafe mode and thereby omit the pthreads library:
gcc -DSQLITE_THREADSAFE=0 shell.c sqlite3.c -ldl -lm -o sqlite3
The -ldl library is needed ...
|
|
SQLite Older News
(oldnews.html)
... This release also includes a new sorter that is able to use multiple
threads to help with large sort operations. (Sort operations are
sometimes required to implement ORDER BY and/or GROUP BY clauses and
are almost always required for ...
|
Page generated by FTS5 in about 168.32 ms.