Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Shared-Cache Mode
(sharedcache.html)
2. Shared-Cache Locking Model
Externally, from the point of view of another process or thread, two
or more database connections using a shared-cache appear as a single
connection. The locking protocol used to arbitrate between multiple
shared-caches or regular database users is ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.13. The function method
... The function will not be accessible to
triggers, views, CHECK constraints, generated columns, or index
expressions. This option is recommended for all application-defined
SQL functions, and is highly recommended for any SQL
function that has side effects or that ...
|
|
Books About SQLite
(books.html)
... The authors (both members of the Symbian
engineering team responsible for the implementation of the code)
show you how to design code
and ease migration from an internal and external point of view,
plus they reveal the dos and don ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... There are, of course, other ways to interpret an SQL database schema,
and the techniques described here work equally well under alternative
interpretations, but an object-oriented view seems be more natural
to most contemporary programmers.
Capture Changes Using Triggers ...
|
|
Isolation In SQLite
(isolation.html)
... The attempt by X to escalate its
transaction from a read transaction to a write transaction fails with an
SQLITE_BUSY_SNAPSHOT error because the snapshot of the database being
viewed by X is no longer the latest version of the database ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
3.11. 1 Deleting The Rollback Journal
... Deleting a file is not really an atomic operation, but
it appears to be from the point of view of a user process.
A process is always able to ask the operating system "does
this file exist?" and the process ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... From the point of view of the pager the database consists of
a single file of uniform-sized blocks. Each block is called a
"page" and is usually 1024 bytes in size. The pages are numbered
beginning with 1. So ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... statement handle may
be reset at this point without affecting the results of the query
from the point of view of the caller. If sqlite3_reset() were not
called at this point, the next call to sqlite3_step() would return
SQLITE_MISUSE.
Return ...
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
1.1. How To Provide Feedback
... If you disagree with any of the opinions offered in this document, you are
welcomed to offer corrections and/or contrary views on the
SQLite Forum. Or you can email the author
directly.
|
|
Command Line Shell For SQLite
(cli.html)
7.1. Writing results to a file
... If the ".output" or ".once" commands have a "-x" argument, that causes
them to accumulate output as Comma-Separated-Values (CSV) in a temporary
file, then invoke the default system utility for viewing CSV files
(usually a spreadsheet program) on ...
|
Page generated by FTS5 in about 110.75 ms.