Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Atomic Commit In SQLite
(atomiccommit.html)
2. Hardware Assumptions
... As currently implemented (version 3.5.0) this
method still returns a hard-coded value of 512 bytes, since there
is no standard way of discovering the true sector size on either
Unix or Windows. But the method is available ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... On
Windows it uses the LockFile(), LockFileEx(), and UnlockFile() system
calls. SQLite assumes that these system calls all work as advertised. If
that is not the case, then database corruption can result. One should
note that POSIX advisory locking is ...
|
|
Generated Columns
(gencol.html)
2.3. Limitations
... The expression may not use subqueries,
aggregate functions, window functions, or table-valued functions.
The expression of a generated column may refer to other generated columns
in the same row, but no generated column can depend upon itself, either
directly ...
|
|
How To Download Canonical SQLite Source Code
(getthecode.html)
4. Verifying That The Code Is Unmodified
... make verify-source
Or on windows:
nmake /f Makefile.msc verify-source
Using the makefile to verify source integrity is good for detecting
accidental changes to the source tree, but malicious changes could
be hidden by also modifying the makefiles.
|
|
The Checksum VFS Shim
(cksumvfs.html)
2. Compiling
... To build the checksum VFS module into a run-time loadable
extension, use commands similar to the following:
(linux) → gcc -fPIC -shared cksumvfs.c -o cksumvfs.so
(mac) → clang -fPIC -dynamiclib cksumvfs.c -o cksumvfs.dylib
(windows) &rarr ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... On Windows,
Microsoft's documentation says that locking may not work under FAT
filesystems if you are not running the Share.exe daemon. People who
have a lot of experience with Windows tell me that file locking of
network files ...
|
|
Recent SQLite News
(news.html)
... The Windows makefile ("Makefile.msc") also now
runs without TCL. Note, however, that TCL is still required to run
tests or to build tools such as sqlite3_analyzer that link against
libtcl.
There are other minor enhancements in the 3.48 ...
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... scalar functions and window functions.
2. List of built-in aggregate functions
avg(X)
count(*)
count(X)
group_concat(X)
group_concat(X,Y)
max(X)
min(X)
string_agg(X,Y)
sum(X)
total(X)
3. Descriptions of built-in aggregate functions ...
|
|
Why SQLite Does Not Use Git
(whynotgit.html)
3.3. Fossil Access
... Here are the steps for unix.
(Windows is similar.)
Download the self-contained Fossil executable from
https://fossil-scm.org/fossil/uv/download.html and put the executable
somewhere on your $PATH.
mkdir ~/fossils
fossil clone https://sqlite.org/src ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The SQLITE_FCNTL_WIN32_AV_RETRY opcode is used to configure automatic
retry counts and intervals for certain disk I/O operations for the
windows VFS in order to provide robustness in the presence of
anti-virus programs. By default, the windows VFS will ...
|
Page generated by FTS5 in about 97.48 ms.