Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Initialize The SQLite Library
(c3ref/initialize.html)
sqlite3_initialize(), sqlite3_shutdown(), sqlite3_os_init(), sqlite3_os_end()
... Appropriate
implementations for sqlite3_os_init() and sqlite3_os_end()
are built into SQLite when it is compiled for Unix, Windows, or OS/2.
When built for other platforms
(using the SQLITE_OS_OTHER=1 compile-time
option) the application must supply a suitable implementation for ...
|
|
RETURNING
(lang_returning.html)
... The RETURNING clause may not contain top-level aggregate functions or
window functions. If there are subqueries in the RETURNING clause,
those subqueries may contain aggregates and window functions, but
aggregates cannot occur at the top level.
The RETURNING clause ...
|
|
Memory-Mapped I/O
(mmap.html)
... Hence, on Windows,
if an operation such as VACUUM or auto_vacuum tries to reduce the
size of a memory-mapped database file, the size reduction attempt will
silently fail, leaving unused space at the end of the database file.
No ...
|
|
Powersafe Overwrite
(psow.html)
... The default VFSes for unix and windows have always returned 512 as
the sector size (or blast radius) for all versions of SQLite up to
and including version 3.7.9.
Newer disk drives have begun using 4096 byte sectors ...
|
|
C API: Memory Allocation Subsystem
(c3ref/free.html)
sqlite3_malloc(), sqlite3_malloc64(), sqlite3_realloc(), sqlite3_realloc64(), sqlite3_free(), sqlite3_msize()
... The
Windows VFS uses native malloc() and free() for some operations.
The sqlite3_malloc() routine returns a pointer to a block
of memory at least N bytes in length, where N is the parameter.
If sqlite3_malloc() is unable to obtain sufficient ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... When SQLite is ported to new operating systems (operating systems
other than Unix, Windows, and OS/2 for which ports are provided together
with the core)
two new functions, sqlite3_os_init() and sqlite3_os_end(), must
be provided as part of the port ...
|
|
SQLite Keywords
(lang_keywords.html)
... ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WINDOW
WITH
WITHOUT
This page last modified on 2022-11-26 14:56:19 UTC
|
|
SQLite In 5 Minutes Or Less
(quickstart.html)
... The name of the CLI program is "sqlite3"
(or "sqlite3.exe" on Windows). Use the CLI for manual interactions with
a database.
At a shell or DOS prompt, enter: "sqlite3 test.db". This will
create a new database named "test ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
8.6. Race condition in recovery on Windows systems
SQLite version 3.7.16.2 fixes a subtle race condition in the locking
logic on Windows systems. When a database file is in need
of recovery because the previous process writing to it crashed in the
middle of a ...
|
|
SQLite Download Page
(download.html)
... 58352ee49880019efaba4fc8c6470c3a700e6ddd5e0d56310c64fdfc0cef44df)
Precompiled Binaries for Windows
sqlite-dll-win-x86-3500100.zip(1.02 MiB)
32-bit DLL (x86) for SQLite version 3.50.1.(SHA3-256: fe382cfa167021ad5789907c0afae762c75fa0a3f92fe38e1a456fe6747a36d9)
sqlite-dll-win-x64-3500100.zip(1.28 MiB)
64-bit DLL (x64 ...
|
Page generated by FTS5 in about 87.48 ms.