Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Amalgamation Versus Canonical Sources
(amalg-v-canon.html)
3. How To Compile From Canonical Sources
To compile SQLite from canonical sources, you
download a tarball or ZIP archive of the canonical source tree, unpack
that archive, then run either
"./configure && make" on unix or
"nmake /f Makefile.msc" on Windows.
More details available at the ...
|
|
Hints for Debugging SQLite
(debugging.html)
... const Trigger*);
void sqlite3ShowTriggerList(const Trigger*);
void sqlite3ShowTriggerStep(const TriggerStep*);
void sqlite3ShowTriggerStepList(const TriggerStep*);
void sqlite3ShowWindow(const Window*);
void sqlite3ShowWinFunc(const Window*);
These routines are not APIs and are subject to change. They are
for interactive debugging use only.
Breakpoints ...
|
|
Row Values
(rowvalue.html)
3.1. Scrolling Window Queries
Suppose an application wants to display a list of contacts
in alphabetical order by lastname, firstname, in a scrolling window
that can only show 7 contacts at a time. Initializing the scrolling
window to the first 7 entries is easy ...
|
|
Custom Builds Of SQLite
(custombuild.html)
... The sqlite3.c code file should compile and
run on any Unix, Windows system without any changes
or special compiler options. Most applications can simply include
the sqlite3.c file together with the other C code files that make
up ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
3. General Findings
... SQLite is much faster than direct writes to disk on Windows
when anti-virus protection is turned on. Since anti-virus software
is and should be on by default in Windows, that means that SQLite
is generally much faster than ...
|
|
Run-Time Loadable Extensions
(loadext.html)
3. Compiling A Loadable Extension
... To compile on Windows using MSVC, a command similar to the following
will usually work:
cl YourCode.c -link -dll -out:YourCode.dll
To compile for Windows using MinGW, the command line is just like it
is for unix except ...
|
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... On windows, the first component of an absolute path
is a drive specification (e.g. "C:").
The query component of a URI may contain parameters that are interpreted
either by SQLite itself, or by a custom VFS implementation.
SQLite and ...
|
|
Command Line Shell For SQLite
(cli.html)
1.3. Double-click Startup On Windows
Windows users can double-click on the sqlite3.exe icon to cause
the command-line shell to pop-up a terminal window running SQLite. However,
because double-clicking starts the sqlite3.exe without command-line arguments,
no database file will ...
|
|
Quality Management
(qmplan.html)
3. Software Development Environment
... The OS can be Linux, Mac, Windows, *BSD, Solaris, or some other.
A C99 compiler such as GCC (including MinGW variants for Windows),
Clang, or MSVC
A text editor of the user's choice supporting UTF-8 text.
Tcl version ...
|
|
Compile-time Options
(compile.html)
11. Windows-Specific Options
SQLITE_WIN32_HEAP_CREATE
This option forces the Win32 native memory allocator, when enabled, to
create a private heap to hold all memory allocations.
SQLITE_WIN32_MALLOC_VALIDATE
This option forces the Win32 native memory allocator, when enabled, to
make strategic calls into the HeapValidate() function ...
|
Page generated by FTS5 in about 105.12 ms.